1650472 - Transactions are interrupted due to database connection periodically failing to establish | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1650472 - Transactions are interrupted due to database connection periodically failing to establish

Symptom

  • The error message ORA-12704 is thrown during execution of different activities but not on a regular basis.

 

  • com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): javax.resource.ResourceException: (Failed in component: dbpool, BC-JAS-TRH) Cannot create connection. Possible reasons: 1)Maximum allowed connections to DB or EIS is reached. You can apply CSN Note 719778 in order to check and resolve connection leaks. 2) Configuration to DB/EIS is wrong or DB/EIS is temporary unreachable. 3) Connections are not enough for current load.

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:60)

at com.sap.me.frame.AbstractDataSource.getDBConnection(AbstractDataSource.java:411)

at com.sap.me.frame.AbstractDataSource.executeQuery(AbstractDataSource.java:140)

at com.sap.me.frame.BaseDataSource.executeQuery(BaseDataSource.java:182)

...

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:230)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:343)

at com.sap.engine.services.connector.jca.ShareableConnectionManager.allocateConnection(ShareableConnectionManager.java:54)

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:52)

...

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: Exception of type java.sql.SQLRecoverableException caught: IO Error: The Network Adapter could not establish the connection.

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:192)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:221)

...

Caused by: com.sap.sql.log.OpenSQLException: Exception of type java.sql.SQLRecoverableException caught: IO Error: The Network Adapter could not establish the connection.

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:104)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:143)

at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:284)

at com.sap.sql.connect.datasource.DBDataSourceImpl.getConnection(DBDataSourceImpl.java:139)

at com.sap.engine.core.database.impl.DatabaseDataSourceImpl.getConnection(DatabaseDataSourceImpl.java:36)

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:156)

... 

Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)

at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207)

at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139)

at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88)

at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:70)

at com.sap.sql.connect.factory.CPDSPooledConnectionFactory.getPooledConnection(CPDSPooledConnectionFactory.java:27)

at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:651)

at com.sap.sql.connect.datasource.DBDataSourceImpl.create(DBDataSourceImpl.java:995)

at com.sap.sql.connect.datasource.DBDataSourceImpl.create(DBDataSourceImpl.java:43)

at com.sap.sql.connect.pool.CreatedObjectsPool.create(CreatedObjectsPool.java:95)

at com.sap.sql.connect.pool.Pool.get(Pool.java:707)

at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:261)

... 

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:375)

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:678)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:238)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)

...

Caused by: java.net.ConnectException: Connection refused

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

at java.net.Socket.connect(Socket.java:531)

at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:209)

at oracle.net.nt.ConnOption.connect(ConnOption.java:123)

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:353)

...

 


Read more...

Product

SAP Manufacturing Execution 5.1 ; SAP Manufacturing Execution 5.2 ; SAP Manufacturing Execution 6.0

Keywords

character set mismatch, Visiprise, broken database connection , KBA , MFG-ME-PRD , Production Activities , MFG-ME-IM , Installation and Migration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.