Unable to get a connection to resource. Pool state error

, ,
1

Hi,
We are getting below error in Production.

[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource SMI:SMI_NoTx_JDBCAdapter. [ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource SMI:SMI_NoTx_JDBCAdapter. Pool state error in SMI:SMI_NoTx_JDBCAdapter. Cannot process resquest.
[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource SMI:SMI_NoTx_JDBCAdapter.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource SMI:SMI_NoTx_JDBCAdapter. Pool state error in SMI:SMI_NoTx_JDBCAdapter. Cannot process request.
The properties setting for SMI:SMI_NoTx_JDBCAdapter is as below :
SMI:SMI_NoTx_JDBCAdapter Details
Connection Type: JDBC Adapter Connection
Package Name: DatabaseConnections
Connection Properties
Transaction Type: NO_TRANSACTION
DataSource Class: oracle.jdbc.pool.OracleDataSource
serverName: lsmipen1.lex.lexmark.com
user: smi
password ******
databaseName: lsmipen1
portNumber: 1533
networkProtocol:
Other Properties: driverType=thin
Connection Management Properties
Enable Connection Pooling: true
Minimum Pool Size: 0
Maximum Pool Size: 15
Pool Increment Size: 1
Block Timeout (msec): 10000
Expire Timeout (msec): 60000
Startup Retry Count: 0
Startup Backoff Timeout (sec): 10

Any help is highly appreciated.
Thanks in Advance
Soumodip:happy:

2

Hi Soumodip,

This can happen due to multiple reasons.

  1. Database is down
  2. Network problem between your IS and DB machines
  3. Change of DB User password
  4. JDBC Pool is flooded and no connection is available

What is the version of IS and what fixes are applied.
Did you try finding “ART.118.5053” error in advantage?

Can you highlight what changes were made before you started getting this error.

Regards,
Sumit