Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

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

 

 

6 Replies

Re: Qlik Sense Server upgrade error 1708

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.
Partner
Partner

Re: Qlik Sense Server upgrade error 1708

Hi,

the error message is in the ServiceDIspatcher log.

You can find it here attached.

 

Thanks

 

 

 

 

Re: Qlik Sense Server upgrade error 1708

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.
Partner
Partner

Re: Qlik Sense Server upgrade error 1708

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.

 

 

 

Re: Qlik Sense Server upgrade error 1708

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? 

Partner
Partner

Re: Qlik Sense Server upgrade error 1708

Hello,

 

thanks Filippo.

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