topic Re: [resolved] toracleoutput Error in Talend Studio

[resolved] toracleoutput Error

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

Hi,
I am trying to update a table using toracleoutput component. At the first execution I was getting the NULL exception error and later socket error. I tried after few hours and I was able to update the records in the table. But the same is not working after hours and the process is going in hung state and I can see the ports are going into time_wait state. It would be great if you could please help me in this resolve this issue,
connecting to socket on port 3843
connected
Exception in component tOracleOutput_1
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3323)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3357)
at temp.secondary_acc_update_alternative_email_linked_account_0_1.Secondary_Acc_Update_Alternative_email_Linked_Account.tFileInputDelimited_3Process(Secondary_Acc_Update_Alternative_email_Linked_Account.java:1308)
at temp.secondary_acc_update_alternative_email_linked_account_0_1.Secondary_Acc_Update_Alternative_email_Linked_Account$2.run(Secondary_Acc_Update_Alternative_email_Linked_Account.java:1878)
Io exception: Connection reset by peer: socket write error

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 08:31:41 GMT

Hi
What's your workflow? Did you use tOracleCommit and tOracleclose in your job design?
Would you mind uploading your job design screenshots into forum?
Best regards
Sabrina

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 08:47:34 GMT

Hi,
Please find the process below.
tFileInputdelimited -> tmap -> toracleoutput -> tOracleCommit -> tOracleClose
And the same has been attached for the reference.
Regards,
Ram

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 08:49:51 GMT

Image

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 09:40:37 GMT

Hi,
In tPreJob use Oracle connection component and enable autocommit..
Remove your last two component and set use connection option in tOracleOutput and check again.
Thanks
Vaibhav

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 11:39:25 GMT

Hi Vaibhav,
Changed the graph as per your suggestions and I am able to update.. My file is having 7lak records and it has taken around 30 mins to update 2.5 lak records and process is still on. Will update you.
Thanks a lot for your timely suggestion.
Regards,
Rammohan

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 12:00:21 GMT

Hi Vaibhav,
It would be great if you could please tell me, where the process was, so that I can change the design accordingly in my next graphs.
Regards,
Rammohan

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 12:32:23 GMT

Could not understand the question
where the process was,
There is no process... this is just a suggestion based on experience and problems..

Vaibhav

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 15:00:42 GMT

Hi Vaibhav.
There was a typo error. Is there anything wrong in my process.
Do we need to close the DB connection in the postprocess after the extraction is completed. Please advise.

Re: [resolved] toracleoutput Error

Anonymous — Fri, 01 Aug 2014 15:38:57 GMT

No need to close the connection if you are using autocommit.
Vaibhav