Sharepoint 工作流程无法启动
经过一段时间后，Sharepoint MOSS 2007 系统上的 wokflow 停止运行。 它们不会启动，其状态始终保持在“正在启动”状态。 声明式工作流程仍然存在问题。 即使我们尝试手动运行工作流程。 通过重新启动 owtimer 服务暂时解决了问题，但大约 5 分钟后，它再次停止运行。 有人遇到过类似的问题吗？
After some point wokflows on Sharepoint MOSS 2007 System stopped functioning. They do not start, their status allways remains in 'Starting' state. The issue remains for a declarative workflow. And even if we try to run workflow manually. Issue resolved temporary by restarting owstimer service, but after about 5 minutes it again stops functionaing again. Did anybody run into the similar issue?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我们解决了问题。 这是一个由于糟糕的设计和意外的无效输入而陷入无限循环的工作流程。 它在 WSS_Content 数据库的 EventCache 和 ScheduledWorkItems 表中生成大量行。 因此，带有 SQLServer 的 WSSTimer 正在消耗所有试图读取大量数据的资源。 问题很难在 Sharepoint 本身上定位，它无法诊断单个工作流程实例。 我们仅在对数据库本身进行分析后才发现问题。
We resolved the problem. It was one workflow which has stuck in infinite loop due to bad design, and accidental invalid input. It was generating huge number of rows in EventCache and ScheduledWorkItems tables in WSS_Content database. So WSSTimer with SQLServer was eating all the resources trying to read tremendous amounth of data. Problem was very hard to localize on Sharepoint itself, it has no means of diagnosing invididual workflow instanses. We figured issue only after profiling on database itself.