Return
-
Title
Installer error while connecting database. Invalid Cartridge Version Error message in UI. -
Description
Installer error while connecting to database. Invalid Cartridge Version Error is thrown in the UI.
The installation log Foglight_5.9.1_Install_YYYY-MM-DD_HHNNSS_001.log shows this error:
ERROR [Thread-17] com.quest.nitro.installanywhere.database.FoglightDatabaseConfigurator - Failed to validate cartridge version for upgrade: {0}
java.lang.RuntimeException: java.sql.SQLException: Network error IOException: Connection refused: connect
[...]
Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect[FMS_HOME]\server.config database configuration parameters have been confirmed to be correct, but server.database.port parameter is set to a custom port number.
This issue has only been observed for Microsoft SQL Server external database. -
Cause
This issue is caused by the Installer not being able to use a custom port to connect to the External SQL Server Database and tries to use the default port number 1433. This defect was previously identified as FGL-19548. -
Resolution
STATUS: FGL-19548 scheduled for fix post 5.9.1 release.
There are 2 workarounds to complete the upgrade. These should be removed after the upgrade completes.
- Temporarily change the DB port to 1433 on the DB server.
- Set up port forwarding on the DB server.
//Add port forwarding, FMS->DB Server(1433)->DB Server(20001)
netsh interface portproxy add v4tov4 listenport=1433 listenaddress=0.0.0.0 connectport=20001 connectaddress=localhost//Remove it after upgrade
netsh interface portproxy delete v4tov4 listenport=1433 listenaddress=0.0.0.0 -
Defect ID
FGL-19548