Clean up Workflow History

(0) Share

Report

Posted on by Karima driouich

Hi,

I would like to know if there is a way to clean up the Workflow History, because the table WorkflowTrackingTable has 3 Gb and WorkflowTrackingCommentTable has 2 Gb in the DB.

Thank you

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Dick Wenning 8,705 on at

Like (0)

Report

RE: Clean up Workflow History

use command like this

delete_from WorkflowTrackingStatusTable where WorkflowTrackingStatusTable.TrackingStatus == WorkflowTrackingStatus::Completed &&

WorkflowTrackingStatusTable.WorkflowType == WorkflowTrackingStatusWorkflowType::Workflow && WorkflowTrackingStatusTable.modifiedDateTime < DateTimeUtil::addMonths(DateTimeUtil::utcNow(),-3);

delete_from WorkflowTrackingStatusTable where WorkflowTrackingStatusTable.TrackingStatus == WorkflowTrackingStatus::Cancelled &&

WorkflowTrackingStatusTable.WorkflowType == WorkflowTrackingStatusWorkflowType::Workflow && WorkflowTrackingStatusTable.modifiedDateTime < DateTimeUtil::addMonths(DateTimeUtil::utcNow(),-3);
Community Member Microsoft Employee on at

Like (0)

Report

Re: Clean up Workflow History

Hi,

There is no standard process that meets this need but I think that you can delete WorkflowTrackingStatusTable table, but with conditions.

You can not delete records with TrackingStatus 'Pending' or 'Cancelled'. This table has a type cascade DeleteAction with WorkflowTrackingTable table, and WorkflowTrackingTable too with WorkflowTrackingCommentTable table.
Community Member Microsoft Employee on at

Like (0)

Report

Re: Clean up Workflow History

Hello,

Have you ever got an answer on this? We're facing a problem in our TEST and DEV environments where the workflow tables are bloated with rows of useless information. The workflow history form can not be opened because it freezes.

Tried to do a delete directly on the WorkflowTrakingStatusTable and it hangs forever.

Regards,

Eric