Unable to Save a Web Analysis Report, Database or Preferences After Migration. (Doc ID 1271609.1)

Last updated on APRIL 05, 2016

Applies to:

Hyperion BI+ - Version 9.2.0.1.10 to 11.1.1.3.00 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on april 2106***

Symptoms


Development Environment has been migrated to Production on same version 11.1.1.3.
Following issues are found after Migration.
1. Unable to save a database.
2. Unable to save a report.
3. Unable to save Preferences.
Failed to store: com.hyperion.analyzer.atf.om.HYAUserPreferences:610
Failed to store: com.hyperion.analyzer.atf.om.HYASSpaceDatabase:511

Changes

" Basic repository consistency verification tests detected a number of "lost" or "unused" records in Web Analysis metadata DB tables. These records however can cause an issue when new data is written in the repository tables on "Save As" action. If customer performed repository content migration, then current repository state could be a result of that migration phase. There is a special SQL script designed to clean up Web Analysis metadata tables in repository. It is designed to remove all redundant/unused records from WA tables and reset internal document counters.
We recommend client doing WA metadata cleanup in order to fix the problem."

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