Catalog Validation

If you upgrade obiee to newer version or applied patches for catalog objects then it is recommended that Catalog Validation is necessary to

• Ensure that each object in the catalog is larger than zero bytes.


• Ensure that each item in the catalog has a valid corresponding .atr file.


• Ensure that each link in the catalog is valid.


• Ensure that the files in the account cache are valid.


• Ensure that all XML objects in the catalog pass schema validation.


• Repair object names that were damaged by ftp programs.

Below are the steps to perform Catalog Validation

1. Refresh the user GUIDs before validating the catalog. If you attempt to validate a catalog whose user GUIDs are not synchronized, then the validation process assumes that all accounts have been deleted and effectively removes all account information from the catalog


2. Shut down the presentation services


3. Take a backup of the webcat (zip it using 7-zip and better to keep it in separate folder)


4. Take a backup copy of the instanceconfig.xml file(path : <Middlewarehome>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1)


5. Edit the instanceconfig.xml file so that it contains the appropriate elements for performing the validation

<ServerInstance>

<Catalog>

<Validate>OnStartupAndExit</Validate>

<ValidateAccounts>Clean</ValidateAccounts>

<ValidateHomes>Report</ValidateHomes>

<ValidateItems>Clean</ValidateItems>

<ValidateLinks>Clean</ValidateLinks>

</Catalog>

</ServerInstance>

6.Start Presentation Services to run the validation according to the values that you specified in the instanceconfig.xml file.

7.Presentation Services will be stopped automatically once validation completed.

8.Validation results will be captured at <MiddlewareHome>\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1\sawlog.log ,

9.Restore the backup version of the instanceconfig.xml that you created earlier to use as the current version.

10.Start Presentation Services.

source : http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/prescatadmin.htm#BAJBJEFA