SAP Knowledge Base Article - Preview

3517358 - Error: "import failed" and "Batch failure" when importing B2B Integration Cockpit objects

Symptom

  • The following or similar error can be seen in B2B Integration Cockpit (EDI Content Manager) when trying to import B2B objects:
    • import failed: set failed: [jcc][t4][102][10040][4.32.35] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null 
      OpenSQLExceptionCategories: []
  • Also, when checking the XPI inspector or default traces the following database exception is seen:
    • SQL error occurred on connection <DB>:<DB>:SAPSR3DB: code=-4,229, state="<null>", message="[jcc][t4][102][10040][4.32.35] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
      => (-803,23505,Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;SAPSR3DB.<TABLE>, DRIVER=4.32.35)"; 
      SQL statement is "INSERT INTO "<B2B_TABLE>" ("CTRL_KEY","CTRL_NAME","DESCR") VALUES (?,?,?)".
      [EXCEPTION]
      com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.32.35] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
      at com.ibm.db2.jcc.am.b7.a(b7.java:502)
      at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:434)
      at com.ibm.db2.jcc.am.ld.a(ld.java:5612)
      at com.ibm.db2.jcc.am.ld.c(ld.java:5186)
      ...
  • Importing without selecting the Overwrite duplicate keys option triggers the above exception.
  • Importing with the Overwrite duplicate keys option completes successfully but results in existing objects being overwritten by new imports.


Read more...

Environment

  • Process Integration
  • Process Orchestration

Product

SAP NetWeaver all versions ; SAP Process Integration all versions

Keywords

Process Integration, Process Orchestration, PI, PO, B2B, EDI Content Manager, B2B Integration Cockpit, import error, EDISearchParametersModule, import failed, Batch failure, ERRORCODE=-4229, SQLSTATE=null, getNextException() , KBA , BC-XI-CON-B2B , B2B add-on (business-to-business) , Problem

About this page

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

Search for additional results

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