Migration notes
This page explains the changes required to migrate to the stated version of the Sign-Off Module.
Migrate to 3.0.0
Upgrading from version 2.3.0.
The Sign-Off Module is using ActivePivot 5.9.6 together with ActiveUI 4.3.13. For new features and fixes included in these releases, please see the ActiveUI documentation and ActiveUI Migration Notes, and the release notes for ActivePivot.
Configuration files
Modified
application.yml
| Modification | Property | Description |
|---|---|---|
| Removed | application.rest-api.url | |
| Removed | application.rest-api.user | |
| Removed | application.rest-api.password | |
| Added | application.rest-api.MRA.url | URL of the RESTful server used for operations on the signed-off data in the ActivePivot application where those data are present (MRA) |
| Added | application.rest-api.MRA.user | User id used to send requests on the RESTful service (MRA) |
| Added | application.rest-api.MRA.password | Password used to send requests on the RESTful service (MRA) |
| Added | application.rest-api.FRTB.url | URL of the RESTful server used for operations on the signed-off data in the ActivePivot application where those data are present (FRTB - placeholder for now) |
| Added | application.rest-api.FRTB.user | User id used to send requests on the RESTful service (FRTB - placeholder for now) |
| Added | application.rest-api.FRTB.password | Password used to send requests on the RESTful service (FRTB - placeholder for now) |
Databases
Added
A table has been added to the Audit log database for adjustment objects.
| Table | Details |
|---|---|
| ADJUSTMENTREQUESTENTITY | Table that contains the audit information for adjustments |
Description of ADJUSTMENTREQUESTENTITY table
| Column | Type | Description |
|---|---|---|
| KEY | VARCHAR | Key of the record |
| TIMESTAMP | TIMESTAMP | Timestamp at which the record was created |
| COMMENT | VARCHAR | Comment associated to the adjustment request |
| OBJECT | CLOB | JSON representation of the audited object |
| PROCESSINSTANCEID | VARCHAR | The process instance id to which the audit record is associated (set to "N/A" in this version of the Sign-Off Module) |
| STATUS | VARCHAR | The status of the audited entry |
| TYPE | VARCHAR | The String representing the Java class of the audit entry. For this table, the type is: "com.activeviam.signoff.core.model.adjustment.dto.AuditableAdjustmentRequestDTO" |
| USER | VARCHAR | The user performing the audited action |
| ACTION | VARCHAR | The action performed by the user |
| ADJUSTMENTKEY | VARCHAR | The string representing the adjustment key |
Modified
In order to support multiple application servers, a server name field has been added to tables in the Application database.
| Modification | Table | Column | Type | Description |
|---|---|---|---|---|
| Added | PROCESSDEFINITION | SERVERNAME | String | The name of the server for which the definition was created - required for multi-server support |
| Added | PROCESSINSTANCE | SERVERNAME | String | The name of the server for which the definition was created - required for multi-server support |
Datastore
In order to support multiple application servers, a server name field has been added to the datastore.
Modified
| Modification | Store | Field | Type | Description |
|---|---|---|---|---|
| Added | SignOffProcessDefinition | serverName | String | The name of the server for which the definition was created - required for multi-server support |
Cube schema
Added
| Cube | Level | Details |
|---|---|---|
| SignOffProcessDefinitionCube | serverName | The name of the server for which the definition was created - required for multi-server support |
Other changes
The method datastoreService() has been renamed cacheService() in classes AKeyedObjectWorkflowService and ABitemporalObjectWorkflowService.