Workflow Manager Backend service failure after upgrade to 1.0 refresh


I did an offline upgrade of workflow manager 1.0 and workflow manager 1.0 from version 2.0.20992.0 to 2.0.40131.0 by installing the ‘Workflow Manager CU2 to get to 1.0 Refresh’ as in the below figure.

 

The installation went through just fine. When I try to start workflow manager service I get the below error and the workflow manager backend services stopped working:

The asynchronous operation has completed with an exception. Exception message is: System.InvalidOperationException: The current version of the Workflow Resource Management Store, 1.0.1.0, is older than the running product which is designed for the Workflow Resource Management
Store version 1.0.2.0. Please upgrade the Workflow Resource Management Store.
at Microsoft.Workflow.Management.SqlDataAccessProviderDefinition.CreateDataAccessProvider()
at Microsoft.Workflow.Service.WorkflowServiceBackendHost.WorkflowServiceBackendStartAsyncResult.StartRuntime()
at Microsoft.Workflow.Service.WorkflowServiceBackendHost.WorkflowServiceBackendStartAsyncResult.StartRuntimeCallback(Object state).

The error message seems interesting, the service is looking for the version 1.0.2.0 but instead it finds version 1.0.1.0. Checked the entry in [WFResourceManagementDB].[dbo].[StoreVersionTable] and it shows 1.0.1.0. The upgrade to 2.0.40131.0 did not threw any errors and ideally the StoreVersionTable should contain the
value 1.0.2.0. Now I am checking for ways to get out of this inconsistency.
I do have the Service Bus CU1 update (http://www.microsoft.com/en-in/download/details.aspx?id=36794 ) which is prerequisite to install for the upgrade to 2.0.40131.0.

First I thought of uninstalling and reinstalling the farm completely. In that case I can choose to install the WorkFlow manager 1.0 Refresh from Web Platform Installer.

After some research, I found out the way to execute the database upgrade step manually.

You can find WorkflowServiceInstanceManagementDBUpgradeScript and WorkflowServiceResourceManagementDBUpgradeScriptsql scripts in WFM install path\1.0\Workflow. These Scripts are shipped as part of the cumulative update for WFM. Run the scripts manually on any node of the WFM farm. Please check the target version in wfupgradepolicy.config in the same location before running the scripts. This should be of CU2 version as in figure below.

 

After executing the WorkflowServiceInstanceManagementDBUpgradeScript and WorkflowServiceResourceManagementDBUpgradeScriptsql scripts in WFM install path\1.0\Workflow against the respective databases. The version number is showing correctly in the [WFResourceManagementDB].[dbo].[StoreVersionTable] .
Now, the Workflow service came up successfully. Did few more tests to confirm everything works fine.

Hope this helps!

 

Written By
Jainath Ramanathan

Reviewed By
Arindam Paul Roy

Microsoft India GTSC

Comments (4)

  1. swanl98 says:

    Hi

    Could you explain how did you executed the SQL WorkflowServiceInstanceManagementDBUpgradeScript and WorkflowServiceResourceManagementDBUpgradeScriptsql scripts.

    Thanks

    Swanl98

  2. Jainath V R says:

    Hi Swanl98

    The scripts are present at scripts present at 'WFM install path1.0Workflow' folder.

    Run the WorkflowServiceInstanceManagementDBUpgradeScript against 'WFInstanceManagementDB' and WorkflowServiceResourceManagementDBUpgradeScriptsql against 'WFResourceManagementDB' .

    -Jai

    '

  3. NewToSharepoint says:

    Jainath

    Not sure how you can run these scripts against those databases. Please provide more detail. Thanks

  4. swtjen01 says:

    Here is how to run the scripts against the databases:

    If SQL Server Management Studio is installed on the workflow server (dev)

     1.  Double click the script file (this should automatically start SSMS)

     2.  Choose the SQL Server that contains the wf databses. The script will show up n the query window.

     3.  In the drop down choose the database that correlates with each script

           WorkflowServiceInstanceManagementDBUpgradeScript choose 'WFInstanceManagementDB'

            WorkflowServiceResourceManagementDBUpgradeScriptsql choose 'WFResourceManagementDB'

     4.  Click Execute button to run the script.

    If SQL Server Management Studio is not installed on the workflow server (production)

     1.  Copy both script files to a server that has SSMS installed and follow steps 1-4 listed above.

    Hope this helps

    -Jen

Skip to main content