My Oracle Support Banner

Error 'OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P [nQSError: 27047] Nonexistent table' When Running Analysis in Analytics (Doc ID 2540015.1)

Last updated on JULY 25, 2023

Applies to:

Primavera Analytics Cloud Service - Version 17.7 and later
Primavera Analytics - Version 17.7 and later
Information in this document applies to any platform.

Symptoms

When creating an Analysis in Analytics, clicking the Results tab displays a page with the following error details:

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"



The issue can be reproduced at will with the following steps:

  1. Access P6 Analytics.
  2. Do either of the following:
    1. Select New > Analysis, select the desired columns, then click the Results tab.
    2. Select an existing analysis to open and click the Results tab.
  3. Expand Error details.

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!

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