ODBC Driver Returned An Error (SQLExecDirectW) When Running Primavera Analytics Dashboard
(Doc ID 2823794.1)
Last updated on FEBRUARY 25, 2022
Applies to:
Primavera Analytics - Version 20.12 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run a dashboard, the following error occurs.
ERROR
-----------------------
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: 17001. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS: could not resolve the connect identifier specified at OCI call OCIServerAttach. (HY000)
State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SELECT 0 s_0, "System - Admin"."ETL Process Master"."Datasource ID" s_1,
(cast(floor(TimestampDiff(SQL_TSI_MINUTE, CAST (MAX("System - Admin"."ETL Process Master"."Process Start Date") AS TIMESTAMP),
CAST (MAX("System - Admin"."ETL Process Master"."Process End Date") AS TIMESTAMP))/60)-floor(TimestampDiff(SQL_TSI_MINUTE,
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 |
Cause |
Solution |
References |