View Display Error on Dim Classification in 'Object Registration' Screen of Admin BI Reports (Doc ID 1363547.1)

Last updated on OCTOBER 03, 2011

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 7.2, after installing the Administrative (Admin BI) reports, when you open the Admin BI Dashboard, the "Object Registration" section has the following error on 'Dim Classification':

View Display Error

Odbc driver returned an error (SQLExecDirectW).

Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A
general error has occurred. [nQSError: 14026] Unable to navigate requested
expression: count(Dim Classification.Table Name by [ Dim Classification.Table
Classification Code, Dim Classification.Table Classification, Dim
Classification.Classification Description] ). Please fix the metadata
consistency warnings. (HY000)

SQL Issued: SELECT "Dim Classification"."Table Classification" saw_0, "Dim
Classification"."Table Classification Code" saw_1, "Dim
Classification"."Classification Description" saw_2, count("Dim
Classification"."Table Name") saw_3 FROM FUSION WHERE ("Dim
Classification"."Validated Flag" = 'Y') ORDER BY saw_1

If you go to Settings > Administration > Manage Sessions and select "View Log" for the statement getting the error, the following is returned:

-------------------- General Query Info:
Repository: Star, Subject Area: FUSION, Presentation: FUSION


+++Administrator:242c0000:242c0007:----2011/04/25 12:44:02

-------------------- Logical Request (before navigation):

RqList
Dim Classification.Table Classification as c1 GB,
Dim Classification.Table Classification Code as c2 GB,
Dim Classification.Classification Description as c3 GB,
count(Dim Classification.Table Name by [ Dim Classification.Table
Classification Code, Dim Classification.Table Classification, Dim
Classification.Classification Description] ) as c4 GB
DetailFilter: Dim Classification.Validated Flag = 'Y'
OrderBy: c2 asc


+++Administrator:242c0000:242c0007:----2011/04/25 12:44:02

-------------------- Query Status: Query Failed: [nQSError: 14026] Unable to
navigate requested expression: count(Dim Classification.Table Name by [ Dim
Classification.Table Classification Code, Dim Classification.Table
Classification, Dim Classification.Classification Description] ). Please fix
the metadata consistency warnings.


The issue is specific to the 5.2 Fusion_Admin.rpd.  This issue does not occur in the 5.1 Fusion_Admin.rpd.

Cause

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