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:

    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 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) 

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

Related articles

The content by label feature displays related articles automatically, based on labels you choose. To edit options for this feature, select the placeholder below and tap the pencil icon.



Related issues