topic Re: java.sql.BatchUpdateException: error occurred during batching: in Talend Studio

java.sql.BatchUpdateException: error occurred during batching:

Anonymous — Sat, 16 Nov 2024 12:45:13 GMT

I'm getting this error when running a Talend job that reads from an Oracle db table and writes to several Oracle db tables:
Exception in component tELTAggregate_2
java.sql.BatchUpdateException: error occurred during batching: No more data to read from socket
at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:571)
at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:626)
at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:6841)
at pat_utilization.patutilizfinal_0_1.PatUtilizFinal.tELTAggregate_2Process(PatUtilizFinal.java:2050)
at pat_utilization.patutilizfinal_0_1.PatUtilizFinal.tELTAggregate_1Process(PatUtilizFinal.java:1544)
at pat_utilization.patutilizfinal_0_1.PatUtilizFinal.tOracleConnection_1Process(PatUtilizFinal.java:1016)
at pat_utilization.patutilizfinal_0_1.PatUtilizFinal.tFileInputDelimited_1Process(PatUtilizFinal.java:894)
at pat_utilization.patutilizfinal_0_1.PatUtilizFinal.runJobInTOS(PatUtilizFinal.java:5791)
at pat_utilization.patutilizfinal_0_1.PatUtilizFinal.main(PatUtilizFinal.java:5644)
This job runs fine at other locations, but I'm getting this every time I run it at a specific client location. I can hit the database and read and write w/o problem (using Oracle SQL Developer) at that location, but the Talend job keeps dying. I can send the exported job if needed.
The step at which it goes belly up is the second of a series of db read/writes. The first step succeeds, it consistently fails at the 2nd step.
This job was developed in Talend v4.1.1. Please let me know what other information i can provide to help troubleshoot this.
Thanks,
Bruce McDougald

Re: java.sql.BatchUpdateException: error occurred during batching:

Anonymous — Tue, 09 Aug 2011 02:01:23 GMT

Hi
Can you check if there is a firewall or antivirus software block the connection to Oracle on the specific client location? Create a oracle connection in metadata and check if it is successful?
Best regards
Shong

Re: java.sql.BatchUpdateException: error occurred during batching:

Anonymous — Wed, 10 Aug 2011 13:56:29 GMT

The Oracle connection is successful, and the first leg of DB processing completes, it's only when trying to complete the second leg of processing that this error occurs.
Steps:
1. File A is read from, and aggregated into File B
2. File B is read from, and aggregated into File C
The remaining steps all read from File C and perform other functions into various other files.
It's during Step 2 that the error occurs, after File B has been populated (verified through Oracle SQL Developer), when trying to read from File B and aggregate into File C.

Re: java.sql.BatchUpdateException: error occurred during batching:

_AnonymousUser — Thu, 31 Oct 2013 10:13:39 GMT

hi

i am loading data from tool to vertica database using tvericaoutput component but getting following error
Exception in component tVerticaOutput_1
java.sql.BatchUpdateException: (100172) One or more rows were rejected by the server.
at com.vertica.jdbc.SStatement.processBatchResults(Unknown Source)
at com.vertica.jdbc.SPreparedStatement.executeBatch(Unknown Source)
at master_project.lookup_operation_0_1.LOOKUP_OPERATION.tFileList_1Process(LOOKUP_OPERATION.java:9603)
at master_project.lookup_operation_0_1.LOOKUP_OPERATION.runJobInTOS(LOOKUP_OPERATION.java:10636)
at master_project.lookup_operation_0_1.LOOKUP_OPERATION.main(LOOKUP_OPERATION.java:10504)

what might be wrong

Re: java.sql.BatchUpdateException: error occurred during batching:

_AnonymousUser — Thu, 31 Oct 2013 10:52:48 GMT

hi
i have checked connection to database its working fine the job has to read around 16,000 files im using tfilelist its giving the above error,if i give 10 files name its loading properly .

Re: java.sql.BatchUpdateException: error occurred during batching:

Anonymous — Fri, 01 Nov 2013 03:40:41 GMT

Hi,
Is there any "reject" row in tVerticaOutput?
Best regards
Sabrina

Re: java.sql.BatchUpdateException: error occurred during batching:

_AnonymousUser — Tue, 05 Nov 2013 05:27:28 GMT

hi

No ,reject link was not used but die on error was checked.
Anyhow got the error it was column data type problem relating to length of data

Re: java.sql.BatchUpdateException: error occurred during batching:

_AnonymousUser — Tue, 26 Apr 2016 13:07:49 GMT

is the issue resolved?