Friday, January 25, 2013

SPD workflow Failed on start (retrying)

I have been wrestling with this issue for about 60 days, the issue occurs when you create a simple OOB SPD workflow or even a Nintex workflow.
The solution to this is two parts

PART I
=================
The service account should be a part of
1. Looked at the groups in the local machine
· WSS_WPG
· WSS_ Restricted
· WSS_Admin_WPG
· IIS_WPG
2. Checked on the SQL management studio  > security > logins > Service account > properties > server roles were given as dbcreator > security & system admin > public
      Looked in user mappings the service account  was set db owner
3. >> Looked in the application content database in SQL
      service account should be  is a db owner
4. In  Central Admin page  > policy for web application > add service account as full control 
5. CA > operations tab > update farm administrators group > service account is added there
6. looked in the site > site settings > site collection administrator
7. looked in the component services > dcom config > IIS admin service > security > added the service account to launch and activation > access permissions > and Configuration permissions .

After doing all these settings the service account must have all the require permissions

PART II
===============
Second part of the solution is change the service account from the central admin page & run an IIS reset
this is the main key and you will have to compulsorily do this to resolve the issue

hope it works for you


No comments:

Popular Posts

Disclaimer

The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.