SharePoint workflows won't start
After some wokflows in Sharepoint MOSS 2007 system stopped working. They do not start, their status always remains in the "Start" state. The problem remains for a declarative workflow. And even if we try to start the workflow manually. The problem was resolved temporarily by restarting the owstimer service, but after about 5 minutes it stops functioning again. Has anyone faced a similar problem?
source to share
We have solved the problem. It was one workflow that got stuck in an infinite loop due to poor design and accidental invalid input. It generated a huge number of rows in the EventCache and ScheduledWorkItems tables in the WSS_Content database. So WSSTimer with SQLServer was eating all the resources trying to read huge amounts of data. The problem was very difficult to localize on Sharepoint itself, it does not have tools to diagnose invisible workflows. We only solved the problem after profiling the database itself.
source to share