BI Dashboard Prompts Failed To Load (Odbc Driver Returned An Error SQLExecDirectW).)

(Doc ID 2317058.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Analytics

BI Dashboard Prompts Failed to load (Odbc driver returned an error SQLExecDirectW).)

Comp admins and users are suddenly receiving an error on BI Prompts when opening a Dashboard.

Failed to load (Odbc driver returned an error SQLExecDirectW).)

The reports, prompts, and dashboards have not been changed.

ERROR
-----------------------
Failed to load (Odbc driver returned an error SQLExecDirectW).)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a BI Dashboard
2. Click on the Prompts
Observe that an error is being thrown.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use BI Dashboards

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