Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense Server Install failing due to Postgres

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

4 Replies
jan_lance
Partner - Contributor III
Partner - Contributor III

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.

Not applicable
Author

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

Not applicable
Author

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

Tedmistro
Contributor II
Contributor II

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