Support Article
SQL query required to delete a particular ruleset version
SA-45471
Summary
The system stops working when a particular ruleset is deleted using the Delete a Ruleset wizard. The requirement is for an SQL query to delete a particular ruleset version.
Error Messages
Not Applicable
Steps to Reproduce
Perform the below processes from the Designer Studio:
- Merge the Ruleset version 02-01-30.
- RAP import the Ruleset version 02-01-30.
- Re-Validate and save the Ruleset version 02-01-30.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Perform the following local-change:
Enter SQL statements similar to the following to delete the RuleSet if the name of the ruleset is AbcdEfg:01-01-04:
- SQL> delete from pr4_base where pyRuleSet = ‘AbcdEfg’ and pyRuleSetVersion = ’01-01-04’
- SQL> delete from pr4_fieldvalue where pyRuleSet = ‘AbcdEfg’ and pyRuleSetVersion = ’01-01-04’
- SQL> delete from pr4_rule where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
- SQL> delete from pr4_rule_file where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
- SQL> delete from pr4_rule_flow where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
- SQL> delete from pr4_rule_property where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
- SQL> delete from pr4_rule_sysgen where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
- SQL> delete from pr4_rule_vw where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
Published February 5, 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.