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: []
- 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.
- 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)
...
- 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.
- 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.