Share
ReportHi 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 have the same question (0)
All responses (
Answers (
1