Workflow Manager Installation Errors.

 Workflow Manager Installation Errors.

Error 1:

Service Fabric Runtime_5_1: Failed.

Fatal error during installation.

DependencyFailed: Windows Azure Pack: Service Bus 1.1 with TLS 1.2 Support.

 

Solution:

If windows 2012 OS required the below prerequisites which was causing Microsoft Azure Service Fabric installation to fail.

1.       Upgrade SQL Server 2012 to support TLS 1.2 KB 2858668 is required by Service Fabric for Windows Server 2012.

https://support.microsoft.com/en-us/topic/pla-data-collector-sets-stop-after-72-hours-on-a-windows-server-2012-based-computer-2bfcb876-e848-2577-77e3-136ad1a034bb

2.       Install .NET Framework 4.6.2

 

Also needed to add the WFM Run-As account to the local Administrator group this is a new change with Service Bus 1.1 with TLS 1.2 since Azure Service Fabric is a .NET application.

 

Provided below template with complete steps to be followed:

if you are running Service Bus 1.0 CU1 KB2799752 then upgrading to Service Bus 1.1 With TLS 1.2 support will be a two-stage process.

 

Before following the steps below confirm that the 2013 workflow is functional running WFM 1.0 CU5 KB4055730. This step helps isolate workflow issues with each update.

 

PLA data collector sets stop after 72 hours on a Windows Server 2012-based computer

Fixed an issue in which PLA data collector sets stop 72 hours after they are started on a windows server 2012-based computer

 

Error 2:

Configuration and requires from Service Bus 1.1 to Service Bus 1.1 with TLS 1.2 support

 

Solution:

a.       Manually edited SQL database WFManagementDB and SBManagementDB Store. Nodes table to remove the node. After rejoin.

1.       This issue occurs because of the Workflow Resource Management Store version value at [WFResourceManagementDB].[dbo].[StoreVersionTable] is still 1.0.2.0 despite you have installed CU3 which should work with Workflow Resource Management Store version 1.3.0.0.

2.       To resolve this issue you will need to make the two versions identical at [WFResourceManagementDB].[dbo].[StoreVersionTable] and wfServerUpgradePolicy.config to be 1.3.0.0 as the following :

1. Go to C:\Program Files\Workflow Manager\1.0\Workflow

2. Open wfServerUpgradePolicy.config and make sure that <wfupgrade targetVersion="1.3.0.0">

3. Copy below two files from the Workflow Manager server  C:\Program Files\Workflow Manager\1.0\Workflow

WorkflowServiceInstanceManagementDBUpgradeScript.sql

WorkflowServiceResourceManagementDBUpgradeScript.sql

4.       Paste in to SQL server desktop or C drive.

5.       IF SQL and workflow manager are configured on same server then no need to copy to anywhere

6. Double-click on these files, and It will open in SSMS (SQL server management studio).

7.       Run the following two script

WorkflowServiceInstanceManagementDBUpgradeScript.sql

WorkflowServiceResourceManagementDBUpgradeScript.sql 

                        

 

8.      Now the Workflow Resource Management Store version value is at [WFResourceManagementDB].[dbo].[StoreVersionTable] should be 1.3.0.0, and the workflow manager backend should be started.

9.       Start workflow manager and service bus using the below commands.

10.   To start the workflow manager services execution run the below command in workflow manager PowerShell with Run as administrator

Start-WFHost

11.   To start the Service Bus execution run the below command in workflow manager PowerShell with Run as administrator

 Start-SBFarm 

Error 3:

While configuring the Workflow Manager 9002 port is blocked and unable to proceed with further configuration.