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