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