Support Article
pr_sys_ruleset_index table is growing exponentially
SA-24917
Summary
After upgrade to Pega 7.1.9, pr_sys_ruleset_index table is growing exponentially without any cleanup of records.
Error Messages
There are no error messages
Steps to Reproduce
- Create a new Ruleset version from ruleset say RS
- Do a "save as" on a rule into the new ruleset version.
Root Cause
A defect in Pegasystems’ code or rules
the function pxAllowsRecordInRuleSet when its build the ruleset version list tries to retrieve all version of given ruleset ( rsvlist.addAll(pega_rules_default.GetRuleSetVersions(rsFromName, true))) and this in turn calls getRulesetPrerequiste and dependentrulesetlistpoolimpl to insert the dependentrulesetlist for every version of given ruleset.
Resolution
Apply Hfix-27767.
With this Hfix applied, only the unlocked versions for ruleset is retrieved.But since “save-as” on a rule fetches and populates the ruleset and ruleset versions that this rule can be saved into, we recommend following best practices to avoid inserting too many records into the table.
- Lock RSV that are not updated frequently.
- Instead of Re-save into new RS version, consider Branch ruleset
Published June 25, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.