Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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
Suggest Edit

Published March 21, 2016 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us