Financial Management

Most Financial Management configuration information is in Shared Services Registry, but some is in the Windows registry, in HKEY_LOCAL_MACHINE/SOFTWARE/Oracle Solutions/Hyperion Financial Management. Distributed Component Object Model (DCOM) security information is associated with HFMServer.exe and HsvDataSource.exe. Because backing up and restoring this information is difficult, use the following procedure on every application and Web server to back up Financial Management.

  To enable recovery of Financial Management:

  1. Perform a full database backup once per cycle:

    1. Stop Financial Management Web Services and IIS.

    2. Stop these related services:

      • HsxService.exe

      • DMEListener.exe

      • HFMWebServiceManager.exe

    3. Stop these related processes:

      • HsxServer.exe

      • HsvDatasource.exe

      • CASSecurity.exe

  2. Back up the Windows registry export for HKEY_LOCAL_MACHINE/SOFTWARE/Oracle Solutions/Hyperion Financial Management.

  3. Back up the Shared Services Registry.

  4. Back up any customized style sheets.

Note:

You must also back up Oracle Hyperion Shared Services, and you might need to back up Reporting and Analysis for related content.

  To recover from an application server or Web server failure:

  1. Reinstall and configure Financial Management on the failed application or Web server.

  2. Stop all Financial Management processes and services on the newly configured server.

  3. Restore the backed-up files to their original locations.

  4. Restart the services.

  To recover from a database server failure:

  1. Stop all Financial Management processes and services on all application and Web servers.

  2. Restore the database from the last full backup, applying transaction logs as needed.

    If you restore a Oracle Hyperion Financial Management, database to a machine other than the machine where the database was created and the application server names have changed, you must delete these tables from the database:

    • HSX_Cluster_Cont_info

    • HSX_Cluster_Controllers

    • HSX_Cluster_Info

    • HSX_Cluster_Servers

    If you delete the tables, must rerun Oracle Hyperion Enterprise Performance Management System Configurator to recreate cluster definitions.

  3. Restart the database.

  4. Restart the application and Web servers.