Can not start a workflow from a survey response in Windows SharePoint Services 3.0 (MOSS 2007) with "Failed to Start" error

Challenge:

sharepoint When I was approached by a co-worker to come up a quick solution to design a training registration application. The requirement is to display all upcoming training events in calendar view and allow users to register to each training. And upon the registration is submitted, the training department and the user’s supervisor should receive notifications immediately (although not required now, but might need the approval from the supervisor in later development). The deadline is very…, how to say it, … how about this afternoon. Well, while the co-worker asked how to design the database tables and asp.net coding, I suggested why not giving the SharePoint a shot. Since I am the one proposed, then I had to create it for her.

Well, that was what I came up so far. In our Microsoft Office SharePoint Server System (MOSS) 2007 with Windows SharePoint Services 3.0 (WSS), I created a calendar list to display training events; in the calendar item there was a link to another new created survey list acting as a registration form. Then I added a workflow to the survey so that emails will be sent out whenever a new response is added into the survey (or register list).

Everything is working fine, but however, the workflow does not start. Instead, the status of the workflow appears as Failed to Start.

Trouble-Shootings:

I searched this issue on Google, and I found out a lot of people had the similar errors before. Someone pointed out the cause was the user of application pool who should be Network Services instead of a user with administrative right; Someone suggested to re-active the workflow feature in SharePoint Application server; Someone asked whether it was done in SharePoint Designer  2007.


I tried every suggestion I could find, but no success at the end. I even used the SharePoint Designer to re-create another workflow, but got the same Failed to Start error. When I launched the workflow .aspx from the designer and browser it directly, I could have a Start button. But another error of The data source control failed to execute the insert command came up after I clicked the submit button.

I almost gave up since it was too time consumption for this trouble shooting, and I nearly crashed my SharePoint server with another suggestion (run stsadm command) . Right before I stopped solution searching, I found the real cause from Microsoft support site to my particular situation. And the truth is

…… because starting a workflow from a survey response is not supported in Windows SharePoint Services 3.0. Although the Workflows option appears when you click the arrow next to a survey response, you cannot start a workflow from a survey response.

…..

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Solution:

Well, although I did not get the fix, I at least saved my time to play with workflow in survey list again.

Based on it, in this training registration issue, I decided not to use survey list. Instead I create a Custom List to act like a registration form to collect information from users. And after I added Workflow to this new created custom list, and then add a new item into the list. You know what, I got email notification generated by the workflow now.

Referred link: http://support.microsoft.com/kb/926370

Share
Tags: , , , ,
If you feel this post is helpful for you, you are welcome to leave your comments here, or click the Paypal button at the right to buy me a beer :-)  

18 Responses to “Can not start a workflow from a survey response in Windows SharePoint Services 3.0 (MOSS 2007) with "Failed to Start" error”


  • hi, It was gr8 reading about the issue.As i’m new to the world of sharepoint i need ur help in achieving the same task that is How to create a training calendar using which the general user on the intranet can enroll for the trainings.How do you make the custom list work for you as a registration form?How do you connect it to the calendar list?Also i want to create the Workflow in the Sharepoint designer rather than VS We dont hav a MOSS, we are working on WSS 3.0 to set up our intranet site.I’m looking forward to ur reply.
    Thanks in advance.
    Kunal

    [Reply]

  • I have a question that may be off topic but I am looking for advice as to upgrade to Windows Vista or not. My PC is currently running XP.
    Are there pitfalls that one should consider ?

    [Reply]

  • Thanks for the post, I have been driving myself crazy trying to get the workflows to work on survey’s. The work flows are working on other list, so that eliminated several suggestions I found about server settings or changes. We are using our surveys as training quizes and wanted a workflow to trigger the grading, recording, and responding with results. Not sure if I want to tackle re-creating all the survey’s as forms. Do you have the link to Microsoft’s admittance of the issue, or any updates on them fixing it?

    Thanks again for your post, helped me regain some sanity.

    [Reply]

  • Thank you very very much.

    I saved a lot of time by discovering this flaw in MS Sharepoint Survey List.

    [Reply]

  • Thanks for the post. This was driving me crazy. Guess this is just one more reason of many not to use survey lists in SharePoint.

    [Reply]

  • I was pulling my hair out with this one before I googled this post. Thanks for teh answer.

    [Reply]

  • Again, I echo the thanks for this. Kept me from going bald… Thanks again!

    [Reply]

  • Thanks for documenting this issue!
    I found a great workaround though: survey results can be viewed as an RSS feed. If I subscribe to the RSS within internet explorer, it syncs to my outlook. That way even though I cannot get an email notification or alert, I am able to view something without continually checking for new survey results.

    [Reply]

  • Hi,
    Thanks for the given information regarding Share point online 2010. You can get the

    more related online training details like:
    SharePoint Designer Training
    SharePoint Developers Training
    SharePoint Administration Training

    [Reply]

  • Hi,
    Thanks for the given information regarding Share point online 2010. You can get the more related online training details like:
    SharePoint Designer Training
    SharePoint Developers Training
    SharePoint Administration Training

    [Reply]

  • “Trouble-Shootings:
    I searched this issue on Google, and I found out a lot of people had the similar errors before. Someone pointed out the cause was the user of application pool who should be Network Services instead of a user with administrative right; Someone suggested to re-active the workflow feature in SharePoint Application server; Someone asked whether it was done in SharePoint Designer 2007.” Thanks these couple of lines saved many headaches

    [Reply]

  • Thanks for this post, even now in 2011 we’re still working in MOSS 2007 and had the same issue. It freaked me out! This post finally made an end in using the survey’s as an input for a changemanagement proces.
    But now a new issue is playing up… the branching logic used in the survey doesn’t seem available in the list format. Do you perhaps now if I can do anything about that? How can I make a branching logic in a list?

    [Reply]

  • Thank you for the great post! Certainly come in handy. See my site http://www.lnet.eu/internet/czy-studia-naprawde-daja-prace/. Bye!

    [Reply]

  • Hiya, I am really glad I have found this info. Nowadays bloggers publish only about gossip and internet stuff and this is really frustrating. A good website with exciting content, that’s what I need. Thanks for making this site, and I’ll be visiting again. Do you do newsletters? I Cant find it.

    [Reply]

  • I’m extremely impressed with your writing talents and also with the layout for your blog. Is that this a paid subject or did you modify it your self? Either way stay up the excellent quality writing, it’s uncommon to look a nice weblog like this one these days..

    [Reply]

  • I must grab the power using to thank you actually for that professional comments May possibly are inclined to really enjoyed reading the sites. We’re anticipating the complete start brand new environs learn perfectly as the the complete footwork could not has been add pouring in to your blog post. Should i is probably associated with make it possible to certain people, We are happy that can assist with what I even have discovered from this point.

    [Reply]

  • 30. I’ve been surfing on-line more than three hours as of late, but I by no means discovered any interesting article like yours. It¡¦s pretty value sufficient for me. In my opinion, if all web owners and bloggers made just right content as you probably did, the internet will be much more useful than ever before.

    [Reply]

  • I was excited to discover this great site. I want to to thank you for ones time for this fantastic read!! I definitely liked every little bit of it and i also have you saved to fav to check out new stuff on your website.

    [Reply]

Leave a Reply

If you feel this post is helpful for you, you are welcome to leave your comments here, or click the Paypal button at the right to buy me a beer :-)  


Get Adobe Flash playerPlugin by wpburn.com wordpress themes