ESM Release: Schema Changes and Query Report Handling
ESM Release 11.0 has few tables' schema changes involved. Please refer the modified/removed tables and columns as explained in this post. Also, we have tried our best to run the db queries, written based on old schema, after conversion process.
Any query reports based on the old schema or any new query based on the old table schema will be modified automatically using the new schema and executed in the database.
Errors during the replacement are tracked in the FailedQuery.html file under logs.
All old schema queries successfully tracked are available in the SucceedQuery.html file under logs.
Table Movements:
Deleted | Replaced With |
HelpDeskCrew | PortalTechnician ( Column Name Change: UserID instead of TechnicianID ) |
CrewEscalation | NILL ( Removed & Unused ) |
Requester | UserAdditionalFields and PortalUsers (only ciid column ) |
Technician | UserAdditionalFields and PortalUsers (only ciid column) |
Column movements:
BEFORE ESM | AFTER ESM | ||
Table | Column | Table | Column |
DepartmentDefinition | CIID | PortalDepartments | CIID |
SDUser | AllowedToViewCost | PortalTechnicians | AllowedToViewCost |
SDUser | CostPerHour | PortalUsers | CostPerHour |
SDUser | CIID | PortalUsers | CIID |
People | All common user additional field columns with CIID, was present | UserAdditionalFields | All Columns are moved and renamed. CIID column is retained in People table itself. The mapping details of old column vs new column can be found in UserAdditionalFields.json file under logs directory |
| | | |
| | | |
Column Movements - Not Handled in Queries Conversion:
BEFORE | AFTER | ||
Table | Column | Table | Column |
OutgoingMailAliases | ID | NILL | NILL ( Removed & Unused ) |
PurchaseConfigValue | DISPLAYLOGOINPO | SDOrgDetail | DISPLAYLOGOINPO |
UserDepartment | CIRELATIONSHIPID | CIRELATIONSHIPS | CIRELATIONSHIPID with RELATIONSHIPTEXT value as "USER_DEPARTMENT" |