Skip to main content
Skip table of contents

Upgrade notes

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

The legacyLeadsEnabled flag was added to the environment file. For more information about legacyLeadsEnabled, see Upgrading to NexJ CRM version 9.8.

Data source connections:

No data source connections were added or removed.

Channel connections:

No channel connections were added or removed.

Mixins:

The sso mixin is required to be explicitly set in the environment file for applicable clients. For more information, see Upgrading to NexJ CRM version 9.8.

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.5

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

  • NJEnumDisplay

Table-level changes:

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





Act.FK_AccountPlan
NJActSeries





Act.FK_AccountPlan
NJLead (for Reporting only)rpt_fullName 






RPTDashboard (for Reporting only)isPrivate 






Environment file changes for 9.5

Data source connections:

No data source connections were added or removed.

Channel connections:

AddedRemoved

If you are moving to OAuth authentication for Exchange Online, you can configure the ExchangeEWSSender channel.
For more information, see Channel settings for a NexJ CRM deployment with Exchange Online.


rptadapter:ReportingInstanceSender HTTPConnection (for Reporting with replicated database only)
bireport:ReportingInstanceSync (for Reporting with replicated database only)

Mixins:

AddedRemovedUpdated minimum version



nexj:model:afl


nexj:model:afl-mda


nexj:model:portal


nexj:model:ckeditor

nexj:model:rpc

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

Schema changes for 9.3

Schema-level changes

New tables

  • RPTOrderBy (included as of 9.2.2.0)
  • RPTExecutedFiles (included as of 9.2.2.0)
  • RPTEmailTarget (included as of 9.2.2.0)

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

  • NJEnumDisplay
  • NJProcess
  • RPTRecalculate (included as of 9.2.2.0)

Table-level changes:

Modified TableNew ColumnModified ColumnRenamed ColumnRemoved ColumnNew IndexRenamed IndexDropped & Recreated IndexRemoved Index
RPTCalculatedValue (modified as of 9.2.2.0)
field





RPTGroupBy (modified as of 9.2.2.0)
field





RPTDashboardItem (modified as of 9.2.2.0)caption






RPTDashbaordItem (modified as of 9.2.2.0)description






RPTFile (modified as of 9.2.2.0)executedReport


File.FK_ExecReport


RPTFile (modified as of 9.2.2.0)createTime






RPTFile (modified as of 9.2.2.0)executedFiles


File.FK_ExeFile


RPTFile (modified as of 9.2.2.0)
mimeType





RPTFileName (modified as of 9.2.2.0)






FileName.UNIQ
RPTScheduledReport (modified as of 9.2.2.0)executedTime






Environment file changes for 9.3

  • Added theme flag to Environment (to specify UI theme to load).

Channel connections:

AddedRemoved
ExchangeEWSSender6 HTTPConnection

Mixins:

AddedRemovedUpdated minimum version


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.