Update Query on PEGA_RULES.pr_assembledclasses is running "N" number times in a Sec continuously (Pega 7.2.2)
below query is running n number of times continuously around 100 times a sec
UPDATE PEGA_RULES.pr_assembledclasses
SET pzlastmodified = :1 ,
pzsha1 = :2 ,
pzbinarycontent = :3
WHERE pzjar = :4
AND ( pzpackage = :5
OR pzpackage = :6 )
AND pzclass = :7
AND pzCacheConfigId = :8
AND pzGenerationDate = :9
Please anyone have idea
***Updated by moderator: Lochan to tag SR details***
Accepted Solution
Pegasystems Inc.
US
It sounds like you may be impacted by this issue: https://pdn.pega.com/support-articles/performance-degrades-after-update-pega-722-ruf-assembly I would suggest that you open up an SR to request HFix-31149.
Accepted Solution
Pegasystems Inc.
US
It sounds like you may be impacted by this issue: https://pdn.pega.com/support-articles/performance-degrades-after-update-pega-722-ruf-assembly I would suggest that you open up an SR to request HFix-31149.
Pegasystems Inc.
IN
Hello!
Please let us know if you do log an SR for this and its ID. That way we can track it and follow-up this discussion with the resolution.
Thank you,
Pegasystems Inc.
IN
Thank you!
I've connected the SR to this post and I see that a hotfix has been sent over for you to test!
Regards,