What does the below warning code means and its impact on the engine. BW-JDBC-100041 BW-JDBC-100042 BW-JDBC-100043
Article ID: KB0077598
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | 5.x |
Description
--
Warn [BW-Plugin] BW-JDBC-100041 No connection received
Warn [BW-Plugin] BW-JDBC-100042 Cannot establish the connection, trying again
Warn [BW-Plugin] BW-JDBC-100043 Job-14086: connection retry = 24881
--
These warning message indicates that all the connections in the DB connection pool are exhausted (meaning currently used by other activities). The current activity is re-trying to get the connection from the DB connection pool. "connection retry" indicates that BW is trying to get a valid connection from connection pool and the number shows the retry count. If all the connections in the pool was held by other processes, later process will continuously try to get one connection from the pool until success or reaches its timeout value.
Environment
ALL
Resolution
1. Use throttling (Flowlimit, MaxJobs) in process starter executing the JDBC activity.
2. Increase the max DB connection number setting in the “JDBC Connection” activity.
2. Increase the max DB connection number setting in the “JDBC Connection” activity.
Issue/Introduction
What does the below warning code means and its impact on the engine.
BW-JDBC-100041
BW-JDBC-100042
BW-JDBC-100043
Feedback
Yes
No
Powered by
