Cora Knowledge Center

Support

Cora SeQuence 8.5.8 Release Notes

4 June 2018

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

Resolved Issues

HotOperations Views Performance
Resolution: The solution involves Stored Procedures optimization, table schema changes and code changes
List of effected component:
API:
Added InstanceCompleted event to PNMsoft.Sequence.Activity. This event is raised after an activity status is changed to PNMsoft.Sequence.ActivityInstanceStatus.Completed.
Dlls:  

  • PNMsoft.Sequence.HotOperations.dll  
  • PNMsoft.Sequence.HotOperations.data.dll  
  • PNMsoft.Sequence.dll

Database objects:

Type 

Name 

Change Type 

Description 

Table

USLXXXX 

Modified 

the following columns were added,fldTActGuid  , fldCreatedAt ,fldCompletedAt ,fldFetchedById  

Table

tblHotOpsDynamicTaskRoles 

Added 

This table holds the Employee Roles configured for a DynamicTaskActivity. This information is also stored in the fldProperties in the tblTemplateActivities. For performance, the same values are also stored in this table. 

User Defined Table DataType

HotOpsDynamicTaskRoles 

Added 

Used as an argument to the spHotOpsDesign_UpdateDynamicTaskRoles stored procedues (see this document for more details) 

Stored Procedure

spHotOpsDesign_UpdateDynamicTaskRoles 

Added 

Update the tblHotOpsDynamicTaskRoles table with Roles mapping as described above. 

Stored Procedure

spHotOpsRT_AddDynamicTask 

Modified 

Added persistence of ‘fetched by’ to USLXXX_Tasks 

Stored Procedure

spHotOpsRT_FetchDynamicTasks 

Modified 

Updates the fldFetchedBy column in the USLXXX_Tasks table 

Stored Procedure

spHotOpsRT_ReturnDynamicTasks 

Modified 

Updates the fldFetchedBy column in the USLXXX_Tasks table 

Stored Procedure

spHotOpsRT_ReturnDynamicTasksByTeamLeader 

Modified 

Updates the fldFetchedBy column in the USLXXX_Tasks table 

Table

tblSolutionToDynamicTasks 

Added 

Holds a mapping between solutions to workflows to dynamic tasks, in the template level. 

Stored Procedure

spHotOpsViews_AllocatedDynamicTasksByTeamLeader 

Modified 

Optimized SP execution 

Stored Procedure

spHotOpsViews_AssignedDynamicTasksByTeamMember 

Modified 

Optimized SP execution 

Stored Procedure

spHotOpsViews_AssignedDynamicTasksByTea mMemberColumnValu

Modified 

Optimized SP execution 

Stored Procedure

spHotOpsViews_AllocatedDynamicTasksByTea mLeaderColumnValues

Modified 

Optimized SP execution 

Update Steps

Update from v8.5.7:

  1. Download the files
  2. Back up your Cora SeQuence database.
  3. Run the  PatchSynchronization.sql and PatchSynchronization_Data.sql scripts from the DB Scripts folder on your Cora SeQuence database.
  4. Run IISReset.
  5. Make sure the following files and folders are on the same level in the server
    • Engine
    • HotOperations
    • SequencePatch.xml
    • SequencePatcher.ps1
  6. Run the SequencePatcer.ps1 on all Sequence servers. (Right click -> Run with PowerShell)
  7. Press on any key to run as Administrator
  8. Run IISReset for the change to take effect

Rollback Steps

  1. Restore Database to the per patch state
  2. Run IISReset for the change to take effect

NOTE:  If you are running a Sequence version earlier than v8.5.7, you must install v8.5.7 before you install v8.5.8.