Change Data Source Connection for Migrated Financial Reports Results in Error: "5200: Error executing query" (Doc ID 763273.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion BI+ - Version 9.0.1.0.00 to 11.1.1.3.00 [Release 9.0 to 11.1]
Hyperion Reports - Version 2.0.1.0.00 to 7.2.5.2.00 [Release 2.0 to 7.2]
Information in this document applies to any platform.

Symptoms

You migrated reports from pre-System 9 to System 9 or above by exporting from the old version and importing to the current version.  When you try to change the data source from the original application to the new application, you get the message:

"5200: Error executing query."

The problem reports are all modified copies of the same report.

The reports exhibit no issues in the prior version.

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