Some Reports Error Out in the BICS Instance Even Though The Data Model Is Valid (Doc ID 2184732.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Business Intelligence Cloud Service - Version 15.2.4.0.0 and later
Information in this document applies to any platform.

Symptoms

On  BICS, Analysis/Dashboards, Certain reports error out in the BICS instance even though the Data Model is valid

The dashboard that can be used for diagnosing this issue is the SalesForce Dashboard > Lead Analysis page.

ERROR
-----------------------

Error Codes: :U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[SF Fact - Lead.Lead Source, substring(SF Fact - Lead.Created Date from 1 for 10)],,,,].
[nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: SF Fact - Lead.Lead Source, substring(SF Fact - Lead.Created Date from 1 for 10)
Please have your System Administrator look at the log for more details on this error. (HY000)
Please have your System Administrator look at the log for more details on this error.

BUSINESS IMPACT
-----------------------

User unable to view some of the reports/dashboards due to mentioned issue.

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