Support Article
Observing the DB Alerts PEGA0042 in log file many times
SA-525
Summary
Alert PEGA0042 - Packaging of database query has exceeded operation time threshold - found in Pega alert log
Performance team is seeing below DB Alert query repeating many times for our Pega application. Per the details this query I understand that is to access certificate details (key store) from database.
Pega application is making call to 8 Soap service to load the data which are secured by certificates. I’m not sure but I think below queries could be to pull key store details for those service.
I need your recommendation on this behavior if this is expected or could this be matter of concern as it is taking time quite good amount of time in performing this DB transaction.
11:33 --> Below DB Alerts generated during this timeframe
Error Messages
There are no specific error messages, the following alerts are found in Pega alert log:
11:33 PEGA0042 PEGA0042 1109 select pzPVStream from pr_data_admin where pzInsKey = ? inserts: <DATA-ADMIN-SECURITY-KEYSTORE WSP>
11:33 PEGA0042 PEGA0042 2632 select pzPVStream from pr_data_admin where pzInsKey = ? inserts: <DATA-ADMIN-SECURITY-KEYSTORE WSP>
Steps to Reproduce
Running performance test against PRPC with 50 concurrent Users on one JVM with peak hourly volume of 500 times calls.
Root Cause
There are no fundamental issues with the loading of the keystore from the database.
Resolution
Even though there are no fundamental issues with the loading of the keystore, the system can be finetuned by changing the following settings:
- The Maximum Idle Requestors and the Maximum Active Requestors in the Pooling settings of the service package
- The maxRequestorChildren setting in the prconfig.xml
Published March 21, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.