Manage Database Errors

Scenario:

Manage database errors can occur when the 8.3 naming convention is not used. When the application database is created or refreshed, the error may display as: "Manage Database Errors detected (Start 1060044): Could not open outline -2147218904."

Solution:

To resolve Manage Database errors, you may need to redirect the operating system environment variables. Oracle Essbase requires an 8.3 character-naming convention for the Temp and Tmp environment variables in the operating system. Use this procedure to check the naming convention and reassign these variables if needed.

File Naming Convention

Ensure that you are logged on to the Oracle Hyperion Planning server before making changes.

To check the environment variables for Windows 2000:

1. Close Planning.
2. Close Essbase.
3. On the Windows desktop, right-click My Computer.
4. Select Properties.
5. Select Advanced.
6. Select Environment Variables.
7. Change the settings for Temp and Tmp in the user variable to the 8.3 naming convention.

   For example, C:\Temp

8. Open, and open the outline.
9. Close, and restart Planning.
10. Try creating or refreshing the database on the Manage Database page. If the error recurs, repeat the previous steps, but this time also create a folder called C:\tmp and set the System Environment variables Temp and Tmp to C:\tmp.

    If the error persists, create a Temp folder under C:\temp. Repeat the previous steps, redirecting first the user variables then the system variables to C:\temp\temp. If the error continues, redirect the environment variables to C:\temp.

    Note:

    The settings for Temp and Tmp in the user and system variables must be unique. Do not set the user and system variables to the same folder.