Unable To Migrate Catalog Reports Between Environments. (Doc ID 2178704.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Business Intelligence Cloud Service - Version 14.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

You have created identical model in Test and Production.
You have archived catalog in test and un archived in production.

After that you see below error when you run a report.

View Display Error
  
Error generating view. Error getting cursor in GenerateHead
  Error Details
 Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27047] Nonexistent table: "xxxx". 
Please have your System Administrator look at the log for more details on this error. (HY000)
Please have your System Administrator look at the log for more details on this error.
Please have your System Administrator look at the log for more details on this error.

Changes

 Created identical model in Test and Production and had archived catalog in test and un archived in production.

Cause

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 hundreds of Community platforms