Monday, February 3, 2014

SharePoint 2013: Workflow Manager Installation and configuration issues…

Installing and configuring Workflow Manager 1.0 can be frustrating, if you do not follow the right steps. I installed Workflow Manager 1.0 and ran the default configuration successfully. After installation, I figured that I need to install following cumulative update in the order specified below.

SNAGHTML206d45

After installation of above CUs, I was able to create a WF Manager based site workflow and publish it successfully and I thought I cracked it!

But when I tried to browse the site workflow, the page threw an error. The ULS log suggested that there was an error in Data Access Layer. So I fired up the SQL Server Profiler and figured out some database entries were missing in following table. See the screen below for the table and the error text:

image 

Microsoft.Workflow.TestServiceHost.exe Error: 0 : System.IO.InvalidDataException: A required Workflow Configuration 'WorkflowServiceScopeSnapshotProcessBatchSize' is not present. Please add this configuration value.

I put the entry my self, don’t ask how I came up with values, I put random large numbers because I couldn’t wait to see my workflow working. I put about 4 entries in that table before and finally, the error changed to something else. To be precise, now the error was a missing parameter in a Stored Procedure and finally, I gave up thinking that there must be something terribly wrong here… I decided to uninstall it


Uninstalling Workflow Manager in Single Server environment:


http://social.msdn.microsoft.com/Forums/windowsazure/en-US/86162367-5d43-4f8e-81d4-12440d9dbcde/error-when-running-workflow-form-list-item-workflow-manager-sharepoint-2013?forum=wflmgr


Steve mentioned the steps to uninstall Workflow Manager from the dev environment and I was able follow the steps and uninstall it. For the sake of completeness, I provide a screenshot of un-installation steps below (thank to Steve)


image


followed by successful installation…


After uninstalling, I tried following video tutorial to install and configure Workflow Manager Successfully!


Please consider every single step in this tutorial as important, if you want to see the workflow manager up and running in your dev environment.


http://msdn.microsoft.com/en-US/library/dn201724