Foglight 7.1 upgrade fails if integrated authentication is used in existing Foglight environment (4373884)

Below errors can be seen in the installer log.

ERROR   [Thread-31] com.quest.nitro.installanywhere.util.UpgradeLibraryUtils - Declared field not exist: {0}
java.lang.NoSuchFieldException: sys_paths

ERROR   [Thread-31] com.quest.nitro.installanywhere.action.FoglightUpgradeRequirementCheckAction - Error occurs when checking upgrade requirement: {0}
java.lang.Exception: Change Java library path failed.

WORKAROUND 1

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

1. Open server.config and change server.database.integratedauth to false.

   server.database.integratedauth = "false";

2. Create a SQL Authentication account to connect to SQL Server database else an existing account can also be used.
3. Below parameters need to be updated 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.

Once the above changes are done reattempt the upgrade and it should be completed successfully.

WORKAROUND 2

To complete the upgrade without changing to SQL Authentication, complete the following steps:

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

   server.database.integratedauth = "false";

2. In [FMS_HOME]/config/server.config configure a custom connection URL to use Integrated Authentication.

   server.database.url = "jdbc:sqlserver://DATABASE_HOST:PORT;database=DB_NAME;encrypt=false;integratedSecurity=true;trustServerCertificate=true";

   JDBC URL Format:

   jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

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

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

4. 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, in [FMS_HOME]/config/server.config add the following VM option and click on "Do Not Retry" 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.

5. Once the installation completes revert changes in the configuration file and restart Foglight.

STATUS

Issue logged as defect Id. FOG-7446 and has been fixed in the 7.3.0 and higher releases of Foglight.