Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Deleting corrupted business rules from an Oracle repository

Deleting corrupted business rules from an Oracle repository

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

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:16
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.