My Oracle Support Banner

A 'Non-atomic batch failure' is Signaled With DB2 UDB Database in ODI (Doc ID 424046.1)

Last updated on DECEMBER 18, 2019

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Symptoms

The following error is signaled:

com.ibm.db2.jcc.b.cr: Non-atomic 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.
at com.ibm.db2.jcc.b.f.a(f.java:319)
at com.ibm.db2.jcc.b.cf.executeBatch(cf.java:1762)

 

Case 1

... on trying to import a development Repository in zipped format.

Case 2

... when loading data from Microsoft SQLServer (or other technologies) to DB2 UDB Database.

Case 3

... when loading data from a delimited flat file to a DB2 UDB Database.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 Case 1
 Cases 2 & 3
 How do I activate DB2 UDB Driver log tracing?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.