All Primavera Analytics Dashboard Shows Error Code "Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P" and "State: HY000. Code: 27047. [nQSError: 27047] Nonexistent Table: 'Primavera - Activity'."
(Doc ID 2243647.1)
Last updated on NOVEMBER 22, 2019
Applies to:
Primavera Analytics - Version 16.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to view any Analytics Dashboard report, the following error occurs:
ERROR
Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "Primavera - Activity".
Please have your System Administrator look at the log for more details on this error. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Codes - (Project)"."Project Code Description 09" FROM "Primavera - Activity"')}
SQL Issued: SELECT "Codes - (Project)"."Project Code Description 09" FROM "Primavera - Activity"
STEPS
The issue can be reproduced at will with the following steps:
1. Log on Primavera Analytics as a P6 user.
2. View report , then the page shows above error.
BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot view Analytics Dashboard Report.
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 |