How To Find Missing Objects in OBIEE 11g Web Catalog to Prevent Errors after Upgrade from Earlier Version (Doc ID 1569650.1)

Last updated on JULY 18, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 and later
Oracle Exalytics Software - Version 1.0.0.0.0 and later
Information in this document applies to any platform.
Checked for relevance 22-DEC-2014.

Goal

Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6, and later, includes object naming restrictions that prevent naming objects with leading or trailing spaces.  In earlier OBIEE releases (i.e. 10g or earlier 11g versions), there was no such naming restriction.

Consequently, if your RPD or catalog was upgraded from an earlier release and includes objects with leading or trailing spaces, you may find that the objects get removed during repository consistency checks and that the reports then fail with missing object errors.

Are there any tools, or utilities, that can be used to pro-actively check reports in the OBIEE web catalog with the objective of preventing errors during runtime?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms