My Oracle Support Banner

OBIEE 11g : Analytics Report using Presentation Variable is failing with Error Code " OI2DL65P " (Doc ID 2316748.1)

Last updated on MAY 28, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.150120 and later
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE) Version 11.1.1.7.150120

The following error is appearing when accessing a reports that is using a presentation variable.

Error:-

Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P
Location: saw.views.evc.activate, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near <@>: Syntax error [nQSError: 26012] . (HY000)

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.