My Oracle Support Banner

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 11.1.1.3.0 [1905] 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***

Goal

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.

Examples:

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:



Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.