Non atomic batch failure message with TMap

One Star

Non atomic batch failure message with TMap

I've got this message in one of my job, don't know what it means:
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.
Can sbdy tell me what should I do to avoid it ?
Thanks for your help !
Community Manager

Re: Non atomic batch failure message with TMap

This error usually occurs on tPosgreSqlxxx component. It is an type of error message thrown by the Posgresql driver. In Talend Studio, you can use debug mode to trace the Java code and find out the real cause of this error.
1. Open the Run view and click the Debug Run tab. Select and click the Java Debug button to launch the debug perspective. If a Proceed with launch dialog appears, click the Proceed button to continue.
2. Open the Breakpoints view. Click Add Java Exception Breakpoint button.
3. To add a breakpoint on this kind of exception
Type in "BatchUpdateException".
Find the "BatchUpdateException-java.sql" exception and select it.
Click OK.
4. Click the Resume button to restart Job execution.
5. Open the Variables view. Right-click anywhere. Select Find item.
6. Type "e" in the text field. Click OK. The e variable is predefined with the value "java.sql.BatchUpdateException" in the Talend Job.
7.Expand the next node. Find the detailMessage node.
Talend | Data Agility for Modern Business
One Star

Re: Non atomic batch failure message with TMap

OK thanks for this complete answer !

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.