Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P

user2396995

We have VCP 12.2.5 instance where we have APCC (Advanced Planning Command Center).  We have cloned our Production instance to a test instance.  None of the reports open in the test instance.  I found some OBIEE notes but am still not sure what to do to get these reports to work on our newly cloned test instance.

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: 27045] Nonexistent column: "- Forecasting"."Final Forecast USD TNV".
Please have your System Administrator look at the log for more details on this error. (HY000)

SQL Issued: {call NQSGetQueryColumnInfo('SELECT RSUM (SUM("- Forecasting"."Final Forecast USD TNV" BY"- Time"."Fiscal Quarter Start Date")*(CASE "- Time"."Fiscal Period Number" WHEN 1 THEN 0.06 WHEN 4 THEN 0.06 WHEN 7 THEN 0.06 WHEN 10 THEN 0.06 WHEN 2 THEN 0.075 WHEN 5 THEN 0.075 WHEN 8 THEN 0.075 WHEN 11 THEN 0.075 ELSE 0.1 END)) FROM "Advanced Planning"')}

SQL Issued: SELECT RSUM (SUM("- Forecasting"."Final Forecast USD TNV" BY"- Time"."Fiscal Quarter Start Date")*(CASE "- Time"."Fiscal Period Number" WHEN 1 THEN 0.06 WHEN 4 THEN 0.06 WHEN 7 THEN 0.06 WHEN 10 THEN 0.06 WHEN 2 THEN 0.075 WHEN 5 THEN 0.075 WHEN 8 THEN 0.075 WHEN 11 THEN 0.075 ELSE 0.1 END)) FROM "Advanced Planning"

[Deleted User]

user2396995 wrote:[nQSError: 27045] Nonexistent column: "- Forecasting"."Final Forecast USD TNV"

Your web catalog objects reference objects in the RPD which do not exist - at least not with that name.