Purging all MDM Suspect Duplicate tasks in IBM Stewardship Center

Body

Author: Geetha S Pullipaty

Product: Infosphere Master Data Management.
Component: Data Stewardship and Governance.
Version: 11.5.0

Other prerequisite software: IBM Business Process Manager 8.5.6 , IBM Process Designer 8.5.6, IBM Stewardship Center 11.5.0 installed and configured.

IBM Stewardship Center provides the ability to perform reactive data stewardship activities around Physical MDM. When a suspect gets created on MDM , a notification is being sent to BPM and a Suspected Duplicate task gets created on BPM Process portal for a Data steward to act upon. ISC default implementation creates all SDP tasks for a single group called DataStewardGroup.

This document explains how to delete all those Suspect tasks that get created.

1. Open Physical MDM Suspect Duplicate Process from BPM Process Designer.

2 .Create a new “General System Service” from Implementation option in the left side pane.

3. Name the service as “Delete Process Instance”

4. Now go to Diagram tab inside the service.

5. Create a new Server Script by dragging Server Script box from right side pane and name it as “Get all active SDP tasks and terminate them”.

6.Inside the implementation section in properties tab add below code

                var processName = "Resolve Suspected Duplicate process";
               // Set Search condition.
              var conProcessType = new TWSearchCondition();
             conProcessType.column = new TWSearchColumn();
             conProcessType.column.name = TWSearchColumn.ProcessColumns.Name;
             conProcessType.column.type = TWSearchColumn.Types.Process;
             conProcessType.operator = TWSearchCondition.Operations.Equals;
             conProcessType.value = processName;

             var conStatus = new TWSearchCondition();
             conStatus.column = new TWSearchColumn();
             conStatus.column.name = TWSearchColumn.ProcessInstanceColumns.Status;
             conStatus.column.type = TWSearchColumn.Types.ProcessInstance;
             conStatus.operator = TWSearchCondition.Operations.Equals;
             conStatus.value = "Active";

            var search = new TWSearch();
            search.conditions = new Array(conProcessType, conStatus);
            // Execute search and returns all active SDP process instances.
            var processInstances = search.executeForProcessInstances();

          for (var i=0; i<processInstances.length; i++) {
            var instanceId = processInstances[i].id
             processInstances[i].abort(); // This will terminate each active process instance.
          }

7. Create a “Heritage Human Service” from User Interface option in left side pane.

8. Name it as “Delete Admin Service”.

9.Inside the overview tab, we need to set Exposed to as “All Users” and Exposed As will be “Administration Service”. Refer below screenshot.

10. Now in the diagram add a new Nested Service and name it as “Delete Process Instance”.

11. Inside implementation attached a nested service which is created in step 3.

12. Now go to Process Admin Console and expand “Physical MDM Suspected Duplicates” option on the left side pane

Note : If using Process Server version then a new snapshot is to be created from the Process designer and installed on Process Server for the Process Admin console to have new administrative service available for users.

13. Now click on the “Delete Admin Service” option. This step may take sometime based on the number of tasks in the setup.

14. We will get below screen which means all the sdp task are terminated.

15. Now go to any was profile path something similar to this “C:\IBM\WebSphere\profiles\AppSrv01\bin”

16. Execute below command based on your configuration to clear all the deleted task from bpm. Please refer to this url about running these commands "https://www.ibm.com/support/knowledgecenter/en/SSFTBX_8.5.6/com.ibm.wbpm.ref.doc/topics/rref_BPMProcessInstancesCleanup.html "

wsadmin -conntype SOAP -port <soap_port> -host <hostname> -user admin -password admin -lang jython

AdminTask.BPMProcessInstancesCleanup('[-containerAcronym MDMSDP -containerSnapshotAcronym <acronym_snapshot_name> -instanceStatus ALL]')

17. After doing above step all the sdp tasks will get removed.