Stopping Data Loads or Dimension Builds

You can stop a data load or dimension build before it completes. You should not stop a data load or dimension build unless it is necessary. If a data load or dimension build process is terminated, Essbase displays the file name as partially loaded.

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.

Note:

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. See Understanding Isolation Levels. If you stop a data load that is adding to or subtracting from data values, see Recovering from an Essbase Server Crash.

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

Tool

Topic

Location

Administration Services

Disconnecting User Sessions and Requests

Oracle Essbase Administration Services Online Help

MaxL

alter system kill request

Oracle Essbase Technical Reference