Select query for pr4_rule_library table is running more frequently
We are getting below alert many times in the logs. Not sure if it is common. We are seeing over 800 times on each node.
Alert: Database operation took more than the threshold of 500 ms: 653 ms SQL: select pzPVStream , pxCommitDateTime from PEGA_RULES.pr4_rule_library where "PYLIBRARYNAME" = ? and "PYRULESET" = ? and pxObjClass = ? order by "PYDECORATEDFUNCTIONNAME" , "PYRULESETVERSION" , pzInsKey
Accepted Solution
Radial Inc
US
Thank you for your time. This issue was resolved by installing below hotfix:
HFIX-31149:Performance issue of Assembled classes
Pegasystems Inc.
IN
Hi Venkat,
The query seems to be related with PRPC trying to fetch information for RULE-UTILITY-FUNCTION(RUF) frequently. You can use DB trace to understand corresponding to which scenario the query gets generated frequently.
But the query just marginally breaches the threshold of 500 ms and should not be worrying factor.
Regards,
Ujjwal