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:
- Download the files
- Backup your Sequence database.
- Run the PatchSynchronization.sql and PatchSynchronization_Data.sql scripts from the DB Scripts on your 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 (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.
