Question
Tata Consultancy Services
GB
Last activity: 4 Nov 2021 4:36 EDT
Datasource connection timeout in pegamarketing
Hi All,
We are using Pega V7.2.2 and marketing .My service activity runs a dataflow. Often service activity failed to give response, when i verify log file found that DB connection there were several timeout errors in log file.
Can any one throw some insight why this timeout happening only for few times?
- Error occurred performing a "read" operation in a transaction;com.pega.pegarules.pub.database.ConnectionException: Database-General Problem encountered when getting connection for database ihstore 0 Cannot get a connection, pool error Timeout waiting for idle object;DatabaseException caused by prior exception: java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object; | SQL Code: 0 | SQL State: null;;