Getting Error 'java.sql.SQLRecoverableException: IO Error: Connection reset by peer' Running Batch of Data Transformations (DTs) (Doc ID 2997222.1)

Last updated on JANUARY 30, 2024

Applies to:

Symptoms

When trying to execute a batch containing Data Transformations (DTs), the batch fails with the following error at the top of the TRANSFORM_DATA_<INFODOM>_1696573464470_20230930_2_Task2_DT.log:

[05-10-23 23:38:34,224 MST PM] [DEBUG] [BACKEND] [NA] [NA] Connection Type getting used -> null
[05-10-23 23:45:29,532 MST PM] [ERROR] [BACKEND] [NA] [NA] Error while initializing ApplicationResources.
java.sql.SQLRecoverableException: IO Error: Connection reset by peer, Authentication lapse 0 ms.
       at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:874) ~[ojdbc8.jar:19.3.0.0.0]
       at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) ~[ojdbc8.jar:19.3.0.0.0]
       at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) ~[ojdbc8.jar:19.3.0.0.0]
       at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) ~[ojdbc8.jar:19.3.0.0.0]
       at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) ~[ojdbc8.jar:19.3.0.0.0]
       at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_381]
       at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_381]
       at com.ofs.aai.database.generic.GenericDataSource.getConnection(GenericDataSource.java:100) ~[aai-core.jar:?]
       at com.ofs.aai.database.generic.dflt.jdbc.OracleDataSource.getConnection(OracleDataSource.java:105) ~[aai-core.jar:?]
       at com.ofs.aai.global.ApplicationResources.getConfigConnection(ApplicationResources.java:439) ~[aai-core.jar:?]
       at com.ofs.aai.global.ApplicationResources.reinitialize(ApplicationResources.java:354) [aai-core.jar:?]
       at com.ofs.aai.global.ApplicationResources.getInstance(ApplicationResources.java:177) [aai-core.jar:?]
       at com.ofs.aai.engine.dmt.Postman.initializeLogger(Postman.java:165) [aai-dmt-engine.jar:?]
       at com.ofs.aai.engine.dmt.Postman.main(Postman.java:119) [aai-dmt-engine.jar:?]
Caused by: java.io.IOException: Connection reset by peer, Authentication lapse 0 ms.
       at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:870) ~[ojdbc8.jar:19.3.0.0.0]
       ... 13 more

You restarted the OFSAA services and tested the same batch but it's still failing with same error.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.