A supported cumulative update package is now available from Microsoft. This cumulative update is available for download in the "Download information" section.
Updates that are included in this cumulative update package
- Workflow Manager 1.0 Cumulative Update 5 (Update)
This cumulative update contains several software updates. This is an update MSI that can be installed on
- A computer with Workflow Manager 1.0
- A computer with Workflow Manager 1.0 CU1
- A computer with Workflow Manager 1.0 CU2
- A computer with Workflow Manager 1.0 CU3
- A computer with Workflow Manager 1.0 CU4
For customers who have new deployments, Workflow Manager 1.0 Refresh CU2 (Web Platform Installer) and Workflow Manager 1.0 CU5 can be installed before configuring the farm. It works with Service Bus 1.1 or Service Bus 1.0 Cumulative Update 1.
For customer who are updating, users must install Workflow Manager Client 1.0 Client with Cumulative Update 4 (Full install) to update client before installing this CU5 update that will update the server only and the Workflow Manager databases.lative update package information
Download information
The following files are available for download from the Microsoft Download Center:
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
Prerequisites for Workflow Manager 1.0 CU5
Software requirements
• Workflow Manager Client 1.0 CU4 must be installed on the computer.
• Workflow Manager 1.0 RTM, CU1, CU2, CU3 or CU4 must be installed on the computer.
• PowerShell 3.0 must be installed on the computer to be updated. PowerShell 3.0 is included in the Windows Management Framework 3.0 installation. Go to Windows Management Framework 3.0 to install this update.
• SQL Server 2012 Service Pack 4, SQL Server 2014 Service Pack 3, SQL Server 2016 or SQL Server 2017 must be installed if used in combination with SharePoint.
• SQL Server 2012 Service Pack 4 must be installed if used outside of SharePoint.
• For computers that have Workflow Manager 1.0 installed, either of the following additional requirements must be met:
• The Service Bus 1.0 for Windows Server with cumulative update 2799752 must be installed on the whole computer farm before you install the cumulative update for Workflow Manager 1.0 or
• Service Bus 1.1 for Windows Server must be installed on the computer or
• Service Bus 1.1 with TLS 1.2 Support for Windows Server must be installed on the computer to support the new feature TLS protocol versions 1.1 and 1.2.
SQL version
If you are using later version of SQL server than SQL Server 2014, for example: SQL Server 2016, then you must change the compatibility model of the databases to version 120. This is due to compatibility with datetime2 date type conversion. You can change compatibility level with below commands. In case you have custom database names you need to change to your specific database names.
SELECT name, compatibility_level FROM sys.databases;
GO
USE [Master];
GO
ALTER DATABASE [WFInstanceManagementDB] SET COMPATIBILITY_LEVEL = 120;
GO
ALTER DATABASE [WFManagementDB] SET COMPATIBILITY_LEVEL = 120;
GO
ALTER DATABASE [WFResourceManagementDB] SET COMPATIBILITY_LEVEL = 120;
GO
ALTER DATABASE [SbGatewayDatabase] SET COMPATIBILITY_LEVEL = 120;
GO
ALTER DATABASE [SbManagementDB] SET COMPATIBILITY_LEVEL = 120;
GO
ALTER DATABASE [SBMessageContainer01] SET COMPATIBILITY_LEVEL = 120;
GO
SELECT name, compatibility_level FROM sys.databases;
GO
Please see here for more information on database compatibility:
SQL Always On Availability Group
- Supported Availability Mode is Synchronous-commit mode.
Supported operating systems
- Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016 Standard or Datacenter and Windows Server 2019 Standard or Datacenter.
- Workflow Manager Client 1.0 can also be independently installed on the x86 and x64 versions of Windows 7 and above.
Credential requirements
Before you run the executable, you must have administrative credentials on the computer where you are installing the software. See the Workflow Manager documentation for more information.
Deployment
For each computer that uses a Workflow Manager host in a computer farm, this update must be installed on that computer.
Database changes
There are some minimal database changes that will occur when this cumulative update is installed. If you decide to uninstall this update, these database changes are backward-compatible and will not be rolled back.
Restart requirement
You may have to restart the computer after you apply this cumulative update.