When Attempting to Run Reports in Primavera Analytics Under Shared Folders/Sample Lite the Error "Nonexistent Table" Occurs (Doc ID 2503266.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Symptoms

When attempting to access reports under Shared Folders/Sample Lite, the following error occurs.

ERROR
-----------------------
Error
View Display Error
Error generating view. 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.
  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: "Sample Sales Lite".
  Please have your System Administrator look at the log for more details on this error. (HY000)

  SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Time"."Per Name Year" FROM "Sample Sales Lite"')}

  SQL Issued: SELECT "Time"."Per Name Year" FROM "Sample Sales Lite"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Primavera Analytics
2. Click Catalog
3. Navigate to Shared Folders/Sample Lite
4. Select any of the reporting objects and click Open

Changes

Cause

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