HFM users cannot open application with error :Application [%0] is not contained in a Hyperion SharedServices Project. Please contact your administrator

Applies to:

Symptoms

Users are not able to open a Consolidation (Financial Management) application with the error :"Application [%0] is not contained in a Hyperion SharedServices Project. Please contact your administrator" via Win32 client and Web client.

Also when they open the application from SharedServices, they receive "Application [APP_NAME] is not contained in a Hyperion SharedServices Project. Please contact your administrator".

Cause

Some application registration information in Shared Services is lost or corrupted.

This can happen when the SharedServices relational database and OpenLDAP are not in a consistent state, resulting (for example) by restoring one of the two from backup; which is why it is recommended to always restore both at the same time, using backups taken on the same date.

The SharedServices relational database stores information related to projects and product registration. The Native Directory OpenLDAP database contains provisioning data for all products. Data inconsistencies between the two will impact standard operations as seen in the Symptoms.

Solution

The following solution applies to "Classic" Consolidation applications only. 
If you are experiencing this on an application created with EPMA, contact Oracle Support.

Recommended Solution

1. Launch the SharedServices User Management Console, either navigating directly to http://your_hss_server:your_port/interop/ , or selecting the following menu item:

• 11.1.1 and above: Navigate ("the wheel") -> Administer -> SharedServices Console
• 9.3.x: Navigate -> Administer -> User Management Console
• 9.2.x, 9.0.x and 4.0.5: File -> User Management Console
  

1. Select Administration -> Sync Native Directory.
2. The Sync Native Directory tab displays the status of the synchronization operation.
   • Optional: Click Refresh to update the status.
   • Optional: Click View Log to display a log file that details the operations that were performed during the synchronization process.

Emergency solution

1. Open Microsoft Word (version 2003 or later). This is the most common tool that can be used for this operation, but any other WebDAV-enabled tool will also work.
   
2. Select File -> Open.
3. Enter the following URL: http://your-hss-server:your-port/interop/content 
   The port is usually 28080 in version 11.1.1 and above, and 58080 in other versions.
   
4. When challenged for user/password, use credentials for the admin account. A file repository will appear.
   
5. Browse to Files->Products->HFM 9.3.1 ->Published
6. Delete the file containing the name of the corrupted application.
7. Browse to Files -> AdminProjects -> Applications and delete the application file from there too.
   
8. Restart the Shared Services Web Application service.
9. Perform the abovementioned Recommended Solution. This will remove any info about the application from the OpenLDAP repository as well.
10. Re-register the application, as described in the Financial Management Administration Guide, and re-provision users.