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

• 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)

...

• SAP Manufacturing Execution

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