[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
9 REPLIES
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