Problem installing Qlik Sense Enterprise on brand ... - Qlik Community

Kornee · ‎2023-01-13

Tried to install QS Enterprise Nov 2022 version on a brand new Windows 2019 server, but it keeps on failing on the Postgress part.

From the ..PostgreSQL125.log:

..

Action 16:38:15 68 postgresDir: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5\bin\, postgresDbDir: C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\12.5.
Action 16:38:15 68 Failed when trying to init db, an exception was thrown. Details: Access is denied.
CustomAction CA_InitDB returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (1C:C4) [16:38:15:726]: Note: 1: 2265 2: 3: -2147287035
MSI (s) (1C:C4) [16:38:15:728]: User policy value 'DisableRollback' is 0

..

MSI (s) (1C:C4) [16:38:19:887]: Note: 1: 1708
MSI (s) (1C:C4) [16:38:19:887]: Product: PostgreSQL125 -- Installation failed.

MSI (s) (1C:C4) [16:38:19:887]: Windows Installer installed the product. Product Name: PostgreSQL125. Product Version: 14.97.3. Product Language: 1033. Manufacturer: QlikTech International AB. Installation success or error status: 1603.

..

From the log:

[1098:08D8][2023-01-13T16:37:57]i000: Starting execution of PostgreSQL
[1468:053C][2023-01-13T16:37:57]i301: Applying execute package: PostgreSQL, action: Install, path: C:\ProgramData\Package Cache\{86F58189-0127-47A6-B482-C103B644B6F5}v14.97.3\PostgreSQL.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" DBPASSWORD="*****" DBDATAFOLDER="C:\ProgramData\\Qlik\Sense\Repository\PostgreSQL" SERVICEUSER="bentum\ixolutions" USERPASSWORD="*****" CENTRALREPOSITORY="1" BURN="1" INSTALLDIR="C:\Program Files\Qlik\Sense" MODIFY="0" SKIPSTARTSERVICES="0" LASTSERVICE="QlikSensePrintingService" RANDOMPASSWORD="*****" SKIPDBCONFIG="0" SKIPDBVALIDATION="0" USINGPOSTGRESQL="0" UNINSTALLEVERYTHING="" UNIQUEAPPGUID="D188A6E3-B88B-47A7-9E3B-465E3775BDAE" BURNUILEVEL="" FAIL="" DBLIMITEDUSERNAME="qliksenserepository" SKIPINSTALLDBSERVICE="0" DBPORT="4432" SHAREDPERSISTENCE="1" CONFIGUREPGLISTENER="1" DBLISTENADDRESSES="SRVQLIK01.Bentum.local" DBIPRANGE="fe80::1064:7cdb:1a7e:a21c/128,10.15.0.10/32" DBMAXCONNECTIONS="100" DBDUMPFILEPATH="" UPGRADEPSQL="" REMOVEDUMP="0" BUNDLETEMPDIRECTORY="C:\Users\Ixolutions\AppData\Local\Temp\2\{786D3689-AB0E-4C59-A41A-8FDD320E6E4D}\.ba" ENCODEDUSERPASSWORD="*****" SHAREDROOTFOLDER="\\SRVQLIK01\Users\Ixolutions\Documents\QLIK" STATICCONTENTROOT="\\SRVQLIK01\Users\Ixolutions\Documents\QLIK\StaticContent" ARCHIVEDLOGSROOT="\\SRVQLIK01\Users\Ixolutions\Documents\QLIK\ArchivedLogs" APPSROOT="\\SRVQLIK01\Users\Ixolutions\Documents\QLIK\Apps" SKIPVALIDATION="0" SKIPINSTALLPOSTGRESQL96="1" SKIPINSTALLPOSTGRESQL125="0" POSTGRESHOME="C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5"'
[1098:08D8][2023-01-13T16:38:00]i000: In Update Progress: 1
[1098:08D8][2023-01-13T16:38:00]i000: In Update Progress: 2
[1098:08D8][2023-01-13T16:38:00]i000: In Update Progress: 3
[1098:08D8][2023-01-13T16:38:00]i000: In Update Progress: 4
[1098:08D8][2023-01-13T16:38:00]i000: In Update Progress: 5
[1098:08D8][2023-01-13T16:38:00]i000: In Update Progress: 6
[1468:053C][2023-01-13T16:38:00]w355: Unable to register source directory: C:\ProgramData\Package Cache\{86F58189-0127-47A6-B482-C103B644B6F5}v14.97.3\, product: {86F58189-0127-47A6-B482-C103B644B6F5}, reason: 0x80070645. Continuing...
[1098:08D8][2023-01-13T16:38:00]i319: Applied execute package: PostgreSQL, result: 0x0, restart: None
[1468:053C][2023-01-13T16:38:00]i325: Registering dependency: {cc17cd59-096e-4372-912e-a5df3f5e95fd} on package provider: {86F58189-0127-47A6-B482-C103B644B6F5}, package: PostgreSQL
[1468:053C][2023-01-13T16:38:00]i323: Registering package dependency provider: {C2138B7C-FE47-4220-825E-9C7AC7A98E91}, version: 14.97.3, package: PostgreSQL125
[1098:08D8][2023-01-13T16:38:00]i000: ProgressTypeInstallation
[1098:08D8][2023-01-13T16:38:00]i000: Starting execution of PostgreSQL125
[1468:053C][2023-01-13T16:38:00]i301: Applying execute package: PostgreSQL125, action: Install, path: C:\ProgramData\Package Cache\{C2138B7C-FE47-4220-825E-9C7AC7A98E91}v14.97.3\PostgreSQL125.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" DBPASSWORD="*****" DBDATAFOLDER="C:\ProgramData\\Qlik\Sense\Repository\PostgreSQL" SERVICEUSER="bentum\ixolutions" USERPASSWORD="*****" CENTRALREPOSITORY="1" BURN="1" INSTALLDIR="C:\Program Files\Qlik\Sense" MODIFY="0" SKIPSTARTSERVICES="0" LASTSERVICE="QlikSensePrintingService" RANDOMPASSWORD="*****" SKIPDBCONFIG="0" SKIPDBVALIDATION="0" USINGPOSTGRESQL="0" UNINSTALLEVERYTHING="" UNIQUEAPPGUID="D188A6E3-B88B-47A7-9E3B-465E3775BDAE" BURNUILEVEL="" FAIL="" DBLIMITEDUSERNAME="qliksenserepository" SKIPINSTALLDBSERVICE="0" DBPORT="4432" SHAREDPERSISTENCE="1" CONFIGUREPGLISTENER="1" DBLISTENADDRESSES="SRVQLIK01.Bentum.local" DBIPRANGE="fe80::1064:7cdb:1a7e:a21c/128,10.15.0.10/32" DBMAXCONNECTIONS="100" DBDUMPFILEPATH="" UPGRADEPSQL="" REMOVEDUMP="0" BUNDLETEMPDIRECTORY="C:\Users\Ixolutions\AppData\Local\Temp\2\{786D3689-AB0E-4C59-A41A-8FDD320E6E4D}\.ba" ENCODEDUSERPASSWORD="*****" SHAREDROOTFOLDER="\\SRVQLIK01\Users\Ixolutions\Documents\QLIK" STATICCONTENTROOT="\\SRVQLIK01\Users\Ixolutions\Documents\QLIK\StaticContent" ARCHIVEDLOGSROOT="\\SRVQLIK01\Users\Ixolutions\Documents\QLIK\ArchivedLogs" APPSROOT="\\SRVQLIK01\Users\Ixolutions\Documents\QLIK\Apps" SKIPVALIDATION="0" SKIPINSTALLPOSTGRESQL96="1" SKIPINSTALLPOSTGRESQL125="0" POSTGRESHOME="C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5"'
[1098:08D8][2023-01-13T16:38:01]i000: In Update Progress: 7
[1098:08D8][2023-01-13T16:38:02]i000: In Update Progress: 8
[1098:08D8][2023-01-13T16:38:02]i000: In Update Progress: 9
[1098:08D8][2023-01-13T16:38:02]i000: In Update Progress: 10
[1098:08D8][2023-01-13T16:38:02]i000: In Update Progress: 11
[1098:08D8][2023-01-13T16:38:03]i000: In Update Progress: 12
[1468:053C][2023-01-13T16:38:19]e000: Error 0x80070643: Failed to install MSI package.
[1468:053C][2023-01-13T16:38:19]e000: Error 0x80070643: Failed to execute MSI package.
[1098:08D8][2023-01-13T16:38:19]e000: Error 0x80070643: Failed to configure per-machine MSI package.
[1098:08D8][2023-01-13T16:38:19]i000: Detected failing msi: PostgreSQL125
[1098:08D8][2023-01-13T16:38:19]i319: Applied execute package: PostgreSQL125, result: 0x80070643, restart: None
[1098:08D8][2023-01-13T16:38:19]e000: Error 0x80070643: Failed to execute MSI package.
[1098:08D8][2023-01-13T16:38:19]i000: ProgressTypeInstallation
[1098:08D8][2023-01-13T16:38:19]i000: Starting rollback execution of PostgreSQL125

Not sure what to do, restarts and reboots of the server wont work.

Mike_Dickson · ‎2023-01-13

Hello @Kornee ,

Have you verified that all of the requirements are met prior to the install?

IE: Make sure that the service account is a Local Admin on the server and also attempt to install the software with the same service account.

https://help.qlik.com/en-US/sense-admin/November2022/Subsystems/DeployAdministerQSE/Content/Sense_De...

I hope this helps!

Sr. Technical Support Engineer with Qlik Support
Don't forget to mark a solution that worked for you!

p_verkooijen · ‎2024-09-20

In my case, on new machines this has always been due to missing c++ redistributables.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Desktop-or-Server-Install-Fails-F...

Rohan · ‎2024-09-20

Hi @Kornee ,

3 things i can think of :

1) latest redistributables & .net to be installed.

2) permissions to exceute unsigned powershell scripts.

3) Search for "Return value 3" in the installation Logs, that will point you to the exact step where the error occured.

Regards,

Rohan.

Problem installing Qlik Sense Enterprise on brand new Windows 2019 server

General Question