ThreadPoolWorker connnection to database failure due to Connection reset exception (Doc ID 2091057.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 and later
Information in this document applies to any platform.

Symptoms

On : CCB 2.3.1 version,

When attempting to run batch by TPW, the connection to database failed and such error occurs in TPW log file.

ERROR
-----------------------
- 2015-11-14 19:13:48,322 [main] ERROR (support.context.ContextFactory) Error getting connection to database jdbc:oracle:thin:@(DESCRIPTION_LIST = (LOAD_BALANCE = off) (FAILOVER = on) (DESCRIPTION = (CONNECT_TIMEOUT = 35) (TRANSPORT_CONNECT_TIMEOUT = 30) (RETRY_COUNT = 3) (ADDRESS_LIST = (LOAD_BALANCE = on) (ADDRESS = (PROTOCOL = TCP)(HOST = dc1rc001scn)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = MBXP))) (DESCRIPTION = (CONNECT_TIMEOUT = 35) (TRANSPORT_CONNECT_TIMEOUT = 30) (RETRY_COUNT = 3) (ADDRESS_LIST = (LOAD_BALANCE = on) (ADDRESS = (PROTOCOL = TCP)(HOST = dc2rc001scn)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = MBXP)))), with user cisbatch and driver oracle.jdbc.driver.OracleDriver
java.sql.SQLException: Io exception: Connection reset
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:566)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:418)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.splwg.base.support.context.ContextFactory.getConnection(ContextFactory.java:135)
at com.splwg.base.support.context.ContextFactory.getBaseLookupInterfaceNames(ContextFactory.java:144)
at com.splwg.base.support.context.ContextFactory.buildContext(ContextFactory.java:103)
at com.splwg.base.support.context.ContextFactory.buildContext(ContextFactory.java:91)
at com.splwg.base.support.context.ContextFactory.createDefaultContext(ContextFactory.java:512)
at com.splwg.base.api.batch.StandaloneExecuter.setupContext(StandaloneExecuter.java:332)
at com.splwg.base.api.batch.StandaloneExecuter.run(StandaloneExecuter.java:136)
at com.splwg.base.api.batch.StandaloneExecuter.main(StandaloneExecuter.java:431)
at com.splwg.base.api.batch.AbstractStandaloneRunner.invokeStandaloneExecuter(AbstractStandaloneRunner.java:477)
at com.splwg.base.api.batch.AbstractStandaloneRunner.run(AbstractStandaloneRunner.java:143)
at com.splwg.base.api.batch.ThreadPoolWorker.run(ThreadPoolWorker.java:44)
at com.splwg.base.api.batch.ThreadPoolWorker.main(ThreadPoolWorker.java:35)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at oracle.net.ns.DataPacket.send(DataPacket.java:150)
at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:180)
at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:169)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:117)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:92)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:77)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1034)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:760)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
... 18 more
- 2015-11-14 19:13:48,325 [main] ERROR (api.batch.StandaloneExecuter) error initializing test context
- 2015-11-14 19:13:48,326 [main] ERROR (api.batch.StandaloneExecuter) Error encountered in standalone executer
com.splwg.shared.common.LoggedException:
The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.support.context.ContextFactory.createDefaultContext(ContextFactory.java:512): error initializing test context


Meanwhile, in the TPW log file, it also indicates by class path that the JDBC driver is ojdbc5-11.1.0.7.0.jar.

 

 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms