Inactivating Unreferenced Repository Objects

The Inactivating Unreferenced Repository Objects Utility identifies the unreferenced objects in the database and deactivates the unreferenced objects. The Inactivating Unreferenced Repository Objects Utility finds unreferenced objects for the following Siebel objects:

• Screen

• View

• Applet

• Business Object

• Business Component

• Integration Objects

• Link

• Pick List

• Task Group

• Task

The Inactivating Unreferenced Repository Objects Utility runs as part of the upgrade process. Use the following procedure to manually run the Inactivating Unreferenced Repository Objects Utility.

Note: The process of inactivating Unreferenced Repository Objects can only be run before the upgrade is completed. It cannot be run after the Upgrade.

Running the Inactivating Unreferenced Repository Objects Utility

1. Navigate to the following directory:

   Windows: $DbsrvrRoot\common folder

   UNIX: $DbsrvrRoot\common folder

2. Run the following command:

   java -jar RepCrawler.jar /s [Siebel Tool/Server Path, one folder up BIN directory] 
   /c [DSN]  /d [Database Type - Oracle, DB2UDB, MSSQL or DB2390 ] /u [Database User] 
   /p [Database Password] /h [Host Name] /o [Log directory] /t [Table Owner] /r "Siebel 
   Repository"
   

   RepCrawler refers to the following files (present in the dbsrvr/common folder) to determine whether all active objects for active applications are referenced in the code and repository, and subsequently whether to inactivate those objects or not:

   • RepSanitizationRules.xml. This rules file defines the relationship between objects. The use of object references will be determined by the relationships defined in this file.

   • RefReferenceObjects.txt. This blocklist file contains a list of all the default (out-of-the-box) objects used by Siebel. Customers can expand this list by adding objects, which they do not want to inactivate as part of the RepCrawler process, to this list.

   After RepCrawler runs, any objects which are not referenced in the code and repository will be considered for inactivation.

3. Review the RepCrawler log and verify that RepCrawler ran without errors.

   Windows: $SiebelLogDir\RepCrawler.log

   UNIX: $SiebelLogDir/ RepCrawler.log

4. Review the RepCrawler reports to see the inactive objects.

   • RepCrawler.html. A report where you can see the inactive objects.

   • RepcrawlerLog.log. A folder that contains all the SQL logs executed during the process of running the Inactivating Unreferenced Repository Objects Utility.

   • repcrawler.js. A data file in JSON format of all inactive objects used in the HTML report.