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 (https://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