Description:
When running the script ClearEnterpriseData.sql under $MQ_HOME/db/oracle/utility directory, it failed due to the following errors:

Error(135,13): PLS-00201: identifier 'DELETE_OBJECTS1.DELETECATALOGDATA' must be declared
Error(142,13): PLS-00201: identifier 'DELETE_OBJECTS1.DELETEDATASOURCE' must be declared

How to clean up the data within an enterprise in MDM

Product: TIBCO MDM 8.3.2, 9 and Fulfillment Catalog 3.0Operating System: All OS supported by MDM and Fulfillment CatalogDatabase: All databases supported by MDM and Fulfillment CatalogApp server: All app servers supported by MDM and Fulfillment Catalog

ClearEnterpriseData.sql and cleanCatalogData.sql scripts have been deprecated for MDM 8.3.2/FC 3.0 onward. In order to clean up the data within an enterprise for reuse purposes, we need to use command-line purge utility datacleanup.sh. Here is a sample command:

datacleanup.sh -o metadata -a 68990 -rn ALL -m 20101   -o: execution mode -a: enterprise ID  -rn: repository name  -m: member ID

The above command will purge all the repositories and all objects related to those repositories within enterprise 68990. Alternatively, we have other options:
-an: enterprise name
-r: repository ID
mn: member name

As such, we can also use the following command to purge all the repositories and all objects related to those repositories within enterprise A:

datacleanup.sh -o metadata -an A -rn ALL -mn admin

After the datacleanup utility is executed successfully, the folder MQ_HOME/common/<enterprise name> and sub-folders can be deleted safely.
 

N/A