Cleanup when removing a record from the CreoleRuleset table.

 

 

Question & Answer

 

 

Question

 

Do I have to do any cleanup if I remove a record from the CreoleRuleset table?

 

 

Answer

 

Yes. Otherwise, you may experience an error the next time you use the creole.upload.rulesets target.

This is because the rule structures defined in the CreoleRuleset table get denormalised into a number of other tables - CreoleRuleClass, creoleRuleAttribute, creoleAttributeAvailability, etc - and these tables may contain records which still reference the records deleted from CreoleRuleset.

The attached SQL script finds and cleans up these unused records.

 

fixDisconnectedRulesetData.sql

 

Document Information

 

More support for:
Merative Social Program Management

 

 

Software version:
7.0.0, 6.2.0, 6.1, 6.0

 

 

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows, z/OS

 

 

Modified date:
17 June 2018