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:
- Download the files
- Back up your Cora SeQuence database.
- Run the PatchSynchronization.sql and PatchSynchronization_Data.sql scripts from the DB Scripts folder on your Cora SeQuence database.
- Run IISReset.
- Make sure the following files and folders are on the same level in the server
- Engine
- HotOperations
- SequencePatch.xml
- SequencePatcher.ps1
- Run the SequencePatcer.ps1 on all Sequence servers. (Right click -> Run with PowerShell)
- Press on any key to run as Administrator
- Run IISReset for the change to take effect
Rollback Steps
- Restore Database to the per patch state
- 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.
