Validating OBIEE 11G Catalog

In OBIEE 11g it is important that we validate the catalog after upgrading the catalog from 10g so that the catalog is consistent and ready for migration to production environments.

As part of the process of validating the catalog, you include elements in the instanceconfig.xml file that run the validation when you restart Presentation Services.


The validation runs when Presentation Services starts, and Presentation Services is stopped when the validation is complete. Inconsistent accounts (such as those for deleted users), links, and objects are removed. Inconsistent users' home directory names are logged but directories are not removed.

<ServerInstance>
<Catalog>
    <Validate>OnStartupAndExit</Validate>
    <ValidateAccounts>Clean</ValidateAccounts>
    <ValidateHomes>Report</ValidateHomes>
    <ValidateItems>Clean</ValidateItems>
    <ValidateLinks>Clean</ValidateLinks>
</Catalog>
</ServerInstance>

2 comments:

  1. Thanks for this information on validating catalog. I have a question on the tag validatehome.

    We are seeing errors on some of our user accounts.. I tried running Clean and the accounts were removed. Can you explain why this happened?

    Example:
    Abandoned home /users/

    ReplyDelete
  2. I have exact same error after running Catalog Validation. User did not miss any data, but access to files under his home catalog. it does not help to assign full control for him and his home.

    ReplyDelete