Support Article
pr_sys_ruleset_index table data grows exponentially
SA-46060
Summary
Performing Save As on a rule in a ruleset version results in multiple insertions in the pr_sys_ruleset_index table.
Error Messages
Not Applicable
Steps to Reproduce
- Create a new ruleset version from a ruleset (for example,RS).
- Perform a 'Save As' on a rule into the new ruleset version.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Apply HFix-36490.
Applying this hotfix retrieves only the unlocked versions of the ruleset. Since performing the 'Save As' on a rule fetches and populates the ruleset and the ruleset versions (that this rule can be saved into), follow the below steps to avoid inserting multiple records into the table.
- Lock the ruleset versions that are not updated frequently.
- Consider the Branch ruleset instead of resaving into a new ruleset version.
Published November 24, 2017 - 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.