pr_sys_ruleset_index table is growing exponentially
After upgrade to Pega 7.1.9, pr_sys_ruleset_index table is growing exponentially without any cleanup of records.
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.
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.
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
50% found this useful