Socket read timed out Whilst Executing Load Plan In ODI
(Doc ID 2350396.1)
Last updated on JUNE 15, 2021
Applies to:JDBC - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Timeout connection whilst executing Load Plan in ODI with JDBC 126.96.36.199.
While executing a Load Plan, it fails always in same step with the following error message:
java.lang.Exception: The application script threw an exception: TableException: Custom Exception: Exception occured when trying to establish Target Connection
If the Load Plan is executed, the same will finish with no errors (sometimes it needs to be re-executed more than once).
WebLogic AdminServer.log shows:
java.sql.SQLRecoverableException: IO Error: Socket read timed out
while the database shows:
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (3975) as a result of ORA-609
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document