My Oracle Support Banner

"Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P Odbc Driver Returned an Error (SQLExecDirectW)..." When Attempting to View Sample Dashboard Reports In P6 Analytics (Doc ID 2314274.1)

Last updated on MARCH 20, 2019

Applies to:

Primavera Analytics - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to view the 01. Main dashboard in P6 Analytics, the following error occurs:

01. Main
Error
View Display Error
Error getting cursor in GenerateHead
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. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 15002. [nQSError: 15002] Missing navigation space for subject area P6Core. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Earned Value - (Cost)"."Cost Variance (Cost)" FROM "Primavera - Activity"')}
SQL Issued: SELECT "Earned Value - (Cost)"."Cost Variance (Cost)" FROM "Primavera - Activity"


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

  1. Log into Primavera Analytics and navigate to 01 Main dashboard.
  2. The reported error is observed.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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