OBIEE 10g: Error: "Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P [nQSError:15018] Incorrectly Defined Logical Table Source" When Running a Report
Last updated on AUGUST 23, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 10.1.3.4.0  to 10.1.3.4.1  [Release 10g]
Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.0  to 10.1.3.4.1  [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***
When running a report in Answers, instead of displaying the results, you see the following error:
Odbc driver returned an error (SQLExecDirectW).
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:
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
Possible changes prior to seeing this error are:
Upgrading to OBIEE 10.1.3.4.1.
Adding a new table to the repository.
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