'nQSError 27007 - Ambiguous column' when configuring SA System Subject Area
(Doc ID 1496192.1)
Last updated on MARCH 08, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 10.1.3.4.2  and later
Information in this document applies to any platform.
Setting up SA System Subject Area following these articles:
Description of System Subject Area for Siebel Delivers - SA System (Doc ID 477972.1)
OBIEE 10g: How to Create SA System Subject Area? (Doc ID 867326.1)
However, there are errors in the Presentation log:
SQL Error retrieving users from System SA. 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: 27007] Ambiguous column: "Email". (HY000)
SQL Issued: SELECT Logon, Email, "Email Type", "Email Priority", "Cell Phone", "Cell Phone Priority", Pager, "Pager Priority", Handheld, "Handheld Priority" FROM "SA System" WHERE Logon = 'Administrator'
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|