Support Article
Notification does not display in Designer Studio on locking RSV
SA-59732
Summary
The error notification, Unable to lock a ruleset due to checked-out records, does not display in Designer Studio to inform about any checked out rule. This occurs when attempting to lock a RuleSetVersion (RSV).
Error Messages
An error occurred during resolving the report definition - Table ABC.pwbv4_rule_locking does not exist in database PegaRULES
Steps to Reproduce
- Log in to Designer Studio
- Check out a rule
- Open a ruleset and check the count for Checked Out and Rules currently checked out
Root Cause
An issue in the custom application code or rules.
The out-of-the-box Data-Rule-Locking pzGetCheckedoutRulesForRSV report definition retrieves the count by querying on pwbv4_rule_locking view in the database. However, for the user test connectivity fails for Data-Rule-Locking class with 'Table ABC.pwbv4_rule_locking does not exist in database PegaRULES' error. In the database, for the privileges for pwbv4_rule_locking view, Select Privilege is not granted on the pwbv4_rule_locking view.
Resolution
Perform the following local-change:
Add Select Privilege for pwbv4_rule_locking view in the database.
Published July 23, 2018 - 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.