Support Article

Not returning connection 0 for database "pegadata" to the pool

SA-36873

Summary



Frequent Connection pool exceptions in the logs with Pega 7.2.

Error Messages



Not returning connection 0 for database "pegadata" to the pool


Steps to Reproduce



Not Applicable


Root Cause



Number of available connections are insufficient.

Resolution



Make the following change to the operating environment:

1. Insert the following attributes into the Resource element for the jdbc/PegaRULES connection

Not returning connection 0 for database "pegadata" to the pool as it previously encountered the following error:

testOnBorrow="true"
testOnConnect="true"
testOnReturn="true"
testWhileIdle="true"
validationQuery="select 1"



2. Add below entries in PRConfig.xml:

<env name="classmap/usemergestatement" value ="false" />
<env name="database/batchupdates" value="-1" />

Published December 18, 2017 - Updated October 8, 2020


66% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.