info@lasmart.biz

january 27, 2023

Restoring PerformancePoint Server 2007 after a failure

Steps for the system administrator to restore the PPS system after a failure

Installing the required software

  1. Install MS SQL Server 2005 and apply the necessary service packs.
  2. Install MS Excel with SP2.
  3. Install the PPS Business Modelling component.
  4. Install the Planning Server.
  5. Install the PerformancePoint Add-In for Excel.
  6. Apply the required service packs to the Planning Server, PPS Business Modelling component, and the PerformancePoint Add-In for Excel.

Restoring databases and configuring services

  1. Stop the Planning Process Service on the server where it is running.
  2. Restore all Application and Staging databases from backups.
  3. Restore SystemDB and ServiceDB from backups.
  4. Connect to the Planning Administration Console and set the applications to offline mode.
  5. If the new server has a different name from the old one, update the computer name for the Planning Server and SQL Server in certain internal tables.

First, manually update the BizSystem table in SystemDB using the following command:

Then, manually update the DeployInfo table in the application database.
After that, retrieve the BizAppNodeID from the BizAppNodes table using the following command:

Next, update the DeployInfo table using the following command:

6. Update the OLAP database connection strings on the computer running Analysis Services:

  • Expand the OLAP database hierarchy in SQL Server Management Studio.
  • Expand the names of all databases, and then expand the «Data Sources» folder.
  • Right-click each child node, select Properties, click Connection String, and then click the ellipsis button for the Connection String field.
  • Enter the new SQL Server name in the Server Name field.
  • Repeat this for all OLAP databases.

7. For the Planning Web Service and Planning Process Service servers, make the necessary changes in the PerformancePoint. Config file, which is typically located in the folder C:\PerformancePointTemp\3.0\Config:

  • Update the database server entry to the name of the new computer running SQL Server.
  • Update the OLAP server entry to the new name of the OLAP server computer.

8. On the computer running SQL Server, manually enable the SQL Server Service Broker component for all Planning Server application databases by executing the following SQL Server query:

9. On both servers, Planning Web Service and Planning Process Service, execute the following command in the Windows command prompt:

10. On the Planning Web Service and Planning Process Service servers, restart the Planning Process Service. This ensures that all configuration file changes are applied by the servers.

11. Execute the following command for all Application and Staging databases:

Ensuring access to file resources

After restoring all services and databases, it is necessary to restore access to the folder containing file resources, such as data input forms, report forms, etc.

For more information, please get in touch here:

Contact Form main