Qlik Sense Server Install failing due to Postgres

Thu, 16 Jun 2016 13:19:35 GMT

I've been attempting to install Sense server on a Windows server machine. The installation is failing, apparently due to Postgres. The log shows " Error 0x80070643: Failed to execute MSI package.", and then later: "Failing MSI name (if any): PostgreSQL"

Excerpt of the log is below, and copies of the full logs attached. We had a "hung" installation previously - installed but we couldn't get to the QMC so we stopped all services, uninstalled, and reinstalled. Now we encounter this issue whenever we attempt re-installations.

Would very much appreciate any advice or guidance. We are installing from an administrator account. OS is Windows Server 2012 R2 Standard, 64-bit machine.

In the Postgres Log:

Property(S): SOURCEDIR = C:\ProgramData\Package Cache\{6486CF90-7269-4E22-B266-FFD5EC182D0F}v2.2.4.0\

Property(S): SourcedirProduct = {6486CF90-7269-4E22-B266-FFD5EC182D0F}

Property(S): ProductToBeRegistered = 1

MSI (s) (FC:C0) [08:19:19:158]: Note: 1: 1708

MSI (s) (FC:C0) [08:19:19:158]: Note: 1: 2205 2: 3: Error

MSI (s) (FC:C0) [08:19:19:158]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1708

MSI (s) (FC:C0) [08:19:19:158]: Note: 1: 2205 2: 3: Error

MSI (s) (FC:C0) [08:19:19:158]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709

MSI (s) (FC:C0) [08:19:19:158]: Product: PostgreSQL -- Installation failed.

MSI (s) (FC:C0) [08:19:19:158]: Windows Installer installed the product. Product Name: PostgreSQL. Product Version: 2.2.4.0. Product Language: 1033. Manufacturer: QlikTech International AB. Installation success or error status: 1603.

In the general log:

[111C:0B48][2016-06-16T08:14:54]i000: Starting execution of PostgreSQL

[0CE4:1320][2016-06-16T08:14:54]i301: Applying execute package: PostgreSQL, action: Install, path: C:\ProgramData\Package Cache\{6486CF90-7269-4E22-B266-FFD5EC182D0F}v2.2.4.0\PostgreSQL.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" DBPASSWORD="*****" DBDATAFOLDER="C:\ProgramData\\Qlik\Sense\Repository\PostgreSQL" SERVICEUSER="" USERPASSWORD="*****" BURN="1" INSTALLDIR="C:\Program Files\\Qlik\Sense" MODIFY="0" SKIPSTARTSERVICES="0" RANDOMPASSWORD="*****" SKIPDBCONFIG="0" SKIPDBVALIDATION="1" USINGPOSTGRESQL="1" UNINSTALLEVERYTHING="" UNIQUEAPPGUID="D188A6E3-B88B-47A7-9E3B-465E3775BDAE" BURNUILEVEL="" FAIL=""'

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 1

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 2

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 3

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 4

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 5

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 6

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 7

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 8

[111C:0B48][2016-06-16T08:14:54]i000: In Update Progress: 9

[111C:0B48][2016-06-16T08:14:55]i000: In Update Progress: 10

[111C:0B48][2016-06-16T08:19:16]i000: In Update Progress: 11

[0CE4:1320][2016-06-16T08:19:19]e000: Error 0x80070643: Failed to install MSI package.

[0CE4:1320][2016-06-16T08:19:19]e000: Error 0x80070643: Failed to execute MSI package.

[111C:0B48][2016-06-16T08:19:19]e000: Error 0x80070643: Failed to configure per-machine MSI package.

[111C:0B48][2016-06-16T08:19:19]i000: Detected failing msi: PostgreSQL

[111C:0B48][2016-06-16T08:19:19]i319: Applied execute package: PostgreSQL, result: 0x80070643, restart: None

[111C:0B48][2016-06-16T08:19:19]e000: Error 0x80070643: Failed to execute MSI package.

[111C:0B48][2016-06-16T08:19:19]i000: ProgressTypeInstallation

[111C:0B48][2016-06-16T08:19:19]i000: Starting rollback execution of PostgreSQL

[0CE4:1320][2016-06-16T08:19:19]i318: Skipped rollback of package: PostgreSQL, action: Uninstall, already: Absent

[111C:0B48][2016-06-16T08:19:19]i319: Applied rollback package: PostgreSQL, result: 0x0, restart: None

