Uncategorized

SP2013 – Permissions for Workflow Manager account

The workflow service account should have appropriate permission in database “WFInstanceManagementDB” and “WFResourceManagementDB” for the workflow to  publish and run successfully.

Side effects if the account does not have appropriate permission.

  1. Workflow may not publish properly
  2. Workflow history status screen may not open i.e., the workflow link for list item may show unexpected error

How to troubleshoot this issue?

  1. Login to web front end server and open event viewer -> Applications and Services log -> Microsoft-Workflow and click “Operational”
  2. Look for error message as shown below

Failed SQL command after 1 tries with error ‘229’. Exception: System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘InsertTrackingAndStatus’, database ‘WFInstanceManagementDB’, schema ‘dbo’.

giving appropriate permission to the service account as mentioned in the start of the article fixed this issue.

side note : I gave db_owner permission for the service account. Not sure about the actual permission at the time of writing this article.

Useful resources:

http://vietsharepoint.blogspot.com.au/2013/10/sharepoint-2013-workflow-cant-start.html

https://social.msdn.microsoft.com/Forums/office/en-US/2575c032-840a-440b-8c60-84457648f007/sp-designer-2013-workflow-internal-server-error-when-publishing?forum=sharepointcustomization

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s