Removing invalid tasks from the Inbox

Customers might ask the question: 'How do I remove invalid tasks from my Inbox?'.

This is useful mostly in development when changes in a model to a stepper, workflow or duplicate management operation may render an old task inoperable. An invalid task in the Inbox means when selecting either Resume or Discard has no action 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:

   Identify task

   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 task in question set its STATUS to 'CANCELED'
   For example:

   Update Status to Canceled

   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 run 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 (even if set to Forever) 

Related articles