Update the server

You can use the installer to update the server to the latest version. To do so, perform the following steps:

Note
Updating the server version doesn’t update the player versions.

Backup your system

Perform a complete backup of your system so that you can revert to a previous server state in the event of an error.

Prepare the installation

Before installing the latest server version, ensure that you stop all application pools and Windows services. Don’t forget to restart them after the installation.

Update the database

How you update the database depends on your IXM One version:

Version 12.0 or later

Note
You may encounter issues when using the database migrator with SQL Express. In this case, we recommend updating the database manually as in versions prior to 12.0.

Prerequisites

Before you begin, make sure that the database server can access the backend server and that the master.config file is shared.

If that’s not possible, you can specify the connection string manually. For example:

.\DbMigrator.exe -c "Server=(local);Database=example;Integrated Security=true;TrustServerCertificate=True;"

❯ .\DbMigrator.exe --help
USAGE:
    DbMigrator.exe [OPTIONS]

OPTIONS:
    -h, --help                                     Prints help information
    -c, --connection-string <CONNECTION_STRING>    The connection string to the database
    -m, --master-config <MASTER_CONFIG>            The master config file
    -d, --directory <SCRIPT_DIRECTORY>             The directory containing the db scripts
        --sqlcmd                                   The sqlcmd executable to use
        --unattended                               Run in unattended mode

Update the database

Starting with version 12.0, you can use a database migrator to easily update the database. Perform the following steps:

Open a terminal.
Navigate to the DB folder.
Run DbMigrator.exe.
Specify the path to the master.config file, including master.config at the end.
Select Apply migration.
...
This starts the migration.
Wait until the migration was successful.

Versions prior to 12.0

To update the database, perform the following steps:

Open SSMS.
Connect to the SQL Server that hosts the Grassfish database.
To locate the current database version, select the database from the dropdown menu.
Click on New Query.
Run the following SQL query: select * from gblVersion
In the Results tab, check the currentVersion. You need to know it for the following steps.
Open the file MultiMigrationScript.sql located in the DB folder in the server installation folder.
Edit the script as shown in the following image:
In the Query menu, select SQLCMD Mode.
To run the script with the Grassfish database, select the database from the dropdown menu and click Execute.
Open the All_SP_Trigger.sql file located in the DB folder in the server installation folder.
To run the script with the Grassfish database, select the database from the dropdown menu and click Execute.
Open your configuration setting files located in the DB folder and run them with the Grassfish database.

Update the server software

You can now update the IXM Server software.

Prerequisites

If you update from version 11.17 or later to 12.0 or later, you must ensure that ;TrustServerCertificate=True is included in all connection strings.

<add key="DB:default" value="Server=GRASSFISH02\SQLEXPRESS;Database=GV2_Base;User ID=globalVision;Password=Secret;TrustServerCertificate=True"/>
<add key="DB:ReportData" value="Server=GRASSFISH02\SQLEXPRESS;Database=GenericReporting;UserID=globalVision;Password=Secret;TrustServerCertificate=True"/>

Update the server

To update the server software, perform the following steps:

Stop all Grassfish-related application pools and Windows services.
Right-click on the file Grassfish IXM Server and select Run as administrator.
Select the install path.
Click Next.
Manually adjusting the features is usually not necessary, as the existing features are retained during an update. Simply click Next.
Click Next until you’ve reached the final installation window.
Select Install.
Once the software update is complete, close the installer.
Restart your application pools and services.