Batch Cannot Handle Multi Threaded Jobs With Error "java.sql.SQLRecoverableException: IO Error: Connection reset" (Doc ID 2012187.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Utilities Framework - Version 4.2.0.2.0 and later
Information in this document applies to any platform.

Symptoms

Submit job using submitjob.sh for several times, in this customer's case, if the job submited less than 6 time, the job runs fine.
If submit for over 6 times, the jobs starting failure with error:

(DEVBCH: submitjob.TD-XAIDN.20150514172243744.26617.log):
-  2015-05-14 17:26:38,648 [main] ERROR (shared.common.UCPConnectionProvider) Unexpected Pool Setup Exception
java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Connection reset
        at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
        at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:928)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:855)
        at com.splwg.shared.common.UCPConnectionProvider.configure(UCPConnectionProvider.java:167)
        at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:75)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:159)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess(JdbcServicesImpl.java:223)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:89)
        at com.splwg.base.support.hibernate.OuafJdbcServicesImpl.configure(OuafJdbcServicesImpl.java:17)
        at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:75)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:159)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:71)
        at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2273)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2269)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1738)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1778)
        at com.splwg.base.support.context.ApplicationContext.buildSessionFactory(ApplicationContext.java:201)
        at com.splwg.base.support.context.ContextFactory.buildContext(ContextFactory.java:127)
        at com.splwg.base.support.context.ContextFactory.createCobolWrapperContext(ContextFactory.java:585)
        at com.splwg.base.api.batch.StandaloneExecuter.setupContext(StandaloneExecuter.java:338)
        at com.splwg.base.api.batch.StandaloneExecuter.run(StandaloneExecuter.java:135)
        at com.splwg.base.api.batch.StandaloneExecuter.main(StandaloneExecuter.java:433)
        at com.splwg.base.api.batch.AbstractStandaloneRunner.invokeStandaloneExecuter(AbstractStandaloneRunner.java:547)
        at com.splwg.base.api.batch.AbstractStandaloneRunner.run(AbstractStandaloneRunner.java:179)
        at com.splwg.base.api.batch.SubmitBatch.run(SubmitBatch.java:64)
        at com.splwg.base.api.batch.SubmitBatch.main(SubmitBatch.java:41)
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Connection reset

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