IBM Support

How do I delete a Case from a target object store without leaving any orphaned work items

Question & Answer


What is the correct process to delete a Case of a particular case type for a solution from an IBM Case Manager target object store so that there are no orphaned Content Platform Engine workflow system work items?


Important: The following outlined procedures makes changes to data stored in the database. Therefore, it is highly recommended that a full database backup of the target object store is performed.
Procedure on how to delete a Case correctly by deleting the associated work items first.
Important:  The following procedure deletes only the specified Case Folder object and any associated activity work items in the workflow system. This procedure will not delete all metadata, objects, or references that are associated with the deleted case. Examples of artifacts that remain after you delete a case are related cases, security objects such as proxies and marking sets, audit logs, events, and analytic data that is maintained for Case Analyzer and case history. For this reason, deleting a case is not recommended in a production environment because doing so might result with reference problems.
  1. Open Administration Console for Content Platform Engine. (ACCE).
  2. Navigate to the IBM Case Manager target object store associated with the solution.
  3. Navigate to the Case folder (For example: /IBM Case Manager/Solution Deployments/<solution_name>/Case Types/<case_type_name>/Cases/<yyyy>/<mm>/<dd>/<number>/<case_sequence_id>
  4. Select the properties tab for the Case folder and copy/save the value from the ID property.
  5. Navigate to the target object store > search node
  6. Select 'New Workflow Search'
  7. Choose the following options:
    1.   Search result type - Work Items
    2.   Workflow structure - Workflow roster
    3.   Workflow structure name - <solution_name>
    4.   Search Filter - F_CaseFolder, Equal To, <value of ID> copied or saved from step 4.
    5.   Run the search
  8. Navigate to the 'Search Results' pane, and select all rows
  9. Select 'Actions' > 'Tasks' > 'Terminate Work...'
  10. Now with the work items deleted, you can go back to the Case folder in step 3 and delete the Case folder and all child objects.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSCTJ4","label":"Case Manager"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB15","label":"Integration"}},{"Line of Business":{"code":"LOB15","label":"Integration"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"ARM Category":[{"code":"a8m0z000000cwEvAAI","label":"Case Management"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
26 August 2020