Skip to main content
Skip table of contents

Upgrade notes

This section includes the descriptions of schema changes, environment changes, and other information needed for upgrading for most recent releases. For upgrade notes for previous releases, refer to online documentation for version 23.11 at Upgrade notes.

Schema changes for 25.05

Schema-level changes

New tables

  • NJGraphAPIServer

  • NJGraphAPIMailbox

  • NJGraphAPIFolder

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 Table

New Column

Modified Column

Renamed Column

Removed Column

New Index

Renamed Index

Dropped & Recreated Index

Removed Index

NJEntity

addressee

Environment file changes for 25.05

The following properties have been added to the environment file.

  • These two properties are related to a feature that is currently in development. Do not do not set or change any related values.

    • graphAPI.enabled

    • graphBroker.tenantId

Data source connections

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

Channel connections

The following channel has been added to the environment file.

  • GraphAPISender

    • This channel is related to a feature that is currently in development. Do not do not set or change any related values.

Mixins

No new mixins were added to the environment file.

Additional upgrade notes for 25.05

Enabling TLS1.3

  1. Ensure OpenSSL is installed locally.

  2. Acquire Tomcat Native.

  3. Configure environment to use tcnative.

    • (Windows) If tcnative has not been distributed through the plugin, move the tcnative.dll file to a folder accessible to Tomcat, such as within java.library.path.

    • (Linux) Add the link to tcnative to your LD_LIBRARY_PATH:

      CODE 
      export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/apr/lib

  4. Set application properties to use tcnative with TLS1.3.

    • To use only TLS1.3:

      CODE 
      -Dhttps.protocols=TLSv1.3
-Dhttp.connector.SSLProtocol=TLSv1.3
-Dpush.connector.SSLProtocol=TLSv1.3
-Dajp.connector.SSLProtocol=TLSv1.3

    • To use TLSv1.2 and 1.3 simultaneously:

      CODE 
      -Dhttps.protocols=TLSv1.2,TLSv1.3
-Dhttp.connector.SSLProtocol=+TLSv1.2,+TLSv1.3
-Dpush.connector.SSLProtocol=+TLSv1.2,+TLSv1.3
-Dajp.connector.SSLProtocol=+TLSv1.2,+TLSv1.3

  5. To validate that TLS1.3 is enabled, look for log entries similar to the following on startup:

    CODE 
    Loaded Apache Tomcat Native library [2.0.8] using APR version [1.7.4].
APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
OpenSSL successfully initialized [OpenSSL 3.0.14 4 Jun 2024]
Starting ProtocolHandler ["https-openssl-nio-7080"]

If you do not include these properties, the system will fallback to JSSE, which has non-compliant client certificate authentication.

You must use the plus sign (+) in the SSLProtocol properties to ensure the protocol is included. (You can also use the minus sign (-) to explicitly remove a protocol from inclusion. Failing to use the + or - syntax will default to inclusion, and cause warnings in the logs.

Schema changes for 25.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 Table

New Column

Modified Column

Renamed Column

Removed Column

New Index

Renamed Index

Dropped & Recreated Index

Removed Index

NJProcess

Process.OK2

NJLatestActivityAct

LatestActivityAct.AK_StrtTm

Environment file changes for 25.02

No new properties were added to the environment file.

Data source connections

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

Channel connections

The following property has been added to the ExchangeEWSSender7 channel

  • maxSenders

Mixins

No new mixins were added to the environment file.

Additional upgrade notes for 25.02

  • You must update pgAdmin to the latest version, because the lc_collate parameter is not recognized for PostgreSQL 16.

  • The following values must be changed in the environment setup for PostgreSQL:

    • max_prepared_transaction = 1000

    • max_connections = 250

Schema changes for 24.11

Schema-level changes

New tables

  • NJLatestActivityAct

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 Table

New Column

Modified Column

Renamed Column

Removed Column

New Index

Renamed Index

Dropped & Recreated Index

Removed Index

NJEntity

customEntityStatusCode

Entity.OK_Custom

Environment file changes for 24.11

The following properties have been added to the environment file:

  • crm.act.latestActivityPastDays

    • To disable the Latest Activities feature, set the value to 0 (default).

    • When set to a value other than 0, enables the Latest Activities feature and specifies how many days in the past should be displayed. The recommended value is 30 days.

    • This feature is currently only supported in Cloud deployments.

Data source connections

  • dm:StagingImportDatabase

    • Supports the optional Data Migration feature

Channel connections

  • dm:DMFileChannel

    • Supports the optional Data Migration feature. Used to specify the location where the CSV files used for data migration are stored.

  • dm:DMReportChannel

    • Supports the optional Data Migration feature. Used to specify the location where the reports regarding Data Migration results are stored.

Mixins

The following mixin has been added for the optional Data Migration feature:

  • nexj:meta:dm

    • The version required for CRM 24.11 is nexj-meta-dm-0.0.1.0-10-3c94615d.jar

Schema changes for 24.08

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 Table

New Column

Modified Column

Renamed Column

Removed Column

New Index

Renamed Index

Dropped & Recreated Index

Removed Index

NJCustomFieldTYpe

isAnnual

NJActivityPlanStep

stepScheduleDuration

Environment file changes for 24.08

New properties have been added:

  • organizationTimeZone - This property is used by the NexJ Schedule Synchronization feature.

  • supportEmail - This property is used to specify the email address that should be used on the About NexJ CRM dialog when users click the Email Support button.

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.

Additional upgrade notes for 24.08

You must configure the following Tomcat connector properties when upgrading your application to 24.08. If these changes are not completed, you may experience errors related to passwords and security.

  1. In the environment file, remove the secretRequired property.

  2. In the environment file, add the ajp.connector.secret property and set the value to the strong password you want to use.

  3. In the environment file, ensure that the ajp.connector.address property exists and that the value is set to "0.0.0.0".

  4. In the the mod_jk configuration file, for each existing node, add the worker.<name>.secret property and set the value to the strong password specified in the ajp.connector.secret property in the environment file.

  5. For deployments using Windows authentication: In the environment file, set the ajp.connector.tomcatAuthentication property to false.

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 Table

New Column

Modified Column

Renamed Column

Removed Column

New Index

Renamed Index

Dropped & Recreated Index

Removed 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 Table

New Column

Modified Column

Renamed Column

Removed Column

New Index

Renamed Index

Dropped & Recreated Index

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

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close