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:

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

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