Cora Knowledge Center

Support

Cora SeQuence 8.4.6 Release Notes

24 MAY 2018

This is an update for Cora SeQuence v8.4.0, which resolves a product issue, detailed below.

Resolved Issues

HotOperations Views Performance  

Resolution: The solution involves Stored Procedures optimization, table schema changes and code changes
Details 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 

Update Steps

Update from 8.4.5:

  1. Download the files
  2. Backup your Sequence database.
  3. Run the PatchSynchronization.sql and PatchSynchronization_Data.sql scripts from the DB Scripts on your 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 (In case of failure)

1. Restore Database to the per patch state 

2. Return the old dll

NOTE: If you are running a Cora SeQuence version earlier than v8.4.5, you must install v8.4.4 before you install v8.4.5.