View Display Error: Unresolved Column: "Column name ' When Running Reports

(Doc ID 2402462.1)

Last updated on JUNE 01, 2018

Applies to:

Oracle CRM On Demand - Version 031CS and later
Information in this document applies to any platform.

Symptoms

 
When trying to run a report it immediately returns the "View Display Error: Unresolved Column <Column Name>..." error message.

Example of what the error message may look like in full:

Odbc driver returned an error (SQLExecDirectW).

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "Service Request"."DATE_1". (HY000)

BUSINESS IMPACT
Cannot render the report due to the error.

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