Support Article
No version information available when searching for rules
SA-23955
Summary
A RAP file was imported which included a new ruleset version.
After importing this, the new version is not listed in the Find by RuleSet, Version, RuleType report (Pega Button > Process and Rules > Tools > Find Rules > Find by RuleSet, Version, RuleType).
If a search is done in the developer portal for rules that should be included in this version of the RuleSet, some rules are listed, but the message "No version information available" is present and clicking the link does not open the rule. It is possible to find and open the rule, but this other behavior suggests there is an issue.
Error Messages
Not Applicable.
Steps to Reproduce
Import a RAP file with a new RuleSet version included and attempt a search for a rule that should be part of that RuleSet.
Root Cause
A defect or configuration issue in the operating environment is causing this issue. The Find by RuleSet, Version, RuleType report queries the pr4_rule_vw table to gather the necessary data. However, a trigger on an associated table was not enabled which led to the pr4_rule_vw table to not contain all the correct data. In 6.2 SP2 all the DB triggers are required for PRPC to function correctly.
Resolution
Make the following change to the operating environment:
Ensure that all Pega provided DB triggers are enabled and run the following update statements to allow the triggers to update related tables appropriately:
update rules.PR4_FIELDVALUE set pzinskey=pzinskey;
update rules.PR4_RULE_SHORTCUT set pzinskey=pzinskey;
update rules.PR4_RULE_AUTOTEST set pzinskey=pzinskey;
update rules.PR4_RULE_RULESET set pzinskey=pzinskey;
update rules.PR4_RULE_FILE set pzinskey=pzinskey;
update rules.PR4_RULE set pzinskey=pzinskey;
update rules.PR4_RULE_FLOW set pzinskey=pzinskey;
update rules.PR4_BASE set pzinskey=pzinskey;
update rules.PR4_RULE_PROPERTY set pzinskey=pzinskey;
Published June 7, 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.