...
...
Targeted Environment
- MTOA-INT, MTOA-TEST
myTCAccount documentation now available through TC confluence : https://tcmarin.atlassian.net/wiki/spaces/MA
PBI #8306 - Email Notifications Active Monitoring Solution Analysis
Implemented new feature to monitor unsent email and send notification if needed. The API will send out a slack notification if unsent emails are detected.
PBI #8280 - MTAPI - Email Notification Enhancements
Enhanced the Email Notification functionality to ensure the email notification is logged in the MTOA database before it is sent to the user.
Added new column to track the failure reasons for not being able to send an email notification
New feature to monitor unsent emails and tries to send them again.
Enhanced the api API result to include the reason for not being able to send an email
Added service request validation before sending an email
Made an architectural changes to enable logging of the verification emails in MTOA database by adding association to the userid userId instead of service request.
PBI #8375 - Service Request Details - Implement Support for Requestor Organization (CRSM)
Implemented Support for Requestor Organization. Add RequesterOrganizationId property property in BaseServiceRequest class
Enhanced the MTOA logging feature to include support for French/special characters
PBI #8318 - Implement Support for Cargo Regulated Entities (CRSM)
New GET /api/v1/regulated-entities to retrieve a collection regulated entity ids for a specified service request.
New POST /api/v1/regulated-entities to add a collection regulated entity ids for a specified service request.
New PUT /api/v1/regulated-entities to update a collection regulated entity ids for a specified service request.
New GET /api/v1/services/{id}/regulated-entities - Gets a list of ids for a specified regulated entity based on a service id and regulated entity provided.
PBI #8517 - Improve Support for Encrypted MTOA Credentials in Production
Enforce the usage of encrypted MTOA API credentials in Prod. We allowed the use of "DisableApiJwtKeysEncryption" application setting for iZEV (only available in the Regular .NET MTOA Framework).
Added encryption support in the MTOA Web Services Client (MTAPI Client). Add new application settings flag AlwaysUseEncryptedApiJwtKeys to say if the encryption is required.
Added decryption support in the MTOA .NET Core Framework
BUG #8095 - Internal users should be prevented from being associated with organizations
BUG #8335 - service request filtering needs to be enhanced to filter updated dates and time with service request id's
BUG #6823 - POST /api/v1/notifications returns inconsistent results (emails not always sent)
BUG #8498 - ZEV ACC - Not able to retrieve organization Ids in GET /api/v1/organizations when email not provided
BUG #8202 - GET /api/v1/provinces/{code} & /api/v1/countrySubdivisions/{code} - correct status code and error message
BUG #8513 - GET /api/v1/regulated-entities - should return 403 when retrieving RE for a RTMR SR using SVMMS key
BUG #8510 - PUT /api/v1/regulated-entities - should throw an error when updating a RE not existing
...
BUG #8473 - A Prod issue updating an external email address
BUG #8468 Post and Put service requests can't be created when a newly created OrganizationId number is used.
BUG #8464 Swagger post /api/v2/servicerequests will not work with the example values
BUG #8461 SourceId is incorrectly returned with a Get after a Post
BUG #8370 - Get /api/v1/servicrequests excludeMetadata returns SR's with meta data
BUG #7948 - GET /organizations/{id}/users doesn't return internal users bound to that org
BUG #7947 - GET /services/{id}/organizations and GET /users/{id}/organizations only retrieve one org per user (Is this fixed ?)BUG #8241 - GET /api/v1/services/invites - received an object with a wrong type
MTOA NuGet packages Release Notes
Version 0.15.16-dev (2020-12-15) (based on the dev branch)
PBI #8375 - Service Request Details - Implement Support for Requestor Organization (CRSM)
PBI #8517 - Improve Support for Encrypted MTOA Credentials in Production
PBI #8318 - Implement Support for Cargo Regulated Entities (CRSM)
PBI #8306 - MTAPI - Email Notifications Active Monitoring Solution Analysis
Breaking change
N/A
MTOA Database – Release Note for Version (
...
v1.11.0
...
)
Schema Structure Changes
Type | Name | Comments | |
New Objects | |||
PBI: 8318 | |||
Table | TC223TC225_SERVICEREGULATED_STANDARDENTITY_CATEGORYstores standard category used by CRSM to calculate service performanceTYPE | Part of changes for regulated entities. | |
Table | TC224_DELIVERY_CHANNEL | stores delivery channel used by CRSM support to provide statistics for CRSM | |
Table | TC016_CANADIAN_PROVINCE | A copy of CORE table which is a subset of TC006_COUNTRY_SUBDIVISION | |
Modified Objects | |||
Table | AC207_SERVICE_REQUEST_STATUS | · New column SERVICE_STANDARD_CATEGORY_CD with FK to TC223 | |
Table | YY201_SERVICE_REQUEST | · New column DELIVERY_CHANNEL_CD with FK to TC224 · New column PLACE_OF_SUPPLY_CD with FK to TC016 · Renamed column SERVICE_FEE_ID to SERVICE_ATTRIBUTE_IDTC226_REGULATED_ENTITY_ID_TYPE | Part of changes for regulated entities. |
Table | TC227_SERVICE_REGULATED_ENTITY_ID_TYPE | Part of changes for regulated entities. | |
Table | YY213_SVC_REQUEST_REGULATED_ENTITY_VALUE | Part of changes for regulated entities. | |
|
|
| |
Modified Objects | |||
PBI: 8030 | |||
Table | WC203_WEB_API_LOG | Adding the following columns: MACHINE_NAME_TXT MTAPI_VERSION_TXT MTOA_CORRELATION_ID_TXT MTOA_USER_SESSION_ID_TXT START_TIME END_TIME | |
PBI: 8306 | |||
Table | YY206_NOTIFICATION | Adding column ERROR_MESSAGE_TXT Making SERVICE_REQUEST_ID Nullable. Adding column STAKEHOLDER_ID Adding constraint YY206_AC040_FK and YY206_SR_OR_USER_CK
| |
PBI: 8375 | |||
Table | YY201_SERVICE_REQUEST | Adding column REQUESTER_ORGANIZATION_ID and constraint YY201_AC043_FK | |
Dropped Objects | |||
n/a |
Data Changes
Service | Label | Comment | |
Table TC205_PERMISSION, TC206_SERVICE_PERMISSION | |||
All Services | Refer to table content | Permissions allocated to services to support Admin Console 1.1 |
|
Table TC204_SERVICE | |||
n/a |
|
| |
Table TC222_SERVICE_SETTING | |||
n/a |
|
|
Data Dictionary detailed information available: RDIMS-#15682999-V1-MTOA_DATABASE_SCHEMA_VERSION