Skip to main content
Skip table of contents

Upgrade notes

Schema changes for 24.05

Schema-level changes

New tables

  • NJUSERSYNC

Renamed tables

No tables have been renamed.

Dropped and recreated tables

  • NJUser

Removed tables

No tables were removed.

Table-level changes

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
NJEntity



Entity.OK_Deceased


NJEntity



Entity.OK_CntWksp


NJEntityXAudit



EntityXAudit.OK_EditTime


NJActXAudit





ActXAudit.OK_EditTime

Environment file changes for 24.05

New properties have been added for enhanced Keycloak support:

  • keycloak.adminPassword
  • keycloak.adminUser
  • keycloak.defaultNewPassword

Data source connections

No changes to the data sources were made in the release.

Channel connections

No channel connection changes were made in the release.

Mixins

No new mixins were added.

Schema changes for 24.02

Schema-level changes

New tables

No new tables have been created.

Renamed tables

No tables have been renamed.

Dropped and recreated tables

No tables need to be dropped and recreated.

Removed tables

No tables were removed.

Table-level changes

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
NJEntity



Entity.OK_HousewLock

Entity.FK_House

NJProcess



Process.OK_name


Environment file changes for 24.02

No environment file changes were made in the release.

Data source connections

No changes to the data sources were made in the release.

Channel connections

No channel connection changes were made in the release.

Mixins

No new mixins were added.

Schema changes for 23.11

Schema-level changes

New tables

No new tables have been created.

Renamed tables

No tables have been renamed.

Dropped and recreated tables

No tables need to be dropped and recreated.

Removed tables

No tables were removed.

Table-level changes

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
NJUserGroupsystem






NJUserGroupcustomized






Environment file changes for 23.11

  • doNotContactEnabled (This property must always be set to false. If it does not exist in your environment file, it must be added to it and then set to false.)

Data source connections

No changes to the data sources were made in the release.

Channel connections


No channel connection changes were made in the release.


Mixins


No new mixins were added.


Schema changes for 23.08

Schema-level changes

New tables

No new tables have been created.

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

There are no tables affected by DML Upgrade SQL scripts.

Table-level changes:

There are no table-level changes.

Environment file changes for 23.08

The following flags have been added to the environment file for this release.

  • doNotContactEnabled
    • This property must always be set to false.

Data source connections

No changes to the data sources were made in the release.

Channel connections

No channel connection changes were made in the release.

Mixins

No new mixins were added.

Schema changes for 23.05

Schema-level changes

New tables

  • NJLeadEntityStatus

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

  • RPTReportSettings

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
NJLeadEntityStatus





LeadEntityStatus.FK_Entity
NJLeadEntityStatus





LeadEntityStatus.FK_Lead
RPTReportSettingsshowAllAssociationResults






RPTReportSettingscsvIncludeCurrencySymbol






RPTFilterunit






Environment file changes for 23.05

No environment file changes were made in the release.

Data source connections:

No changes to the data sources were made in the release.

Channel connections:

No channel connection changes were made in the release.

Mixins:

No new mixins were added.

Schema changes for 23.02

Schema-level changes

New tables

  • NJIBM_IAMToken

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

  • OQObjectQueue

Table-level changes:

There are no table-level changes.

Environment file changes for 23.02

The following flags have been added to the environment file for this release.

  • biSyncEnabled
  •  attachment.storage.mode
    • Valid values are "FPA", "DAV" and "S3".
    • If this property is not set in a properties file, the default storage for attachment is the database
  • ibm.cloud.storage.apiBucketName

  • ibm.cloud.storage.apiEndPoint

  • ibm.cloud.storage.apiKey

Data source connections:

No changes to the data sources were made in the release.

Channel connections:

  • ibm:IAMTokenChannel

Mixins:

No new mixins were added.

Schema changes for 22.11

Schema-level changes

New tables

  • QueuedProcessSR
  • QueuedProcessCP
  • RPTFilterXParent

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

There are no tables affected by DML Upgrade SQL scripts.

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
ServiceLevelsystem






ServiceLevelcustomized






TouchTypesystem






TouchTypecustomized






Intervalsystem






Intervalcustomized






TierServiceLevelsystem






TierServiceLevelcustomized






SLTouchTypeIntsystem






SLTouchTypeIntcustomized






TouchTypeIntervalsystem






TouchTypeIntervalcustomized






RPTFilterisGroup






RPTReportadvancedFilterExpression






NJEntity
rpt_fullName





NJLead
rpt_fullName





Environment file changes for 22.11

No environment file changes were made in the release.

Data source connections:

