Essbase - Stopping Data Loads or Dimension Builds / Recovering from a server crash

About

A data load or dimension build can be stopped before it completes in two cases :

• manually, you stop a data load that is adding to or subtracting from data values
• If the server crashes while you are loading data, Essbase sends you a timeout error.

If a data load or dimension build process is terminated, Essbase displays the file name as partially loaded.

Recovery procedures

The recovery procedures that you must perform depend on the type of load you are performing and the Isolation Level database transaction setting:

With the Committed Isolation Level setting

If you are adding to or subtracting from data values during a data load to a block storage database, use the Committed Isolation Level setting, if possible. If the data load is terminated, this setting rolls the data load back to its previous state.

If you are adding to or subtracting from existing values in the data source and the Isolation Level setting is:

• Committed, reload the data source when the server is running again.
• Uncommitted, determine how much data Essbase loaded before the crash:
  1. Compare the values of the data source with the values of the database.
  2. If the values that you are adding to or subtracting from have not changed, reload the data source.
  3. If the values that you are adding to or subtracting from have changed, clear the values that loaded and reload the previous data sources. If, for example, you derive monthly sales figures by adding the sales figures for each week as they are loaded, clear the sales figures from the database and reload the sales figures for each week up to the current week.

Without the Committed Isolation Level setting

If you are overwriting the values of the data source, reload the data source when the server is running again.

Termination time

If you initiate a data load or dimension build from a client and terminate the data load or dimension build from the server, it could take time before the client responds to the termination request. Because Essbase reads the source file until all source data is read, the amount of time depends on the file size and the amount of source data that Essbase has processed. If the process is terminated from the computer that initiated it, termination is immediate.

Tool

To stop a data load or dimension build before it completes, use a tool: