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