Summary

Error Messages

Steps to Reproduce

1. Perform a private edit of a rule.
2. Click the "Private" icon to see the list of the privately checked-out rules.
3. Observe that the rule from step 1 is not present in the list.

Root Cause

Resolution

1. Add the missing database triggers.
2. Run the following SQL update statements in the rules schema to get the triggers to fire to correctly populate the pr4_rule_vw table that missed the checked out rules:
   UPDATE pr4_base SET pzinskey=pzinskey;
   UPDATE pr4_fieldvalue SET pzinskey=pzinskey;
   UPDATE pr4_rule SET pzinskey=pzinskey;
   UPDATE pr4_rule_autotest SET pzinskey=pzinskey;
   UPDATE pr4_rule_flow SET pzinskey=pzinskey;
   UPDATE pr4_rule_property SET pzinskey=pzinskey;
   UPDATE pr4_rule_sysgen SET pzinskey=pzinskey;
   UPDATE pr4_rule_file SET pzinskey=pzinskey;
   UPDATE pr4_rule_file_binary SET pzinskey=pzinskey;
   UPDATE pr4_rule_requirement SET pzinskey=pzinskey;
   UPDATE pr4_rule_usecase SET pzinskey=pzinskey;
   UPDATE pr4_rule_shortcut SET pzinskey=pzinskey;
   UPDATE pr4_rule_declarepages SET pzinskey=pzinskey;
   UPDATE pr4_rule_ruleset SET pzinskey=pzinskey;