Clearing Deployment History

Each time you deploy an Essbase model, deployment history data is collected and stored in the Essbase Studio catalog. When you migrate your catalog from one release to another, Essbase Studio Server makes use of the deployment history data contained in the catalog. If the history in the catalog becomes too large, the migration cannot be completed.

Essbase Studio provides a utility to clear the model deployment history files, cleanModelHistory.

Before you use this command, you must identify models that have large deployment history files; for example, models that have been redeployed many times. Once you have identified the models to work with, run the cleanModelHistory utility from the Essbase Studio command line client.

  To run the cleanModelHistory utility:

  1. Go to: MIDDLEWARE_HOME/user_projects/epmsystem1/bin.

  2. Call start_BPMS_bpms1_CommandLineClient.bat|sh to start the Essbase Studio command line client.

    A command window called the CPL Shell is displayed.

  3. At the prompt, enter a valid Essbase Studio administrator user name and password.

    Note:

    You must have Essbase Studio administrator privileges to use the Essbase Studio cleanModelHistory utility.

  4. Run the cleanModelHistory command using the following syntax:

    call 'util'::'cleanModelHistory'("MODEL_NAME", dataset:\'DATASET_NAME'); 

    "MODEL_NAME" is the name of the model whose history you want to clear.

    'DATASET_NAME' is the name of the cube schema that was used to build this model.

    For example:

    call 'util'::'cleanModelHistory'("ProdMktModel1", dataset:\'ProdMktCS');

    This removes all entries in the deployment history of the model except for the current @ "in-sync" entry for a given cube. All failures and noncurrent @ successes are removed.