Why Does The OBIEE 11g Consistency Check Show Errors And Warnings After An Upgrade That Did Not Occur In 10g
(Doc ID 1254354.1)
Last updated on APRIL 01, 2019
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.0  and later
Information in this document applies to any platform.
OBIEE, Oracle Business Intelligence Enterprise Edition, Siebel Analytics, Answers, Dashboard, RPD
***Checked for relevance on 17-Nov-2012***
The goal is to understand why an OBIEE repository (RPD) that completed an error and warning free consistency check in 10g, results in many warnings or errors when the RPD is upgraded to 11g and a consistency check is executed.
A wide range of errors and warnings have been seen. A few examples have been copied below; however, many other errors or warnings could show after the upgrade.
Error: The content filter of a source for logical table: Fact response details references multiple dimensions. [nQSError:15001] Could not load navigation space for subject area Test_Area
Error 38126 Object Type: Logical Level
Logical Level "XyZ"."123" .. has name with leading or trailing spaces
Error 15004 Object Type: Business Model
Internal Error: Missing functional dependency association for colum 5: X_TABLE.ROW_ID
[nQSError: 15001] Could not load navigation space for subject area Test_Area.
Error 38079 Object Type: Physical Foreign Key
Foreign Key "ABC.123"....
FKey#2 A comparison is being carried out between non-compatible types
Warning: Fact table is not joined to logical dimension table. This will cause the problems when extracting project(s).
Warning: Missing Functional dependency association for column:
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