I guess all of us know how annoying the consistency check warnings can be when saving the repository. This entry shows you how to hide selected warnings from the Consistency Check Manager of OBIEE Admintool client. You can download and apply patch 11810367 to hide selected warnings from the Consistency Check Manager. After applying the patch, the following warnings are hidden by default: 39009, 39054, 39055, 39057, and 39059.

To apply the patch to your installation of Admintool client follow these steps:

  1. Download patch 11810367 depending on your Release of OBIEE Admintool client, from My Oracle Support
  2. Unzip the downloaded file
  3. Backup your installation of Admintool client, standard installation path: C:\Program Files\Oracle\Oracle Business Intelligence Enterprise Edition Plus Client Tools
  4. Copy all files from your patch folder:\11810367\files\bifoundation\server\bin to your Admin tool client installation:\oraclebi\orahome\bifoundation\server\bin. Those files should already exist in that folder, copy and replace them.
Consistency Check Manager

Consistency Check Manager

After starting Admintool client again, the new button “Options” is displayed in the Consistency Check Manager, with the Options button you open the Consistecy Check Warnings dialog, here you can see the warnings which are hidden by default.

 

To make these warnings visible again in the Consistency Check Manager, follow these steps:

  1. Click the Options button in the Consistency Check Manager to open the Consistency Check Warnings dialog.
  2. Deselect the warnings that you want the Consistency Check Manager to display.
  3. Click OK.

 

You can also add additional warnings to the exclusion list in the Consistency Check Warnings dialog.

To do this:

  1. Go to the following directory:
    ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn
  2. In that directory, create a text file called warn_off.ini. This file must be in ASCII format.
  3. Populate the file with contents similar to the following, listing the warning numbers that you want to add to the exclusion list in the Consistency Check Warnings dialog:
    [dt_code][CCOptions] CC_WARNINGS_LIST = 39024,39077[/dt_code] Note the following:

    • All excluded warnings must be on one line and can be separated by a comma, a semicolon, or a space.
    • You cannot exclude errors. You can only exclude warnings from the Consistency Check Manager.
    • If you add warning numbers from the default exclusion list (39009, 39054, 39055, 39057, and 39059), they are ignored.
  4. Save and close the file.
  5. Close and then re-open the Consistency Check Manager. The new warnings are displayed in the Consistency Check Warnings dialog and are selected by default, meaning that those warnings are excluded from consistency checks.

In the OBIEE documentation you can find a short table which provides some commonly seen consistency check warnings and errors.