Cora SeQuence 8.4.9 Release Notes

16 July 2018

This is an update for Cora SeQuence v8.4, which includes a fix for the issues detailed below.

Resolved Issues

• Performance issues with the Team Members task list.

Resolution: Changed execution of the following stored procedures: 

• spHotOpsViews_AssignedDynamicTasksByTeamMember (Team member grid)
• spHotOpsViews_AssignedDynamicTasksByTeamMemberColumnValues (Team member grid stages column)
• spHotOpsViews_AssignedDynamicTasksByTeamMemberByTeam (Work assignment team buckets)

• Local variable table primary key was dropped when editing workflow variables.

Resolution: Fixed code logic for editing variables in a workflow with several versions.

Update Steps

Updating from v8.4.8.

1. Download the ZIP file.
2. Back up the Cora SeQuence database. 
3. Open the DB Scripts folder, and run thePatchSynchronization_Data.sqlscript  on your Cora SeQuence database.
4. Run IISReset. 
5. Back up thePNMsoft.Sequence.dllfrom the GAC.
6. Make sure that the following files and folders are in the same level on the server.
   • Engine
   • SequencePatch.xml
   • SequencePatcher.ps1
7. RunSequencePatcher.ps1file as Administrator on all Cora SeQuence servers.
   1. Right clickSequencePatcher.ps1, and then select Run with PowerShell. 
8. Run IISReset for the change to take effect. 

Rollback Steps (in case of failure)

1. Restore the Cora SeQuence database to previous state.
2. Return the backed-upPNMsoft.Sequence.dll.