Hi Everyone,
we have too many unrecoverable/cancelled Workflow instances in our live ERP server and we are planning to clean them up.
are the below tables enough to delete the records from?
WORKFLOWTRACKINGTABLE
WORKFLOWWORKITEMTABLE
WORKFLOWTRACKINGSTATUSTABLE
SYSWORKFLOWMESSAGETABLE
SYSWORKFLOWTABLE
declare @TableId int = 0;
DECLARE @RecId bigint = 0, @WTST BIGINT = 0;
select @TableId = sw.CONTEXTTABLEID,@RecId = sw.CONTEXTRECID from SYSWORKFLOWTABLE as sw where INSTANCENUMBER = @WFInstance
if(@TableId != 0 and @RecId != 0)
begin
DELETE from WORKFLOWWORKITEMTABLE
where REFRECID = @RecId AND REFTABLEID = @TableId
DELETE from SYSWORKFLOWMESSAGETABLE
where WORKFLOWCONTEXTRECID = @RecId AND WORKFLOWCONTEXTTABLEID = @TableId and WORKFLOWCONTEXTCOMPANYID = 'ETIS'
select top 1 @WTST = Recid FROM WORKFLOWTRACKINGSTATUSTABLE
where CONTEXTRECID = @RecId and CONTEXTTABLEID = @TableId and TRACKINGSTATUS != 1 AND CONTEXTCOMPANYID = 'ETIS'
DELETE from WORKFLOWTRACKINGTABLE
where WORKFLOWTRACKINGSTATUSTABLE = @WTST ;
DELETE FROM WORKFLOWTRACKINGSTATUSTABLE
where CONTEXTRECID = @RecId and CONTEXTTABLEID = @TableId and TRACKINGSTATUS != 1 AND CONTEXTCOMPANYID = 'ETIS'
DELETE FROM SYSWORKFLOWTABLE WHERE CONTEXTRECID = @RecId AND CONTEXTTABLEID = @TableId AND CONTEXTCOMPANYID = 'ETIS'
END
*This post is locked for comments
I was eble to delete unrecoverable workflow instances using tables in blog post written by santosh
santoshkmrsingh.blogspot.com/.../ax2012-deleting-workflow-instance.html
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156