No changes to the data sources were made in the release.

Channel connections:

No channel connection changes were made in the release.

Mixins:

No new mixins were added.

Schema changes for 22.09

Schema-level changes

New tables

  • NJQueuedProcessSR
  • NJQueuedProcessCP

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

There are no tables affected by DML Upgrade SQL scripts.

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
RPTFilterlogicalOperator






RPTFilterordinal






RPTFilternotOperator






RPTReportisUnlisted






RPTReportSettingscurrency






RPTScheduledReportserializedError






Environment file changes for 22.09

No environment file changes were made in the release.

Data source connections:

No changes to the data sources were made in the release.

Channel connections:

No channel connection changes were made in the release.

Mixins:

No new mixins were added.

Schema changes for 22.06

Schema-level changes

New tables

No new tables were provided.

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

There are no tables affected by DML Upgrade SQL scripts.

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
ImportProcess
name





Environment file changes for 22.06

No new flags were added to the environment file.

Data source connections:

No changes to the data sources were made in the release.

Channel connections:

No channel connection changes were made in the release.

Mixins:

AddedRemovedUpdated minimum version


nexj:ui:engage (0.14.0)

Schema changes for 22.04

Schema-level changes

New tables

  • NJIdentification
  • RPTReportSettings

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

There are no tables affected by DML Upgrade SQL scripts.

Table-level changes:

There are no table-level changes.

Environment file changes for 22.04

No environment file changes were made in the release.

Data source connections:

No changes to the data sources were made in the release.

Channel connections:

No channel connection changes were made in the release.

Mixins:

No new mixins were added.

Schema changes for 22.03

Schema-level changes

New tables

No new tables were provided.

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

  • NJCmpgnParticipationStatus

Existing tables affected by DML Upgrade SQL scripts

  • NJEnumCode
  • NJEnumDisplay
  • NJSystemPreference

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
IFInterest
relatedObjectId





IFSentArticle
relatedObjectId





RPTScheduledReportendTime






CFWFActionassgnModelId


CPWFAction.FK_AssgnModel


CPWFActionassgnModelRoleId


CPWFAction.FK_AssgnModelRole


CPWTActionassgnModelId


CPWTAction.FK_AssgnModel


CPWTActionassgnModelRoleId


CPWTAction.FK_AssgnModelRole


Environment file changes for 22.03

The following flags were added to the Environment file:

Data source connections:

No changes to the data sources were made in the release.

Channel connections:

No channel connection changes were made in the release.

Mixins:

No new mixins were added.

Schema changes for 22.01

Schema-level changes

New tables

No new tables were provided.

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

  • NJSampleData

Existing tables affected by DML Upgrade SQL scripts

  • NJCPWFTemplate
  • NJCPWorkflow

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
NJCPWFTemplateplanningStatus


CPWFTemplate.EK_PlanStatus


NJCPWFTemplateprogressedStatus


CPWFTemplate.EK_ProgStatus


NJCPWorkflowplanningStatus


CPWorkflow.EK_PlanStatus


NJCPWorkflow

progressedStatus


CPWorkflow.EK_ProgStatus


Environment file changes for 22.01

No environment file changes were made in the release.

Data source connections:

No changes to the data sources were made in the release.

Channel connections:

No channel connection changes were made in the release.

Mixins:

No new mixins were added.

Schema changes for 21.12

Schema-level changes

New tables

  • NJSampleData
  • NJCPWTAction
  • NJCPWTAUser
  • NJCPWTATMRole
  • NJCPWTActText
  • IFLOCKING
  • IFTenant
  • IFSubscription
  • IFFeed
  • IFArticle
  • IFArticleXContent
  • IFTag
  • IFArticleTag
  • IFPublisher

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

  • NJCPWFTemplate
  • NJActTemplate
  • NJEnumCode
  • NJEnumDisplay
  • NJEnumType
  • NJEnumTypeDisplay
  • IFInterest

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
NJAsgnModelRole



AsgnModelRole.AK1


NJCPWorkflowisTemplateUpdated






NJCampaign






Campaign.FK_Type
NJCampaign






Campaign.FK_Region
NJCampaign


typeCode



NJCampaign


regionCode



IFInterestlocking






IFInterest



Interest.AK


IFInteresttype






IFSentArticlelocking






Environment file changes for 21.12

The following flags were added to the Environment file:

Data source connections:

Added:

  • inform:DB

Removed:

  • inform:Inform

Channel connections:

The following connections were added and removed:

