The Case of the Missing SharePoint Workflows

By:   |   Updated: 2010-04-06   |   Comments   |   Related: > Sharepoint

Problem

A seemingly mysterious problem started occurring a couple of months after implementing a workflow solution. The workflow statuses (Completed, Approved, Rejected, etc) started disappearing.

After doing a little research, it seems that, by default, the workflow status information is purged after 60 days.

Solution

This blog indicates you can stop this behavior by disabling the "Workflow Auto Cleanup" setting in the "Operations --> Global Configuration --> Timer job defintions.

This is confirmed with a Microsoft Technet document as well. 

Dave Wollerman makes some great points in his SharePoint blog about this topic.

The Timer job definition seems to control the process with a stored procedure called "proc_AutoCleanupWorkflows".

Interestingly there is a table called "WorkflowAssociation" which has a field called "AutoCleanupDays", which is set at 60.

I do not recommend adjusting these database entries manually. They are shown here simply as a matter of interest.

According to this  Microsoft Document...

The document never explains what the "other options" are.

Conclusion

This is a damned if you do, damned if you don't situation. If you absolutely need the audit trail (why use workflow if you don't?), then changing the Timer Job Definition makes sense. Keep an eye out for system performance and consider creating a new Workflow History list for every workflow.

Next Steps
  • Check out MSSQLTips.com for great information about Microsoft SQL Server.


Last Updated: 2010-04-06


get scripts

next tip button



About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools