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;;
@TIRUMALA DEVI , check the max connection pool settings configured in the application server, looks like the setting is not enough to meet the demands of parallel connections, ideally, it should be 60. This is something that needs to be configured in respective application server configuration forms.