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 APRIL 11, 2018
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document