...
- Automatically by the RollingBarrel based on expiry time
- Populator (wipes the central database)
- MCRecoveryTool (specialised removal actions)
- Sql script in sql script or via DBVisualiser or another jdbc client. See examples below
- ImportAmalgamate (this is for merging external historical data), see also ImportAmalgamate
...
- Suspend all MC-MC Synchronisation tasks.
- Remove all forecasting shell / PI Service local datastores.
- Remove the records from all central databases
- Resume the MC-MC synchronisation tasks.
Examples of custom deletions
While the MCRecoveryTool -clear_config_all option removes the workflowmappings, sometimes, a custom delete statement can be used to clear all the (non- MC) workflows.
...
| Code Block |
|---|
DELETE FROM WorkflowTargetFSSs WHERE workflowId NOT LIKE 'MC:%' AND workflowId NOT LIKE 'MC_:%' |