Retrieving DROP Case Data Database Scripts

If your application with case data is undeployed, you can go to Data Admin and retrieve the DROP database scripts to drop database tables in the case model database schema. Once you have verified them, you must execute them on your database to remove the case model database schema. Once you have executed them, you must notify TIBCO ActiveMatrix BPM from Data Admin. The case model is deleted and removed from Data Admin.

Prerequisites

Make sure your application is undeployed. In other words, in TIBCO Administrator, the status of your application is Undeploy Successful. See TIBCO ActiveMatrix BPM Deployment Guide for more information about application undeployment.

Procedure

  1. From TIBCO Openspace, click Data Admin.
  2. Click Live View.
    A list of the currently deployed case data models displays.
  3. Click the case data model whose DROP scripts you want to retrieve.
    The latest version number that is currently deployed for that case model displays. The status of the case model should be PENDING_DBA_ACTION_TO_UNINSTALL.
  4. Click Drop Script.
    The DROP database script displays.
  5. If you want to make any changes to the script, click Edit.
  6. Make any changes you require and click Save.
    The Save dialog displays.
  7. You must enter a comment in the Comments box.
  8. Click Save to save your changes or Cancel to close the dialog without saving your changes.
  9. You can now execute the script on your database.
    If you have any problems executing the scripts, check your scripts to make sure that you have not made any invalid changes. See Best Practice When Editing Case Model Database Scripts.
  10. Once the script has executed successfully, click Notify to notify TIBCO ActiveMatrix BPM that the scripts have been executed.
    Once the DROP scripts have been executed, the case model is removed from Data Admin.