Cora SeQuence 8.6.2 Release Notes

11 October 2018

This is an update for Cora SeQuence v8.6, which includes product enhancements and resolved issues.

Product enhancements

• Workflows with Built-in Command activities can now run in InMemory mode: InMemory mode provides faster response times and improved performance. It should be used for workflows that don't require saving data to the database.   
• Faster, easier, and more secure sign in with OpenID Connect:  Cora SeQuence now supports  single sign-on authentication with the OpenID Connect protocol. This update requires changes to the Flowtime and Administration web.configfiles.
  For more details, see Configure OpenID Connect authentication.
• Enhanced SQL notification service:  Cora SeQuence components now use a new notification service. The change affects Administration and Flowtimeweb.configfiles and all other application configuration files.
  New tag in the configuration files

<sequence.engine>
      …
      <services>
             …
             <add type="PNMsoft.Sequence.Notifications.Sql.SqlServiceBrokerNotificationServiceFactory, PNMsoft.Sequence.Notifications.Sql, Version=8.0.0.0, Culture=neutral, PublicKeyToken=0a1a1b90c1c5dca1" />

• Cloud support (Preview): Cora SeQuence is expanding its cloud capabilities. You can now install Cora SeQuence over Amazon Elastic Compute Cloud (Amazon EC2) and Amazon Relational Database Service (Amazon RDS) instances. See installation procedure below.

Resolved issues

• Flowtime: Changes made on the Administration > Analytics page were not displayed on Flowtime. (Ticket #56833)
• App Studio: File Writer activity that used tabs as field delimiters displayed differently on Process Lab and Flowtime. (Ticket #56209)
• App Studio: When you used the Split function to set up group or user expressions for task/message recipients, you got this error message: "Expression of type 'GroupView' expected," and could not continue setting up the workflow. (Ticket #55512)

Update steps

Updating from v8.6.1 

1. Back up the Cora SeQuence database. 
2. Copy the JS files under Shared Resources\Components\DataStreams\js to a temporary location.
3. Download the ZIP file, and extract it.
4. Open the DB Scripts folder, and then run these scripts on your Cora SeQuence database in the following order:
   1.  PatchSynchronization.sql
   2.  PatchSynchronization_Data.sql
5. RunSequencePatcher.ps1 file as Administrator on the Cora SeQuence Flowtime and Administration servers.
   1. Right clickSequencePatcher.ps1 , and then select Run with PowerShell.

Rollback steps (in case of failure)

1. Restore the Cora SeQuence database to previous state.
2. Return the JS files.

Install Cora SeQuence on AWS

Before you install Cora SeQuence v8.6.2 on AWS, you need to manually install version 8.6 with modified scripts.

Supported environment

• Windows Server 2016
• RDS with SQL Version 2017
• Single-server topology

Installation steps

The database needs to be installed separately using scripts before you run the installation wizard.

1. Download the V8.6 installation ZIP file, and extract it.
2. Locate the First Installation folder, and open the 1 - CreateDatabase.sql  file.
3. Delete the following lines:

   EXEC dbo.sp_dbcmptlevel @dbname=N'Sequence', @new_cmptlevel=100
   		
   GO

4. Save the file.
5. Resume the database installation, as described here.
6. Run the Cora SeQuence v8.6 installation wizard, and in the Custom Setup screen, remove the Database feature.
7. Finish the installation wizard. 
8. Perform the update steps for v8.6.1.
   See Cora SeQuence 8.6.1 Release Notes.
9. Perform the update steps for v8.6.2 (described above).