[resolved] toracleoutput Error

[resolved] toracleoutput Error

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
Moderator

Re: [resolved] toracleoutput Error

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: [resolved] toracleoutput Error

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

 Image
Four Stars

Re: [resolved] toracleoutput Error

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

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

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
Four Stars

Re: [resolved] toracleoutput Error

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

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. 
Four Stars

Re: [resolved] toracleoutput Error

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

Calling Talend Open Studio Users

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

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

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

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

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

Download