tag:blogger.com,1999:blog-1705051721030116110.post3995294285997651529..comments2023-12-19T17:25:23.739-08:00Comments on Development Hole: Locked Workflowtxs8311http://www.blogger.com/profile/07046898420109468604noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-1705051721030116110.post-23654599314697042412012-03-26T16:43:04.972-07:002012-03-26T16:43:04.972-07:00حامد باقرزاده,oh man...u rly helped me. I removed ...حامد باقرزاده,oh man...u rly helped me. I removed onTaskCreated Activity and it's work. But i can't understand why it's work now :DSuvitrufhttp://suvitruf.ru/noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-80178557390742911102011-12-21T21:15:24.354-08:002011-12-21T21:15:24.354-08:00Nothing here worked for me, until I found this: ht...Nothing here worked for me, until I found this: http://blogs.sharepointpro.net/2011/02/24/this-task-is-currently-locked-by-a-running-workflow-and-cannot-be-edited.aspx?results=1<br /><br />Unlock all locked workflow tasks with a single PowerShell command, ridiculously easy.RyGuyhttps://www.blogger.com/profile/05365752297039828321noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-26354969754525757322011-12-21T21:15:22.339-08:002011-12-21T21:15:22.339-08:00Nothing here worked for me, until I found this: ht...Nothing here worked for me, until I found this: http://blogs.sharepointpro.net/2011/02/24/this-task-is-currently-locked-by-a-running-workflow-and-cannot-be-edited.aspx?results=1<br /><br />Unlock all locked workflow tasks with a single PowerShell command, ridiculously easy.RyGuyhttps://www.blogger.com/profile/05365752297039828321noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-8238075172445745492011-12-21T21:15:08.266-08:002011-12-21T21:15:08.266-08:00Nothing here worked for me, until I found this: ht...Nothing here worked for me, until I found this: http://blogs.sharepointpro.net/2011/02/24/this-task-is-currently-locked-by-a-running-workflow-and-cannot-be-edited.aspx?results=1<br /><br />Unlock all locked workflow tasks with a single PowerShell command, ridiculously easy.RyGuyhttps://www.blogger.com/profile/05365752297039828321noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-214380799921501942011-11-30T11:33:37.224-08:002011-11-30T11:33:37.224-08:00In my case I had this problem on a workflow that w...In my case I had this problem on a workflow that was an out-of-the-box MOSS workflow. I found the comment from Mind to be very helpful. Of course this is highly discouraged, but it does seem to work perfectly. <br /><br />The only thing I would add is that if you hover over your stuck list item in the task list then you will see the ID of the item at the end of the link (bottom left corner). Use this ID and use 'and tp_ID = ####' instead of tp_DirName. This will help ensure that you update only one item at a time (if that's what you want). I figure this is safer than a bulk update. I also checked what would be updating first by running a similar select command first.<br /><br />SELECT * FROM dbo.AllUserData<br />WHERE tp_WorkflowVersion != 1<br />AND tp_ID = ####Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-24024789695713997642011-08-05T11:42:50.938-07:002011-08-05T11:42:50.938-07:00Thanks very much for your assistance on this matt...Thanks very much for your assistance on this matter. I had to dynamically set a field on the workflow task item which required a item.Update() method call. This update was then causing a lock. By setting the task workflow version back to 1 this removed the problem.J Carterhttps://www.blogger.com/profile/08650188744000977099noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-83836524562459784052010-11-23T06:39:00.425-08:002010-11-23T06:39:00.425-08:00Hi thx so much this saved my day!
I included your...Hi thx so much this saved my day!<br /><br />I included your method in my full example to notify a workflow from an external event (<a href="http://sharepointologic.blogspot.com/2010/11/programmatically-approve-sharepoint.html" rel="nofollow">http://sharepointologic.blogspot.com/2010/11/programmatically-approve-sharepoint.html</a>Djavan ROAhttps://www.blogger.com/profile/06476614200353463092noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-51243445543622068502009-11-15T23:00:16.121-08:002009-11-15T23:00:16.121-08:00hi
I solved my problem by removing onTaskCreated ...hi<br /><br />I solved my problem by removing onTaskCreated Activity from workflow<br /><br /><br />I have same problem, but in my case, workflow is not firing OnTaskChanged event and workflow is locked for everحامد باقرزادهhttps://www.blogger.com/profile/02660027129362155049noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-65050295671115696762009-11-15T22:51:07.781-08:002009-11-15T22:51:07.781-08:00Hi,
I have same problem
in my case ontaskchanged n...Hi,<br />I have same problem<br />in my case ontaskchanged not fire and workflow locked for ever.<br />i can solve my problem by removing onTaskCreated Activity from my workflow and now my workflow is working properly.<br /><br />my previous workflow<br /><br />CreatetaskWithContentType<br />onTaskCreated<br />While<br /> onTaskChanged<br />End While<br />completeTask<br /><br />my workflow now<br /><br />CreatetaskWithContentType<br />While<br /> onTaskChanged<br />End While<br />completeTaskحامد باقرزادهhttps://www.blogger.com/profile/02660027129362155049noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-328622839502515432009-11-02T12:07:33.092-08:002009-11-02T12:07:33.092-08:00Hi there, I didn't really know how to implemen...Hi there, I didn't really know how to implement the code you posted, but I decided to fish around and try some things out manually. I know it's highly frowned upon, but I was able to run some UPDATE queries on the AllUserData table that stored those workflows. I changed the non-1 versions to 1, and it solved my problem (for now). Here's what I did.<br /><br />UPDATE dbo.AllUserData<br />SET tp_WorkflowVersion='1'<br />WHERE tp_WorkflowVersion != '1'<br /> AND tp_DirName = 'quality/Lists/Document Review Tasks'<br /><br />You would change tp_DirName to whatever directory/list/task list name you are dealing with.<br /><br />If anyone can shed some light as to how to implement the code in this blog, that would be very helpful!Unknownhttps://www.blogger.com/profile/18241234781979084776noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-83524892360697989972009-10-26T06:28:59.970-07:002009-10-26T06:28:59.970-07:00Hey Friend
I have same problem, but in my case, wo...Hey Friend<br />I have same problem, but in my case, workflow is not firing OnTaskChanged event and workflow is locked for ever<br /><br />i dont know how to resolve this problem, can you help me?حامد باقرزادهhttps://www.blogger.com/profile/02660027129362155049noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-89091724421528839952009-02-13T13:34:00.000-08:002009-02-13T13:34:00.000-08:00I'm having this problem with my workflow! Can you ...I'm having this problem with my workflow! Can you please give me some directions how to use the code snippet above??Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-2736555827574491672008-05-01T23:50:00.000-07:002008-05-01T23:50:00.000-07:00The solution is really great but in our scenario t...The solution is really great but in our scenario the DLL was same, we never changed it but were facing the issue. Thanks anyway!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-15185425483279029592008-02-15T09:03:00.000-08:002008-02-15T09:03:00.000-08:00Thank u very very much! With this I was able to re...Thank u very very much! With this I was able to resurrect some workflows having randmonly this issue. What I would like is to find out the reason. Why this attribute is left with values like 1024, 8096? It's cleary a flag. I think I will take a look in the WSS 3.0 assemblies to find out when is set.<BR/><BR/>Cheers,<BR/><BR/>TibiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-74030634317999766052008-02-12T12:43:00.000-08:002008-02-12T12:43:00.000-08:00You could use it as you would the SPWorkflowTask.A...You could use it as you would the SPWorkflowTask.AlterTask method, adding the attempts and timeout parameters. Here's someone who was having issues and posted some code:<BR/><BR/><A HREF="http://www.serious-sam.net/serendipity/index.php?/archives/18-More-SharePoint.html" REL="nofollow">http://www.serious-sam.net/serendipity/index.php?/archives/18-More-SharePoint.html</A>txs8311https://www.blogger.com/profile/07046898420109468604noreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-44291698748870584902008-02-12T12:24:00.000-08:002008-02-12T12:24:00.000-08:00How would I use this code snippet? Do you have an ...How would I use this code snippet? Do you have an example of that?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-6971880837413124232008-01-30T11:20:00.000-08:002008-01-30T11:20:00.000-08:00Thank you very much. I had the same problem, your ...Thank you very much. I had the same problem, your solution works fine.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1705051721030116110.post-47423921036135684782007-11-14T13:39:00.000-08:002007-11-14T13:39:00.000-08:00Thank you so much for the tip, your code did the t...Thank you so much for the tip, your code did the trick. I think the reason WorkflowVersion changes is because there's a different version of the workflow dll. So when you recompile your workflow and DLL is changed in the GAC while there are still running workflows, trying to finish any of those workflows might give you "This task is currently locked.." error. <BR/><BR/>Elena.Anonymousnoreply@blogger.com