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:
  1. Merge the Ruleset version 02-01-30.
  2. RAP import the Ruleset version 02-01-30.
  3. 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:
  1. SQL> delete from pr4_base where pyRuleSet = ‘AbcdEfg’ and pyRuleSetVersion = ’01-01-04’
  2. SQL> delete from pr4_fieldvalue where pyRuleSet = ‘AbcdEfg’ and pyRuleSetVersion = ’01-01-04’
  3. SQL> delete from pr4_rule where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
  4. SQL> delete from pr4_rule_file where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
  5. SQL> delete from pr4_rule_flow where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
  6. SQL> delete from pr4_rule_property where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
  7. SQL> delete from pr4_rule_sysgen where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
  8. SQL> delete from pr4_rule_vw where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
Suggest Edit

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.