java.sql.BatchUpdateException: error occurred during batching:

One Star

java.sql.BatchUpdateException: error occurred during batching:

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
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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.
One Star

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

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
One Star

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

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 .
Moderator

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

Hi,
Is there any "reject" row in tVerticaOutput?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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 Smiley Happy
One Star

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

is the issue resolved?