Qlik Sense Server upgrade error 1708

[ppesca68]

Hi All,

I'm trying to update my Qlik Sense Server from June 2018 to April 2019 but I've got an error and the installation package aborted the upgrade removing the previous version.

The problem seems to be during the installation of the Service Dispatcher

The Qlik_Sense_April_2019_20190624155210_017_ServiceDispatcher.log contains the following messages

MSI (s) (10:F4) [16:56:10:403]: Note: 1: 1708
MSI (s) (10:F4) [16:56:10:403]: Note: 1: 2205 2: 3: Error
MSI (s) (10:F4) [16:56:10:403]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1708
MSI (s) (10:F4) [16:56:10:403]: Note: 1: 2205 2: 3: Error
MSI (s) (10:F4) [16:56:10:403]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709
MSI (s) (10:F4) [16:56:10:403]: Product: Qlik Sense Service Dispatcher -- Installation failed.

After the first fail, I found in a blog that I've to install the Microsoft Visual C++ 2010 Redistributable.

I did it then I restored the previous version, but when I ran the upgrade again, I've had the same error.

Can anyone help me?

Thanks in advance

[Bastien_Laugiero]

Hello, 

Could you attach the log that you are referring to?

I believe there is more detailed error message in this log. 

[ppesca68]

Hi,

the error message is in the ServiceDIspatcher log.

You can find it here attached.

Thanks

[Bastien_Laugiero]

Thank you!

So here is why the upgrade failed: 

CAQuietExec: Creating database schema for database 'QSMQ'
CAQuietExec: System.Exception: Error executing database command "SELECT 1 FROM pg_class WHERE relname = 'versionhistory';": psql: connessione al server fallita: Connection refused (0x0000274D/10061)
CAQuietExec: Verifica che il server all'indirizzo "localhost" (::1) sia in funzione
CAQuietExec: e che accetti connessioni TCP/IP sulla porta 4432
CAQuietExec: connessione al server fallita: Connection refused (0x0000274D/10061)
CAQuietExec: Verifica che il server all'indirizzo "localhost" (127.0.0.1) sia in funzione
CAQuietExec: e che accetti connessioni TCP/IP sulla porta 4432
CAQuietExec:
CAQuietExec: Error 0x80070002: Command line returned an error.
CAQuietExec: Error 0x80070002: QuietExec Failed
CAQuietExec: Error 0x80070002: Failed in ExecCommon method
CustomAction CA_UpgradeQSMQ returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (10:F4) [16:40:55:606]: Note: 1: 2265 2: 3: -2147287035
MSI (s) (10:F4) [16:40:55:607]: User policy value 'DisableRollback' is 0
MSI (s) (10:F4) [16:40:55:607]: Machine policy value 'DisableRollback' is 0
Action ended 16.40.55: InstallFinalize. Return value 3.

So it looks like the installer could not connect to the database on localhost using port 4432.

Have you customized the port or enable SSL on Postgres for example?

Is the Qlik Sense Repository Database actually installer on the central node?

[ppesca68]

Hello,

the repository database is installed on the same server and it's configured with the standard parameters (please see attached the screenshot of the connection property page of pgAdmin).

Maybe we are missing some operation during the installation?

We simply run the package in administrator mode without doing any other action on the existing installation.

[Filippo_Nicolussi_P · Accepted solution]

Hello 

Searching on PostgreSQL for the error Connection refused (0x0000274D/10061) , seems reported as Firewall related ; 

however, checking the screen-shot , seems you are able to connect to localhost .

Could you try using the IPv6 address   ::1  with PGadmin? 

[ppesca68]

Hello,

thanks Filippo.

After enabling the IPv6 on the server, the upgrade terminated successfully