Data is Appearing in the Incorrect Entity Within Hyperion Enterprise

Data is Appearing in the Incorrect Entity Within Hyperion Enterprise
		Modified 16-FEB-2010     Type PROBLEM

Applies to:

Hyperion Enterprise - Version: 5.0.1.0.00 to 6.5.1.0.00 - Release: 5.0 to 6.5
Information in this document applies to any platform.

Symptoms

Data is being incorrectly referenced by Database and DataEntry Modules . The data shown for Entity X was acually from Entity Y.

Cause

Entities had been added to the application with Live users on the System. 
At some point a file contention issue has arisen and caused the application's internal referencing to become corrupt.

Solution

Avoid making Metadata Changes while users are live on the system. Ensure that such changes are made in an offline application copy. Then update the live application with an extract from the test copy while no users are active within the live application.

If corruption is already present. Perform the following steps.

1. Ensure that no users are logged into the application.
2. Extract the Metadata changes made via TASK, EXTRACT APPLICATION in the Application Module of the Corrupt Application.
3. Extract a recent data or journal changes if possible.  (This is done via the Database Module and Journal Module respectively). 
   
4. Manually check the integrity of any data extracted as the application damage may have rendered this data incorrect.
5. Restore a clean verified back-up which does not exhibit the problem seen.
6. Load the Metadata and Data and Journal Extracts taken above. (Ensure no other users are connected to the restored application when the Metadata is loaded).
7. Verify the data in the restored application is correct. 
   
8. Back this application up.
9. While there are no users on the Corrupt Application Delete the corrupted application folder and replace with the corrected restored application files.