Registry-Cleanup utility and the XML which drives it!

registry-cleanup: It can be used to cleanup the bad entries in the Shared Services Registry. There is no harm of running this utility as a regular cleanup process. This utility runs on the basis of some rules which are passed to the utility using a xml, but default it uses the default-rules.xml file present at following location:

MIDDLEWARE_HOME\EPMSystem11R1\common\config\11.1.2.0\resources\registry\cleanup

There are six default rules in the default-rules.xml file, these are: 
1. Remove components without parent HOST node, 
2. Remove APP_SERVER components with just HOST components in parents,
3. Remove components without any children or parent nodes,
4. Remove HOST to HOST links,
5. Remove webapps with invalid ‘serverName’ property,
6. Merge duplicate webapps.

If you look at the xml and investigate the first rule:

 
       
           
               
                   
                        HOST
                   
               
             
       

         
           
                SYSTEM9
           
             
                FOUNDATION_SERVICES_PRODUCT
           
           
                SHARED_SERVICES_PRODUCT
             
           
                HOST
           
       
   

Here its trying to check if the Parents match is false for any component then perform delete action, of course there are few exception in the Skip section.

Please go to the above mentioned location to find more about other rules.

We can find this utility at: MIDDLEWARE_HOME\user_projects\epmsystem1\bin\registry-cleanup.bat|sh

If we want to create of our rules, yes we can do it, Here is a document (Doc ID 1482499.1) which talks about an issue where the configuration of Web Analysis was failing with new database, here registry-cleanup utility did the trick, we provided following .xml to delete the registry information for Web Analysis and then installation went fine:

 
si="http://www.w3.org/1999/XMLSchema-instance" xsi:schemaLocation="http://www.hyperion.com/hit/registry registry-cleanup-schema.xsd"> 


     
         
             
                AGENT 
           

 
             
                AGENT_MODULE 
             
             
                RA_SERVICE 
             
             
                RA_LSM 
             
             
                EVENT_MONITOR 
             
             
                MANAGED_PROCESS 
             
             
                DAS_DSN 
             
             
                PROPERTY 
             
         
     

Web Analysis - Reporting And Analysis Configuration with New Database Fails (Doc ID 1482499.1)

Also I have found a document which talks about the an issue which few of our clients have faced:

Error: "reg.properties not configured" When Executing The Registry Cleanup Utility (Doc ID 1491854.1)