惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

WordPress大学
WordPress大学
Microsoft Security Blog
Microsoft Security Blog
Security Archives - TechRepublic
Security Archives - TechRepublic
V
Visual Studio Blog
宝玉的分享
宝玉的分享
IT之家
IT之家
人人都是产品经理
人人都是产品经理
T
The Blog of Author Tim Ferriss
I
InfoQ
B
Blog RSS Feed
T
Threatpost
博客园_首页
M
MIT News - Artificial intelligence
Spread Privacy
Spread Privacy
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
Know Your Adversary
Know Your Adversary
U
Unit 42
Engineering at Meta
Engineering at Meta
C
Cyber Attacks, Cyber Crime and Cyber Security
月光博客
月光博客
Scott Helme
Scott Helme
T
Tor Project blog
有赞技术团队
有赞技术团队
AWS News Blog
AWS News Blog
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Last Week in AI
Last Week in AI
S
Schneier on Security
Vercel News
Vercel News
博客园 - Franky
C
Cybersecurity and Infrastructure Security Agency CISA
L
LINUX DO - 热门话题
NISL@THU
NISL@THU
L
LangChain Blog
爱范儿
爱范儿
Google DeepMind News
Google DeepMind News
The GitHub Blog
The GitHub Blog
雷峰网
雷峰网
Latest news
Latest news
C
CXSECURITY Database RSS Feed - CXSecurity.com
Hugging Face - Blog
Hugging Face - Blog
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
www.infosecurity-magazine.com
www.infosecurity-magazine.com
G
GRAHAM CLULEY
S
Security Affairs
A
About on SuperTechFans
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
大猫的无限游戏
大猫的无限游戏
W
WeLiveSecurity
Cisco Talos Blog
Cisco Talos Blog
罗磊的独立博客

博客园 - yo

Silverlight 缺陷 - yo - 博客园 SilverLight Controls SilverLight框架初探-View - yo - 博客园 SilverLight框架初探-RiaService SilverLight框架初探-ViewModel SilverLight框架初探 与客户“调情” AG_E_PARSER_BAD_PROPERTY_VALUE 定义属于自己的Routing 数据契约的序列化 WCF客户端配置问题 关闭EXCEL进程 母版页中控件ID获取 - yo - 博客园 Reportviewer - Error: ASP.NET session has expired - yo SQL CLR C# DLL动态调用 Sharepoint List faults - yo 出错页面webpar的t删除 quickpart
WF 4.0 中 Persistence 异常 - yo
yo · 2010-03-31 · via 博客园 - yo

最近在跟着 WXWinter 学Workflow,收益非浅。 

根据 WXWinter 所提供的关于 会签业务流程 例子,自己也尝试了做一个流程控制,结果在 Persistence 时,出现了一个异常:

{"The execution of the InstancePersistenceCommand named {urn:schemas-microsoft-com:System.Activities.Persistence/command}CreateWorkflowOwner was interrupted by an error."}

找了半天,最后发现原来是数据库里缺少了System.Activities.DurableInstancing支持。

但这些是什么时候产生的呢?应该会有什么工具可以辅助我们执行相关操作吧。最后在一个老外那找到了一种方式:

http://coding.roecher.de/2010/02/08/could-not-find-stored-procedure-system-activities-durableinstancing-createlockowner/

如果有其他更好的方式,希望能分享一下

打开命令行,例如输入:

osql -E -S ServerName -d DBName -i C:\Windows\Microsoft.NET\Framework\v4.0.30128\SQL\en\SqlWorkflowInstanceStoreSchema.sql
osql -E -S ServerName -d DBName -i C:\Windows\Microsoft.NET\Framework\v4.0.30128\SQL\en\SqlWorkflowInstanceStoreLogic.sql

完成后,我们再到数据库里查看,就可以看到System.Activities.DurableInstancing的东西了。

当解决这个问题后,运行时,又出现了另一个异常,错误信息如下:

"The execution of an InstancePersistenceCommand was interrupted because the instance '340e56da-3d32-4ca6-9729-2fb5ed19a0cb' is locked by a different instance owner. This error usually occurs because a different host has the instance loaded. The instance owner ID of the owner or host with a lock on the instance is '954d7075-4937-49fe-9213-b2009c6dbcc1'."

还好, WXWinter 已经给出了 答案 ,我们需要将PersistableIdleAction设为PersistableIdleAction.Unload;