Tag Archives: Workflow Auto Cleanup workflow history disappears

最新推荐文章于 2023-12-12 09:15:21 发布

领跑二十一世纪

最新推荐文章于 2023-12-12 09:15:21 发布

阅读量531

点赞数

分类专栏： sharepoint

sharepoint 专栏收录该内容

183 篇文章 2 订阅

订阅专栏

SharePoint Workflow History “Disappears”

By Marc Anderson in SharePoint October 14, 2008 3 Comments

By default, workflow history will "disappear" after 60 days. Microsoft has built this into MOSS intentionally to ensure good performance. By deleting old workflow history, it’s more likely (but hardly guaranteed) that the Workflow History list (/Lists/Workflow History by default) will stay below the magic 2000 items per list limit. (See the "Working with Large Lists in Office SharePoint Server 2007" white paper for details on this limit.)

The official Microsoft answer to this in Technet is to disable the Workflow Auto Cleanup Timer Job. Unfortunately, this is a farm-level setting and will affect every Site Collection in your farm, which may be more far-reaching than you intend. However, it might be the right solution for you.

Another option is to run some code to change the time length for the history retention. There is some good code and discussion here (I’m reproducing the code below in case the link changes. Thanks to Shola Salako! I haven’t tested this code, so use it carefully.) to do this by changing the value of SPWorkflowTemplate.AutoCleanupDays on specific lists. NOTE: Don’t use the SQL method! Running the C# example which utilizes the object model is perfectly legitimate, but poking around in the database will leave you in what Microsoft calls an "unsupported state" and is just a bad idea.

For companies that rely on workflow history for auditing and regulatory compliance, taking one of these actions is going to be critical.

 
       1: /* 
       2: * Date: September 17, 2007 
       3: *  
       4: * Program Description: 
       5: * ==================== 
       6: * This program is a workaround for Microsoft Office SharePoint Server 2007 
       7: * bug #19849, where the AutoCleanupDays is set to 60 by default and by design 
       8: * in MOSS installations. This program gives the customer the opportunity to 
       9: * change this number. 
* Workflow histories would not show after 60 days by default. 
*/ 
using System; 
using System.Collections.Generic; 
using System.Text; 
using Microsoft.SharePoint; 
using Microsoft.SharePoint.Workflow; 
   
namespace ShowWFs 
{ 
class Program 
    { 
static string siteName; 
static int newCleanupDays, assoCounter; 
static string libraryName, wfAssoName; 
static SPSite wfSite; 
static SPWeb wfWeb; 
static SPList wfList; 
static void Main(string[] args) 
        { 
try 
            { 
switch (args.Length) 
                { 
case 0: //no parameters entered by user 
                        { 
                            System.Console.WriteLine("Error: No arguments entered (site, library, workflow and days)"); 
                            showHelpUsage(); 
break; 
                        } 
case 4: //correct number of parameters 
                        { 
                            siteName = args[0]; 
                            libraryName = args[1]; 
                            wfAssoName = args[2]; 
                            newCleanupDays = Convert.ToInt32(args[3]); 
                            assoCounter = 0; 
                            wfSite = new SPSite(siteName); 
                            wfWeb = wfSite.OpenWeb(); 
                            wfList = wfWeb.Lists[libraryName]; 
                            SPWorkflowAssociation _wfAssociation = null; 
foreach (SPWorkflowAssociation a in wfList.WorkflowAssociations) 
                            { 
if (a.Name == wfAssoName) 
                                { 
                                    a.AutoCleanupDays = newCleanupDays; 
                                    _wfAssociation = a; 
                                    assoCounter++; 
                                } 
else 
                                { 
                                    _wfAssociation = a; 
                                } 
                            } 
                            wfList.UpdateWorkflowAssociation(_wfAssociation); 
                            System.Console.WriteLine("n" + wfAssoName + ": " + assoCounter.ToString() + " workflow association(s) changed successfuly!n"); 
break; 
                        } 
default: //default number of parameters 
                        { 
                            System.Console.WriteLine("Incorrect number of arguments entered (" + args.Length.ToString() + " arguments)"); 
                            showHelpUsage(); 
break; 
                        } 
                } 
   
            } 
catch (Exception e) 
            { 
                System.Console.WriteLine("An error has occurred. Details:n" + e.ToString()); 
            } 
finally 
            { 
if (wfSite != null) 
                    wfSite.Dispose(); 
if (wfWeb != null) 
                    wfWeb.Dispose(); 
                System.Console.WriteLine("nFinished setting AutoCleanupDays!"); 
            } 
        } 
static void showHelpUsage() //help screen 
        { 
            System.Console.WriteLine("nnMOSS Workflow Set AutoCleanup Usage:"); 
            System.Console.WriteLine("===================================="); 
            System.Console.WriteLine("ShowWFs siteURL library workflow days"); 
            System.Console.WriteLine(" - siteURL (e.g. http://serverURL/site)"); 
            System.Console.WriteLine(" - library (e.g. "Shared Documents")"); 
            System.Console.WriteLine(" - workflow (e.g. "Approval")"); 
            System.Console.WriteLine(" - days for auto clean up (e.g. 120)"); 
        } 
    } 
} 
   

Technorati Tags: SharePoint, workflow history, Workflow Auto Cleanup, SPWorkflowTemplate.AutoCleanupDays

领跑二十一世纪

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Tag Archives: Workflow Auto Cleanup workflow history disappears

SharePoint Workflow History “Disappears”By Marc Anderson in SharePoint October 14, 2008 3 Comments By default, workflow history will "disappear" after 60 days. Microsoft has bu
复制链接

扫一扫

专栏目录