2080501 - ORA-00936: missing expression error in PI JDBC Adapter | SAP Knowledge Base Article

SAP Knowledge Base Articles - preview

2080501 - ORA-00936: missing expression error in PI JDBC Adapter


  • The Process Integration (PI) JDBC Receiver adapter operation (e.g. Insert, Update etc) does not reach the target Oracle database
  • An error similar to below is visible in the Log Viewer and/or defaultTrace files:

    Exception caught when executing statement for table/stored proc. '<DatabaseTableName>' (structure 'INSERT_AP1228'):
    java.sql.SQLException: ORA-00936: missing expression
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    #at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    #at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    #at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
    #at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
    #at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
    #at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
    #at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1657)
    #at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
    #at com.sap.aii.adapter.jdbc.SAXHandler.executeUpdate(xml2sql.java:2396)
    #at com.sap.aii.adapter.jdbc.SAXHandler.SQLins(xml2sql.java:2130)
    #at com.sap.aii.adapter.jdbc.SAXHandler.processList(xml2sql.java:822)
    #at com.sap.aii.adapter.jdbc.SAXHandler.endElement(xml2sql.java:708)....





  • PI Release Independent
  • SAP NetWeaver
  • SAP Process Integration
  • Kernel Release 7.20 and higher


SAP NetWeaver all versions ; SAP Process Integration all versions ; mySAP ERP 2004


Process Integration 7.0, PI 7.0, PI 7.01, PI 7.02, Process Integration 7.10, PI 7.10, Process Integration 7.11, PI 7.11, Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.4, PI 7.4, PO 7.4, Process Orchestration 7.5, PI 7.5, PO 7.5, XI, AEX, enhancement pack, Oracle 11g , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.