"Foglight cannot be upgraded because of cartridge version incompatibilities" error when upgrading using a SQL Server FMS repository (4311121)

The following message appears in the Foglight Management Server (FMS) installer executable during an upgrade when using a SQL Server FMS repository.

"The Foglight cannot be upgraded because of cartridge version incompatibilities."

This message appears in the upgrade_failed_log

Or in the installation logs:

The incompatibility message appears before the SQL Server based FMS repository can be queried. The issue is related to the connection to the SQL Server FMS repository and can happen if integrated authentication is used but the account running the Foglight installer does not have access to the Foglight repository database.

OPTION 1

Ensure the account used to run the installer has access to the Foglight repository database or run the installer with the Foglight service account. 

OPTION 2

Complete the following steps to disable the cartridge check in the installer and add an option for upgrading the database schema when the Foglight service starts:

1. Run the installer with the -Dquest.cartridge.check.disabled=true flag. Example:

   Foglight-VERSION-install_windows-x86_64.exe -Dquest.cartridge.check.disabled=true

2. Error A Database Upgrade Error Occurred may be displayed if the user running the installer does not have access to the Foglight database; if so, without exiting the installer, in [FMS_HOME]/config/server.config add the -Dfoglight.database.upgrade=true VM option as in the example below, then select the Do Not Retry checkbox and click Next for the Foglight service to start.

   server.vm.optionX = "-Dfoglight.database.upgrade=true";

   Note: Replace X with the next number in the sequence of VM options.

3. Once the upgrade completes revert changes in the configuration file and restart Foglight.

OPTION 3

Temporarily switch to SQL Server Authentication to perform the upgrade and change back to Integrated Authentication once completed:

1. Open [FMS_HOME]/config/server.config and change server.database.integratedauth to false.

   server.database.integratedauth = "false";

2. In server.config update the following parameters with the SQL Server Authentication account and password.

   server.database.user = "USERNAME";
   server.database.password = "PASSWORD";

   Note: The password has to be encrypted. KB 4232181 can be used to encrypt the password.

3. Once the above changes are done reattempt the upgrade and it should be completed successfully.
4. Once the upgrade is completed, revert changes in the configuration file to enable Integrated Authentication.