Skip to main content

Describes how to delete corrupted business rules from an Oracle repository.

Problem:

Opening the Modernization Workbench (MW) Rules pane fails with the error "Run-time error '457': This key is already associated with an element of this collection."

Resolution:

The business rules in the workspace are corrupted. Ask your DBA to delete the rules from the Oracle repository. The DBA should perform the following queries to delete the entities and rows for the rules:


  • delete from rntrule;
  • delete from rntrulecond;
  • delete from rntruleio;
  • delete from rntrulelog;
  • delete from rntruleset;
  • delete from rntbusinessfunc;
  • delete from RelRuleDescribedInDocument;
  • delete from RelRuleHasRuleIO;
  • delete from RelRuleIsControlledByRuleCond;
  • delete from RelRuleIsLoggedInRuleLog;
  • delete from RelRuleTriggersRuleSet;
  • delete from RelRuleSetContainsRule;
  • delete from RelRuleSetHasRuleIO;
  • delete from RelRuleSetIsControlledByRulCnd;
  • delete from RelRuleSetIsLoggedInRuleLog;
  • delete from RelRuleTriggersRuleSet;
  • delete from RelBusinessFuncHasRuleIO;
  • delete from RelBusinessFuncIsmplmntdByRlSt;
  • delete from RelBusinessFuncsCntrlldByRlCnd;
  • delete from RelBusinessFunctionIsLggdnRlLg;
  • commit;
Old KB# 14707

#EnterpriseAnalyzer
#SupportTip