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)
When trying to execute dashboard and reports for Profitability Management Application Pack Financial Reporting the following error occurs.
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)
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