OBIEE 10g: Error: "Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P [nQSError:15018] Incorrectly Defined Logical Table Source" When Running a Report

(Doc ID 1312484.1)

Last updated on AUGUST 23, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 10.1.3.4.0 [1900] to 10.1.3.4.1 [1900] [Release 10g]
Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.0 [1900] to 10.1.3.4.1 [1900] [Release 10g]
Information in this document applies to any platform.
This knowledge document is a replacement for 763150.1, 1054112.1, 848223.1, 754462.1, 504667.1, 1267957.1 which have been deleted.
***Checked for relevance on 23-Oct-2013***

Symptoms

When running a report  in Answers, instead of displaying the results, you see the following error:

 

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: 15018] Incorrectly defined logical table source (for fact table <
fact table name>) does
not contain mapping for [<
dimension table.dimension name>].(HY000)


You might also see this error:

  

State: S1000. Code: 10058. [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred. [nQSError: 14070] Cannot find logical table source coverage for logical columns: [Source]. Please check more detailed level keys are mapped correctly. (S1000)

  

In some cases changing the order of the dimension columns allows the results to display without error; or creating the report with just each dimension column at a time allows the report to display without error

Changes

Possible changes prior to seeing this error are:
Upgrading to OBIEE 10.1.3.4.1.
Adding a new table to the repository.

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