topic Re: tOracleOuput - ArrayIndexOutOfBoundsException in Talend Studio

tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Sat, 16 Nov 2024 11:49:33 GMT

I've just installed Talend Studio version 5.3.1
I have a job which runs fine in version 4.2
Using tOracleOutput to insert in a 11.2.0.3.0 version database, I now have this error :
Exception in component tOracleOutput_1
java.lang.ArrayIndexOutOfBoundsException: -32663
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2673)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10689)
at atq.stakeholder_0_1.Stakeholder.tOracleInput_1Process(Stakeholder.java:3801)
at atq.stakeholder_0_1.Stakeholder.tOracleInput_12Process(Stakeholder.java:2427)
at atq.stakeholder_0_1.Stakeholder.tCreateTable_1Process(Stakeholder.java:1198)
at atq.stakeholder_0_1.Stakeholder.runJobInTOS(Stakeholder.java:15487)
at atq.stakeholder_0_1.Stakeholder.main(Stakeholder.java:15281)
The buffer size for the tOracleOutput component is 10000. The first commit is done, but after 20000 (the 2nd commit) the error is triggered.
I've tried updating the ojdbc but it had no impact.
I know that there is a workaround by using a buffer size of 1000, but it is not a solution for me.
I want to know if there is a better solution or if I am missing something.
Thank you for your time.

Re: tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Fri, 22 Nov 2013 19:49:55 GMT

Got a reply from Talend support.
"After further investigating this issue it seems that this is a limitation of the OJDBC driver.
You would need to overwrite the ojdbc14 diver within the studio with the attached driver."
Everything is working now.

Re: tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Fri, 18 Apr 2014 21:17:45 GMT

I am still having this issue that is described in the original post.
I don't know how to 'overwrite' the ojdbc driver.
However, I do have both ojdbc6.jar and ojdbc14.jar in the following folders/locations:
TOS/lib/java
oracle/product/.../jdbc/lib
My version of TalenD DI (5.4.1.r111943) is requiring the ojdbc6.jar for my tOracleOutput(s) that are connections to an Oracle 10.2.0.2 database. I am unable to process more than 10000 rows of data for any Oracle output. Some help would be greatly appreciated. I have another environment that is running TalenD DI (5.2.0.92826) some exact jobs and connections to the same Oracle DB 10.2.0.2 and it works just fine. Locations of the ojdbc#.jar files is identical.
Error:
Exception in component tOracleOutput_1
java.lang.ArrayIndexOutOfBoundsException: -32703
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2677)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9270)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210)

Re: tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Mon, 21 Apr 2014 08:19:35 GMT

Hi bfausett ,
Here is a response in your another topic https://community.talend.com/t5/Design-and-Development/ArrayIndexOutOfBoundsException-TOS5-4-tOracleOutput-ojdbc6-jar/td-p/96467, please have a look at it.
Best regards
Sabrina

Re: tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Wed, 25 Apr 2018 08:53:56 GMT

Hi,
We are not able to see the response for the solution can you share the once again...
Thanks
Rick

Re: tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Thu, 26 Apr 2018 08:21:42 GMT

Hello,

Feel free to post your issue here with more detailed information.

Best regards

Sabrina

Re: tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Thu, 26 Apr 2018 12:31:18 GMT

Hi @xdshi,

Thanks in advance,

I have tried the solutions which are provided in previous link but its not useful enough to fix the issue which i am facing ,Kindly see the attched error details for the same.

I am using ojdbc6.jar and TOS 6.1.1. still facing the same issue again and again, The job is failing whenever i tried to execute the same as standalone job on unix box.

Error Details :

Exception in component tOracleOutput_1
java.lang.ArrayIndexOutOfBoundsException: -32453
@AToracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2677)
@AToracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9270)
@AToracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210)

Thanks

Rick

Re: tOracleOuput - ArrayIndexOutOfBoundsException

manodwhb — Thu, 26 Apr 2018 13:36:47 GMT

@Ricky9905,this is Jars issue,did you verified below link?

https://community.talend.com/t5/Archive/tOracleInput-doesn-t-work-on-TOS-2-4/td-p/168948

Re: tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Thu, 26 Apr 2018 14:56:31 GMT

Thanks for the info will try and confirm

Re: tOracleOuput - ArrayIndexOutOfBoundsException

Anonymous — Mon, 04 Nov 2019 11:38:34 GMT

Hi,

my solution was setting a number less than 10000 in commit size. In tOracleOutput--> Advanced Settings: Use Batch BatchSize=500 (you can try empirically another number) See the image attached.

Best regards

jaiko

java.lang.ArrayIndexOutOfBoundsException -32573.png