WF数据跟踪SqlTrackingService的问题

在练习WF的Hands-on Labs\Lab03部分的时候，遇到了一个如下的问题：

代码比较简单：

Code Snippet

1. static string connectionString = "Initial Catalog=TrackingStore; " +
2.                    "Data Source=.; " +
3.                              "Integrated Security=SSPI;";
5.         static void Main(string[] args)
6.         {
7.             using(WorkflowRuntime workflowRuntime = new WorkflowRuntime())
8.             {
9.                 workflowRuntime.AddService(new SqlTrackingService(connectionString));
11.                 AutoResetEvent waitHandle = new AutoResetEvent(false);
12.                 workflowRuntime.WorkflowCompleted += delegate(object sender,
13.                              WorkflowCompletedEventArgs e) { waitHandle.Set(); };
14.                 workflowRuntime.WorkflowTerminated += delegate(object sender,
15.                                 WorkflowTerminatedEventArgs e)
16.                 {
17.                     Console.WriteLine(e.Exception.Message);
18.                     waitHandle.Set();
19.                 };
20.                 WorkflowInstance instance = workflowRuntime.CreateWorkflow(typeof
21.                    (DefaultSQLServices.Workflow1));
22.                 instance.Start();
23.                 instance.Suspend("Reason we are suspending the workflow.");
24.                 instance.Resume();
26.                 waitHandle.WaitOne();
28.                 GetInstanceTrackingEvents(instance.InstanceId);
30.                 Console.WriteLine("Workflow Completed - press ENTER to continue");
31.                 Console.Read();
34.             }            
35.         }

 

GetInstanceTrackingEvents()方法代码如下：

Code Snippet

1. static void GetInstanceTrackingEvents(Guid instanceId)
2.         {
3.             Console.WriteLine("\r\nInstance Tracking Events :");
5.             SqlTrackingQuery sqlTrackingQuery = new SqlTrackingQuery(connectionString);
6.             SqlTrackingWorkflowInstance sqlTrackingWorkflowInstance;
7.             sqlTrackingQuery.TryGetWorkflow(instanceId, out sqlTrackingWorkflowInstance);
9.             try
10.             {
11.                 foreach (WorkflowTrackingRecord workflowTrackingRecord in sqlTrackingWorkflowInstance.WorkflowEvents)
12.                 {
13.                     Console.WriteLine("EventDescription : {0}  DateTime : {1}", workflowTrackingRecord.TrackingWorkflowEvent, workflowTrackingRecord.EventDateTime);
14.                 }
15.             }
16.             catch (Exception)
17.             {
18.                 Console.WriteLine("No Instance Tracking Events Found");
19.             }
20.         }

工作流Workflow1的只有一个Code活动，输出一段代码。

我遇到的问题是：在程序执行的时候到waitHandle.WaitOne()这一步，系统线程会停止，然后CPU始终保持在一个90%以上。尝试了很多方案，包括重启，换机器都存在问题，Google了好久也没有满意的答复。只是有一个和我遇到的类似问题的人：http://social.msdn.microsoft.com/Forums/en-US/windowsworkflowfoundation/thread/67ea8ad6-c700-4096-a9c4-164d2e7cf7cb/这里虽然没有给出确切的答复，但是给我提供一个思路：可能就是Hand-On自带的创建数据库的一些sql语句的问题。

解决：

workflow安装的位置C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL有两个文件夹ZH-CHS和EN，我本身是中文操作系统，就把ZH-CHS里面的四个sql命令文件拷贝出来，覆盖掉里面自带的SQL文件（呵呵，覆盖的时候发现文件大小不一样）。然后重新执行Hands-on Labs\Lab03里面的cmd命令，OK，问题解决。

 

总结：我们在工作过程中，经常会用到别人的现成的东西，甚至老外的。那么如果过程中出现问题，不妨考虑一下是不是语言版本的问题。