IBM Support

DB2 error during server rename: Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch

Troubleshooting


Problem

During a server rename getting an error in the log files, Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch, when using IBM Rational Team Concert (RTC).

Symptom

Errors reported in the log files during a server rename:

Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.

The full stack trace of the error:


[com.ibm.team.repository.service.mapping.internal.ServerRenameService] ERROR sqlExceptionLogger

                                  - SQL: UPDATE "RICALM"."REQUEST_HISTORY"  SET "URL" = ?, "EXTERNAL_ID" = ?  WHERE "

REQUEST_HISTORY_ID" = ?

SQL Exception #1

SQL Message: [jcc][t4][102][10040][4.14.88] 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

SQL State: null

Error Code: -4229

SQL Exception #2

SQL Message: Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=4.14.88

SQL State: 40506

Error Code: -1476

Exception Details: Transaction rollback

SQL Exception #3

SQL Message: [jcc][103][10843][4.14.88] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is

terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null

SQL State: null

Error Code: -4225

com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.14.88] 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

Cause


The error is caused by the DB2 Transaction log for the Data Warehouse becoming full and not able to process the full batch operation.

Resolving The Problem

  1. Increase the LogFilSiz, LogPrimary, and LogSecond for the Data Warehouse.
  2. Stop the IBM Collaborative Lifecycle Management (CLM) server and re-start it. This should start the processing of the batch process.

Changing the LogFilSiz, LogPrimary, and LogSecond variable is illustrated under the topic of Tuning transaction log characteristics in the IBM DB2 Information Center.

Related Information

[{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"4.0;4.0.0.1;4.0.0.2;4.0.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Team Concert

Document Information

Modified date:
16 June 2018

UID

swg21623212