My Oracle Support Banner

Script in Connection Causing an ODBC Error Occurs While Calling Remote Service DatasourceService (Doc ID 2702513.1)

Last updated on AUGUST 27, 2020

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI)
Oracle Financial Services Enterprise Performance Management (EPM)
OBIEE repository database (RPD)
Open Database Connectivity (ODBC)

Symptoms

When trying to execute dashboard and reports for Profitability Management Application Pack Financial Reporting the following error occurs.


Error:

Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service DatasourceService. 
Details: [JDSError : 115] Invalid Database Name - Cause: SQL string is not Query Action: Please refer to logs for more Details (HY000)


Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.