During the development phase of your project, you will often modify your steppers, workflows, or duplicate managers to meet your business requirements.

When you modify these elements, any running tasks using them may become invalid and unusable.

An invalid task in the Inbox means that, even if you click on Resume or Discard, there is no action performed, and the item remains in the Inbox with no way of removing it via the application.

Instructions

1. Identify the stepper, workflow, or duplicate management operation by running any of these queries as appropriate:

SELECT * FROM SEMARCHY_REPOSITORY.MTA_INTEG_LOAD WHERE STEPPER_NAME = 'MyStepper' ;
SELECT * FROM SEMARCHY_REPOSITORY.MTA_INTEG_LOAD WHERE WORKFLOW_NAME = 'MyWorkflow' ;
SELECT * FROM SEMARCHY_REPOSITORY.MTA_INTEG_LOAD WHERE DUPSMGR_NAME = 'MyDupesManager' ;
SELECT * FROM SEMARCHY_REPOSITORY.MTA_INTEG_LOAD WHERE LOADID = 123 ;

2. When you have identified the concerned task, set its STATUS to 'CANCELED'
For example:

UPDATE SEMARCHY_REPOSITORY.MTA_INTEG_LOAD SET STATUS='CANCELED' WHERE STEPPER_NAME = 'AuthorPersons' ;
UPDATE SEMARCHY_REPOSITORY.MTA_INTEG_LOAD SET STATUS='CANCELED' WHERE WORKFLOW_NAME = 'ApproveCreateCustomer' ;
UPDATE SEMARCHY_REPOSITORY.MTA_INTEG_LOAD SET STATUS='CANCELED' WHERE DUPSMGR_NAME = 'ManageDuplicatesOnPerson' ;
UPDATE SEMARCHY_REPOSITORY.MTA_INTEG_LOAD SET STATUS='CANCELED' WHERE LOADID = 123 ;

3. Then schedule a purge job to remove it from the repository.
Any task with a status of 'CANCELED' will be removed by the purge job, no matter what retention period is set.

Warning: Do NOT delete record(s) from MTA_INTEG_LOAD, as doing so will risk leaving orphan data in other tables in the Repository.