Upgrade notes
Refer to the notes below for additional warnings and suggestions to consider during an upgrade.
For detailed upgrade instructions, see Upgrading to NexJ CRM version 8.9.
Important
If you are upgrading from an earlier version of NexJ CRM 8.x and if you are using a Scheme script to recreate notifications, ensure that the script does not change the OIDs of existing notifications. Otherwise, notification functionality related to OIDs, such as time-based notifications and notification subscriptions, may not function as expected. Consider rewriting the script to update rather than recreate existing notifications.
Schema changes for 8.9
Schema-Level Changes:
New tables
- NJBISyncTargetLock
- NJCUDNotificationActionX01
- NJEM2SREmailBlacklist
- NJEM2SRRestriction
- NJEntityListExt
- NJPinnedDocument
- NJSRMailbox
Renamed tables
- NJEntityList→NJFilter
- NJEntityListACL→NJFilterACL
- NJEntityListFilter→NJDynamicFilter
- NJEntityListMember→NJListMember
- NJEntityListPrincipal→NJFilterPrincipal
- NJFavouriteEntityList→NJFavoriteFilter
- NJFilter→NJFilterClassic
Dropped & recreated tables
- NJStat
Removed tables
- NJBILinkOutStatus
- NJBITargetStatusLock
Existing tables affected by DML Upgrade SQL scripts
- NJActTemplate
- NJBIAttribute
- NJBIAttributeAssoc
- NJEntityList→NJFilter
- NJEntityTypeCFTypeGroup
- NJFavouriteEntityList
- NJOpportunityTemplate
- RTRule
- RTRuleSet
- RTRuleSetText
- RTRuleSetX01
Table-Level Changes:
| Modified Table | New Column | Modified Column | Renamed Column | Removed Column | New Index | Renamed Index | Dropped & Recreated Index | Removed Index |
| BPFlow | approvalObjectId | isSubmitted | ||||||
| BPFlow | statusCode | Flow.FK_Status | ||||||
| BPFlowTemplate | bind | FlowTemplate.AK1 | ||||||
| NJAct | bpFlowId | Act.FK_BPFlow | ||||||
| NJActTemplate | bpFlowTemplateId | ActTemplate.FK_BPFlow | ||||||
| NJActTemplate | bpFlowTemplateEditId | ActTemplate.FK_BPFlowEdit | ||||||
| NJEntityList->NJFilter | subject | ownerId | entitySearchContext | Filter.FK_Subject | EntityList.PK->Filter.PK | EntityList.FK_Owner | ||
| NJEntityList->NJFilter | EntityList.OK1->Filter.OK1 | |||||||
| NJEntityList->NJFilter | EntityList.FK_Owner->Filter.FK_Owner | |||||||
| NJEntityList->NJFilter | EntityList.FK_SC->Filter.FK_SC | |||||||
| NJEntityList->NJFilter | EntityList.FK_CU->Filter.FK_CU | |||||||
| NJEntityList->NJFilter | EntityList.FK_EU->Filter.FK_EU | |||||||
| NJEntityListACL->NJFilterACL | EntityListACL.PK->FilterACL.PK | |||||||
| NJEntityListACL->NJFilterACL | EntityListACL.FK_O->FilterACL.FK_O | |||||||
| NJEntityListACL->NJFilterACL | EntityListACL.FK_P->FilterACL.FK_P | |||||||
| NJEntityListFilter->NJDynamicFilter | subject | EntityListFilter.PK->DynamicFilter.PK | ||||||
| NJEntityListMember->NJListMember | entityListId->listId | ListMember.AK1 | EntityListMember.PK->ListMember.PK | EntityListMember.AK1 | ||||
| NJEntityListMember->NJListMember | entityId->objectId | ListMember.FK_Object | EntityListMember.FK_CU->ListMember.FK_CU | EntityListMember.FK_entity | ||||
| NJEntityListMember->NJListMember | ListMember.FK_List | EntityListMember.FK_EU->ListMember.FK_EU | EntityListMember.FK_list | |||||
| NJEntityListPrincipal->NJFilterPrincipal | entityListId->filterId | FilterPrincipal.AK1 | EntityListPrincipal.PK->FilterPrincipal.PK | EntityListPrincipal.AK1 | ||||
| NJEntityListPrincipal->NJFilterPrincipal | FilterPrincipal.FK_F | EntityListPrincipal.FK_P->FilterPrincipal.FK_P | EntityListPrincipal.FK_EL | |||||
| NJEntityListPrincipal->NJFilterPrincipal | EntityListPrincipal.FK_CU->FilterPrincipal.FK_CU | |||||||
| NJEntityListPrincipal->NJFilterPrincipal | EntityListPrincipal.FK_EU->FilterPrincipal.FK_EU | |||||||
| NJFavouriteEntityList->NJFavoriteFilter | entityListId->filterId | FavoriteFilter.AK1 | FavouriteEntityList.PK->FavoriteFilter.PK | FavouriteEntityList.AK1 | ||||
| NJFavouriteEntityList->NJFavoriteFilter | FavoriteFilter.FK_F | FavouriteEntityList.FK_U->FavoriteFilter.FK_U | FavouriteEntityList.FK_EL | |||||
| NJFavouriteEntityList->NJFavoriteFilter | FavouriteEntityList.FK_CU->FavoriteFilter.FK_CU | |||||||
| NJFavouriteEntityList->NJFavoriteFilter | FavouriteEntityList.FK_EU->FavoriteFilter.FK_EU | |||||||
| NJFilter->NJFilterClassic | Filter.PK->FilterClassic.PK | |||||||
| NJFilter->NJFilterClassic | Filter.FK_FRSubjectArea->FilterClassic.FK_FRSubject | |||||||
| NJFilter->NJFilterClassic | Filter.FK_sCrtUsr->FilterClassic.FK_sCrtUser | |||||||
| NJFilter->NJFilterClassic | Filter.FK_sEditUsr->FilterClassic.FK_sEditUsr | |||||||
| NJFilterName->NJFilterClassicName | FilterName.OK->FilterClassicName.OK | |||||||
| NJFilterUserGroup | FilterUserGroup.FK_Filter | |||||||
| NJImportProcess | classCode | |||||||
| NJImportProcessTemplate | typeName | |||||||
| NJIntegrationLog | IntegrationLog.FK_channel | |||||||
| NJServiceRequest | isMergedFlag | |||||||
| NJServiceRequest | mailboxId | ServiceRequest.FK_Mailbox | ||||||
| NJServiceRequest | noEntityEmail | |||||||
| NJServiceRequest | statusCode | primaryEntityId | ServiceRequest.FK_Status | |||||
| NJUserGroup | emailToServiceRequestEnabled | |||||||
| OQObjectQueue | global | |||||||
| RTRuleSetX01 | targetDenorm | RuleSetX01.AK1 | ||||||
| RTScheduledTrigger | operandValue | |||||||
| RTScheduledTrigger | queuedTime |
Environment file changes for 8.9
- Added meta.test flag to Environment (to conditionally load test CPM forms for QA automation)
- Changed url of insights:ArticleSearch & insights:ArticleTrackingURL HTTPConnections
- Updated certificate for ExchangeEWSSender3 (nexj2k13 Exchange) HTTPConnection
Channel Connections:
| Added | Removed |
| EmailToServiceRequest MailConnection | BatchProcessQueue MessageQueueConnection |
| LDAPSyncQueue MessageQueueConnection | |
| ReportSystemQueue MessageQueueConnection | |
| SyncQueue MessageQueueConnection |
Mixins:
| Added | Removed | Updated minimum version |
| nexj:model:afl-mda | nexj:model:cpm | nexj:model:afl |
| nexj:model:libphonenum | nexj:model:finance-mda | nexj:model:ckeditor |
| nexj:model:cpm-demo | ||
| nexj:model:dai:nexjcdc | ||
| nexj:model:finance-md | ||
| nexj:model:highcharts | ||
| nexj:model:portal |