[0CE4:1320][2016-06-16T08:19:19]i329: Removed package dependency provider: {6486CF90-7269-4E22-B266-FFD5EC182D0F}, package: PostgreSQL

[0CE4:1320][2016-06-16T08:19:19]i351: Removing cached package: PostgreSQL, from path: C:\ProgramData\Package Cache\{6486CF90-7269-4E22-B266-FFD5EC182D0F}v2.2.4.0\

[0CE4:1320][2016-06-16T08:19:19]i372: Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{37767f6c-1c2f-428a-bda6-c6d8798f210d}, resume: None, restart: None, disable resume: No

[0CE4:1320][2016-06-16T08:19:19]i330: Removed bundle dependency provider: {37767f6c-1c2f-428a-bda6-c6d8798f210d}

[0CE4:1320][2016-06-16T08:19:19]i352: Removing cached bundle: {37767f6c-1c2f-428a-bda6-c6d8798f210d}, from path: C:\ProgramData\Package Cache\{37767f6c-1c2f-428a-bda6-c6d8798f210d}\

[0CE4:1320][2016-06-16T08:19:19]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{37767f6c-1c2f-428a-bda6-c6d8798f210d}, resume: None, restart initiated: No, disable resume: No

[111C:0B48][2016-06-16T08:19:19]i000: Navigation to bookmark Next was initiated.

[111C:0B48][2016-06-16T08:19:19]i399: Apply complete, result: 0x80070643, restart: None, ba requested restart: No

[111C:093C][2016-06-16T08:19:19]e000: SetupResult: -2147023293

[111C:093C][2016-06-16T08:19:19]e000: Failing MSI name (if any): PostgreSQL

[111C:093C][2016-06-16T08:19:19]i000: In Error workflow: started

[111C:093C][2016-06-16T08:19:19]i000: GetStringPropertyActivity retrieved the value C:\Users\QLIKSE~1\AppData\Local\Temp\Qlik_Sense_20160616081334.log from property WixBundleLog

[111C:093C][2016-06-16T08:19:19]i000: Trying to navigate to InstallFailureView

[111C:1380][2016-06-16T08:19:19]i000: The ViewModel Qlik.Burn.UI.Common.ViewModels.InstallFailureViewModel was initialized.

Re: Qlik Sense Server Install failing due to Postgres

jan_lance — Thu, 16 Jun 2016 14:10:49 GMT

Hi Brett,

I had a similar error installing Sense Server.

Unfortuenately Support couldn't help me either.

We solved the problem by uninstalling Sense Server and reinstalling it.

Be aware to use the newest version and install sense to the default directory and C-Partition.

Alternative folders may cause problems.

Re: Qlik Sense Server Install failing due to Postgres

Thu, 16 Jun 2016 15:39:37 GMT

just to be sure ... are you using an user with local admin right with password not "blank" right ?

Re: Qlik Sense Server Install failing due to Postgres

Thu, 16 Jun 2016 16:39:49 GMT

Okay, I stumbled on another thread that I had somehow missed in my previous research. Seem to have solved the installation problem. Post is here: QlikSense Server 1.1 Installation PostgreSQL Repository Installation Failed

What I did was as instructed on that post:

* Installed the Microsoft Visual C++ package (the post points to 2010 version; think I installed the most recent version

* Deleted %ProgramData%\Qlik directory (this required a server restart first, as it initially complained about another app using the folder, even though nothing was running in task manager)

* Deleted %ProgramData%\PackageCache directory

After all of the above, I was able to get a successful install with pretty green checkmarks all the way down the final installation window. Can't access the QMC in the browser, but that appears to be another issue to do with IP configuration...

Re: Qlik Sense Server Install failing due to Postgres

Tedmistro — Sat, 11 Dec 2021 15:38:36 GMT

Redownload the installer, be sure to remove the Qlik folders in ProgramData, reboot and use new installer.

topic Re: Qlik Sense Server Install failing due to Postgres in Management & Governance

Qlik Sense Server Install failing due to Postgres

In the Postgres Log:

In the general log:

Re: Qlik Sense Server Install failing due to Postgres

Re: Qlik Sense Server Install failing due to Postgres

Re: Qlik Sense Server Install failing due to Postgres

Re: Qlik Sense Server Install failing due to Postgres