Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ppesca68
Partner - Contributor II
Partner - Contributor II

Qlik Sense Server upgrade error 1708

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

 

 

1 Solution

Accepted Solutions
Filippo_Nicolussi_P

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? 

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

6 Replies
Bastien_Laugiero

Hello, 

Could you attach the log that you are referring to?

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

 

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
ppesca68
Partner - Contributor II
Partner - Contributor II
Author

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?

 

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
ppesca68
Partner - Contributor II
Partner - Contributor II
Author

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

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? 

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
ppesca68
Partner - Contributor II
Partner - Contributor II
Author

Hello,

 

thanks Filippo.

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