Essbase Studio Configure Database Task

Issue: When you upgrade Essbase Studio from Release 11.1.1.3, the Configure Database task fails, and one or more messages about inconsistent objects are added the Essbase Studio upgrade log file. Example:

Caused by: com.hyperion.cp.cplutil.scripts.export_import.exceptions.ExportException: Inconsistent object in catalog. Please check the object form : \'Drill Through Reports'\'Supplier', object id : @44#0#101#0@.

This error occurs if drill-through reports are inconsistent because data source connections have been renamed.

Solution: Follow these steps:

Note:

Ensure that the Release 11.1.1.3 release environment is running and available until the Essbase Studio catalog upgrade succeeds.

  1. Take one of these actions to correct any drill-through report inconsistencies:

    • In the Release 11.1.1.3 environment, rename the data source connections to their original names.

    • Update the invalid drill-through reports by providing new column values in the Report Contents tab of the drill-through report editor.

      You can also provide new filters.

    • Delete the invalid drill-through reports from the 11.1.1.3 environment, and recreate them in the upgraded Essbase Studio environment.

  2. Restart EPM System Configurator, and rerun the Configure Database task.