AddedRemoved
inform:article:search HTTPConnectioninform:ArticleSearch HTTPConnection
inform:article:view HTTPConnection
inform:advstrm:article HTTPConnection
inform:gv6:Article HTTPConnection

Mixins:

The linter mixin is required to be explicitly set in the environment file for applicable clients.



Schema changes for 9.8

Schema-level changes

New tables

  • NJCampaignTeamMember
  • NJCPWFTemplate
  • NJCPWTPStatusLink
  • NJCPWTPStatus
  • NJCPWFStatusLink
  • NJCPWFStatus
  • NJCPWorkflow
  • NJCPWFAction
  • NJCPWFActText
  • NJCPWFATMRole
  • NJCPWFAUser
  • NJEntityXLead
  • NJCPPartTimer
  • NJCPWFADoc
  • NJLoggingConfig

  • NJNodeXLogging

  • NJNodeLogRemoval

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

  • NJImportProcessStage
  • NJFilter
  • NJActTemplate
  • NJUserGroupPrivilegeLink
  • NJCampaignTeamMember
  • NJCPWTPStatusLink
  • NJCPWTPStatus
  • NJCPWFTemplate
  • NJSystemPreference
  • NJUserGroupLink
  • NJEntity
  • NJUserPerson
  • NJUser
  • NJPrincipal
  • NJLocalUser
  • NJUserBase
  • NJTypeLocalization
  • NJAct
  • NJTaskEntity

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
NJFilter





Filter.OK1
NJCampaignParticipationstatus






NJCampaignParticipationstatusUpdateTime






NJCampaignstageCode






NJCampaign



Campaign.FK_Stage


NJActX01





ActX01.FK_Folder
NJLeadexpiryDate






NJCPWFActionassignedUserId






NJCPWFAction



CPWFAction.FK_AssignedUser


NJEntitydoNotContactFlag






NJCPWFActionemailFrom






NJCPWTPStatus





CPWTPStatus.AK

Environment file changes for 9.8


Upgrading to NexJ CRM version 24.05


Data source connections:

No data source connections were added or removed.

Channel connections:

No channel connections were added or removed.

Mixins:


Upgrading to NexJ CRM version 24.05


Schema changes for 9.6

Schema-level changes

New tables

No new tables were provided.

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

  • NJExchangeServer

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
RPTExecutedReport (for Reporting only)isScheduled






RPTReport (for Reporting only)subjectAreaCaption






RPTScheduledReport (for Reporting only)classCode






RPTExecutedFiles (for Reporting only)isScheduled






OpportunityStageTemplateactive






NJExchangeServermaxErrorCount






Environment file changes for 9.6

No new flags were added to the environment file.

Data source connections:

No data source connections were added or removed.

Channel connections:

No channel connections were added or removed.

Mixins:

AddedRemovedUpdated minimum version


nexj:model:afl


nexj:model:afl-mda


nexj:model:portal


nexj:model:highcharts

Schema changes for 9.4

Schema-level changes

New tables

  • NJAccountPlan
  • NJAccountPlanXOverview
  • NJAccountPlanEntity
  • NJAccountPlanOpportunity
  • NJAttachmentXAccountPlan
  • NJAccountPlanCov
  • NJRisk
  • NJCompetitor
  • IFInterest
  • IFVersion

Renamed tables

No tables have been renamed.

Dropped & recreated tables

No tables need to be dropped & recreated.

Removed tables

No tables were removed.

Existing tables affected by DML Upgrade SQL scripts

  • NJUserField
  • NJEnumDisplay
  • NJEnumCode

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
NJUserFielduserFieldTypeId


UserField.FK_Type


NJActaccountPlanId


Act.FK_AccountPlan


NJActaccountPlanModified






NJActSeriesaccountPlanId


ActSeries.FK_AccountPlan


NJActSeriesaccountPlanModified






Environment file changes for 9.4

  • The following flags were added to the Environment file:
    • rest.configMetadata
    • rest.schemaBase
    • rest.version
    • rest.defaultPageSize
  • Removed SQLHook "nexj.core.persistence.sql.ObjectQueueHook" from the Environment file and moved it to ObjectQueueDatabase.datasource

Data source connections:

AddedRemoved
inform:Inform RelationalDatabaseConnection

Channel connections:

AddedRemoved
inform:ArticleSearch HTTPConnection
rest:OpenAPI HTTPConnection
rest:REST HTTPConnection
rest:SelectionOptions HTTPConnection
inform:RelatedObject HTTPConnection

Mixins:

AddedRemovedUpdated minimum version
nexj:model:restapi

nexj:model:inform



nexj:model:afl


nexj:model:afl-mda


nexj:model:portal
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.