Troubleshooting: Unexpected large numbers of queries to pr_engineclasses table causes unnecessary DB traffic (HFix-4114)
As a database administrator (DBA), you run a Top SQL database report to identify the SQL statements that are producing the highest load on the system. The report reveals an unexpected and excessive number of queries to the pr_engineclasses table coming from PRPC 6.1 SP2.
Problematic Query Syntax
select pzbinarycontent, pzstate
where pzpackage = ? and pzclass = ? and pzjar = ? and pzcodeset = 'pega-enginecode' and pzcodesetversion = ?
ORDER BY pzpatchdate DESC
HFix-4114 for PRPC 6.1 SP2 changes the implementation to eliminate the unnecessary queries to the pr_engineclasses table which were causing excessive DB traffic.
- Contact Pegasystems Global Customer Support (GCS) and request HFix-4114.jar for PRPC 6.1 SP2.
- Follow the instructions in the ReadMe.txt file included with the hotfix.