How To Find Missing Objects in OBIEE 11g Web Catalog to Prevent Errors after Upgrade from Earlier Version
Last updated on APRIL 11, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Oracle Exalytics Software - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Checked for relevance 22-DEC-2014.
Oracle Business Intelligence Enterprise Edition (OBIEE) 188.8.131.52, 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?
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