Challenge:
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 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
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]