Re: Upgrade Qlik Sense Enterpirse on Windows Error... - Qlik Community

RvdEnde · ‎2024-07-16

Hey there,

We are trying to upgrade to Qlik Sense Enterprise Feb 2024 from Aug 2023. During the upgrade the installation Failed and it returns error 1603 in de ServiceDispatcher log. The main log it mensions "Error 0x80070643: Failed to install MSI package."
After the error the installation aborted and reverted back.

Qlik_Sense_February_2024.log:

[0920:0910][2024-07-16T11:27:14]i000: Starting execution of Scheduler
[2408:2420][2024-07-16T11:27:14]i301: Applying execute package: Scheduler, action: Install, path: C:\ProgramData\Package Cache\{A927EA2B-63E9-4439-9EEB-66C72AADA766}v14.173.3\Scheduler.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" SERVICEUSER="min\serviceaccount" USERPASSWORD="*****" BURN="1" INSTALLDIR="D:\Qlik\Sense\" MODIFY="0" SKIPSTARTSERVICES="1" ENABLECONFIGPERSISTANCE="1" LASTSERVICE="QlikSensePrintingService" CONFIGSERVICES="1" FAIL=""'
[0920:0910][2024-07-16T11:27:15]i000: In Update Progress: 28
[0920:0910][2024-07-16T11:27:15]i000: In Update Progress: 29
[0920:0910][2024-07-16T11:27:15]i000: In Update Progress: 30
[0920:0910][2024-07-16T11:27:15]i000: In Update Progress: 31
[0920:0910][2024-07-16T11:27:15]i000: In Update Progress: 32
[0920:0910][2024-07-16T11:27:15]i000: In Update Progress: 33
[0920:0910][2024-07-16T11:27:21]i319: Applied execute package: Scheduler, result: 0x0, restart: None
[2408:2420][2024-07-16T11:27:21]i325: Registering dependency: {7d38c5f5-6dc3-4ff3-a49b-377659c0e4df} on package provider: {A927EA2B-63E9-4439-9EEB-66C72AADA766}, package: Scheduler
[2408:2420][2024-07-16T11:27:21]i323: Registering package dependency provider: {803D62F8-AEE1-4F18-BAFB-1D4CBC17ADC5}, version: 14.173.3, package: Client
[0920:0910][2024-07-16T11:27:21]i000: ProgressTypeMajorUpgrade
[0920:0910][2024-07-16T11:27:21]i000: Starting execution of Client
[2408:2420][2024-07-16T11:27:21]i301: Applying execute package: Client, action: Install, path: C:\ProgramData\Package Cache\{803D62F8-AEE1-4F18-BAFB-1D4CBC17ADC5}v14.173.3\Client.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" BURN="1" INSTALLDIR="D:\Qlik\Sense\" MODIFY="0" HTTPPORTNUMBER="" HTTPSPORTNUMBER="" ENABLEHTTPPORT="" DESKTOPSHORTCUT="0" HOSTNAME="qlikserver" FAIL=""'
[0920:0910][2024-07-16T11:27:27]i000: In Update Progress: 34
[0920:0910][2024-07-16T11:27:27]i000: In Update Progress: 35
[0920:0910][2024-07-16T11:27:28]i000: In Update Progress: 36
[0920:0910][2024-07-16T11:27:28]i000: In Update Progress: 37
[0920:0910][2024-07-16T11:27:29]i000: In Update Progress: 38
[0920:0910][2024-07-16T11:27:46]i319: Applied execute package: Client, result: 0x0, restart: None
[2408:2420][2024-07-16T11:27:46]i325: Registering dependency: {7d38c5f5-6dc3-4ff3-a49b-377659c0e4df} on package provider: {803D62F8-AEE1-4F18-BAFB-1D4CBC17ADC5}, package: Client
[2408:2420][2024-07-16T11:27:46]i323: Registering package dependency provider: {DB596761-7A82-4163-93E3-8F6676A285EC}, version: 14.173.3, package: ServiceDispatcher
[0920:0910][2024-07-16T11:27:46]i000: ProgressTypeMajorUpgrade
[0920:0910][2024-07-16T11:27:46]i000: Starting execution of ServiceDispatcher
[2408:2420][2024-07-16T11:27:46]i301: Applying execute package: ServiceDispatcher, action: Install, path: C:\ProgramData\Package Cache\{DB596761-7A82-4163-93E3-8F6676A285EC}v14.173.3\ServiceDispatcher.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" SERVICEUSER="min\serviceaccount" USERPASSWORD="*****" BURN="1" INSTALLDIR="D:\Qlik\Sense\" MODIFY="0" SKIPSTARTSERVICES="1" ENABLECONFIGPERSISTANCE="1" LASTSERVICE="QlikSensePrintingService" CONFIGSERVICES="1" DBPASSWORD="*****" USINGPOSTGRESQL="" RANDOMPASSWORD="*****" SKIPDBCONFIG="0" DBHOSTNAME="localhost" DBPORT="4432" DBLIMITEDUSERNAME="qliksenserepository" INSTALLDB="" SKIPINSTALLDBSERVICE="1" ENCODEDUSERPASSWORD="*****" FAIL="" INSTALLTYPE="Upgrade" UPGRADEHYBRIDSERVICES="1" POSTGRESHOME="D:\Qlik\Sense\\Repository\PostgreSQL\14"'
[0920:0910][2024-07-16T11:31:34]i000: In Update Progress: 39
[0920:0910][2024-07-16T11:31:35]i000: In Update Progress: 40
[0920:0910][2024-07-16T11:31:39]i000: In Update Progress: 41
[0920:0910][2024-07-16T11:31:43]i000: In Update Progress: 42
[0920:0910][2024-07-16T11:31:45]i000: In Update Progress: 43
[0920:0910][2024-07-16T11:31:52]i000: In Update Progress: 44
[2408:2420][2024-07-16T11:35:27]e000: Error 0x80070643: Failed to install MSI package.
[2408:2420][2024-07-16T11:35:27]e000: Error 0x80070643: Failed to execute MSI package.
[0920:0910][2024-07-16T11:35:27]e000: Error 0x80070643: Failed to configure per-machine MSI package.
[0920:0910][2024-07-16T11:35:27]i000: Detected failing msi: ServiceDispatcher
[0920:0910][2024-07-16T11:35:27]i319: Applied execute package: ServiceDispatcher, result: 0x80070643, restart: None
[0920:0910][2024-07-16T11:35:27]e000: Error 0x80070643: Failed to execute MSI package.
[0920:0910][2024-07-16T11:35:27]i000: ProgressTypeMajorUpgrade
[0920:0910][2024-07-16T11:35:27]i000: Starting rollback execution of ServiceDispatcher

Qlik_Sense_February_2024_ServiceDispatcher.log:

Property(S): dir6AF39B3521F93EA0DC200400306EFE70 = D:\Qlik\Sense\BotChannelService\node_modules\jsonwebtoken\node_modules\
Property(S): dir66B130F8FFF0CD95F845C854FB5D712B = D:\Qlik\Sense\BotChannelService\node_modules\libpq\.github\
Property(S): dir2FAB2C443331198A00A2EF0A5DD46BF8 = D:\Qlik\Sense\BotChannelService\node_modules\libpq\build\Release\.deps\Release\obj.target\addon\
Property(S): dirF59C31BB45A325340B9D3AFF98CBDE06 = D:\Qlik\Sense\BotChannelService\node_modules\libpq\build\Release\.deps\
Property(S): dirFC513A2675EB3BFD1AEE59D4CACEB408 = D:\Qlik\Sense\BotChannelService\node_modules\libpq\build\Release\obj.target\addon\
Property(S): dir95429F97CAB29A2D8BE91BA58E499CD8 = D:\Qlik\Sense\BotChannelService\node_modules\rollbar\node_modules\
Property(S): dirB2314015F2E14781E6DAB5BFC477EB6A = D:\Qlik\Sense\BotChannelService\node_modules\rollbar\vendor\
Property(S): dirCF6E409D77C3C00A64DF29CBB9EA8539 = D:\Qlik\Sense\BotChannelService\node_modules\rrule\dist\
Property(S): dirB10BE242AEC5D4C4969A25F3A9F0E61E = D:\Qlik\Sense\BotChannelService\node_modules\semver\node_modules\
Property(S): dirA3AB37E159E7E7A1602A11093C9A593F = D:\Qlik\Sense\BotChannelService\ssoLogin\public\
Property(S): VersionNT = 603
Property(S): SERVICEUSER = min\serviceaccount
Property(S): VersionNT64 = 603
Property(S): SERVICENAME = QlikSenseServiceDispatcher
Property(S): SKIPSTARTSERVICES = 1
Property(S): ARPCOMMENTS = This installer contains the logic and resources to install Qlik Sense Service Dispatcher
Property(S): ARPCONTACT = http://www.qlik.com
Property(S): ARPHELPLINK = http://www.qlik.com/us/services/support
Property(S): ARPURLINFOABOUT = http://www.qlik.com
Property(S): MsiLogging = oicewarmup
Property(S): MSIUNINSTALLSUPERSEDEDCOMPONENTS = 1
Property(S): MSIENFORCEUPGRADECOMPONENTRULES = 1
Property(S): ARPPRODUCTICON = Icon_Qlik
Property(S): Manufacturer = QlikTech International AB
Property(S): ProductCode = {DB596761-7A82-4163-93E3-8F6676A285EC}
Property(S): ProductLanguage = 1033
Property(S): ProductName = Qlik Sense Service Dispatcher
Property(S): ProductVersion = 14.173.3
Property(S): DefaultUIFont = WixUI_Font_Normal
Property(S): WixUI_Mode = Mondo
Property(S): ErrorDialog = ErrorDlg
Property(S): SecureCustomProperties = DBPASSWORD;ENCODEDUSERPASSWORD;NETFRAMEWORK45;PASSWORD;QSMQCREATEDB;RANDOMPASSWORD;SERVICEUSER;STARTDEPENDENTSERVICES;USERPASSWORD;WINDOWSSERVICEUSER;WIX_DOWNGRADE_DETECTED;WIX_UPGRADE_DETECTED
Property(S): MsiHiddenProperties = CA_SetupADS;CA_SetupDPS;CA_SetupHDS;CA_SetupLicenses;CA_SetupNLAS;CA_SetupNLB;CA_SetupNS;CA_SetupPS;CA_SetupQMR;CA_SetupQSMQ;CA_UpgradeADS;CA_UpgradeDPS;CA_UpgradeHDS;CA_UpgradeLicenses;CA_UpgradeNLAS;CA_UpgradeNLB;CA_UpgradeNS;CA_UpgradePS;CA_UpgradeQMR;CA_UpgradeQSMQ;DBPASSWORD;ENCODEDUSERPASSWORD;PASSWORD;QSMQCREATEDB;RANDOMPASSWORD;USERPASSWORD
Property(S): WIX_UPGRADE_DETECTED = {93D99C61-AEF2-4836-89DD-17F43FC12935}
Property(S): MsiLogFileLocation = C:\Users\serviceaccount\AppData\Local\Temp\Qlik_Sense_February_2024_20240716112314_017_ServiceDispatcher.log
Property(S): PackageCode = {A7764963-E654-4A61-980D-C2B3A7ECDB56}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): ARPSYSTEMCOMPONENT = 1
Property(S): MSIFASTINSTALL = 7
Property(S): USERPASSWORD = **********
Property(S): BURN = 1
Property(S): MODIFY = 0
Property(S): ENABLECONFIGPERSISTANCE = 1
Property(S): LASTSERVICE = QlikSensePrintingService
Property(S): CONFIGSERVICES = 1
Property(S): RANDOMPASSWORD = **********
Property(S): SKIPDBCONFIG = 0
Property(S): DBHOSTNAME = localhost
Property(S): DBPORT = 4432
Property(S): DBLIMITEDUSERNAME = qliksenserepository
Property(S): SKIPINSTALLDBSERVICE = 1
Property(S): ENCODEDUSERPASSWORD = **********
Property(S): INSTALLTYPE = Upgrade
Property(S): UPGRADEHYBRIDSERVICES = 1
Property(S): POSTGRESHOME = D:\Qlik\Sense\\Repository\PostgreSQL\14
Property(S): REBOOT = ReallySuppress
Property(S): CURRENTDIRECTORY = D:\Software\Qlik\IR
Property(S): CLIENTUILEVEL = 3
Property(S): MSICLIENTUSESEXTERNALUI = 1
Property(S): CLIENTPROCESSID = 9224
Property(S): VersionDatabase = 500
Property(S): MsiSystemRebootPending = 1
Property(S): VersionMsi = 5.00
Property(S): WindowsBuild = 9600
Property(S): ServicePackLevel = 0
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 3
Property(S): WindowsFolder = C:\windows\
Property(S): WindowsVolume = C:\
Property(S): System64Folder = C:\windows\system32\
Property(S): SystemFolder = C:\windows\SysWOW64\
Property(S): RemoteAdminTS = 1
Property(S): TempFolder = C:\Users\serviceaccount\AppData\Local\Temp\
Property(S): ProgramFilesFolder = C:\Program Files (x86)\
Property(S): CommonFilesFolder = C:\Program Files (x86)\Common Files\
Property(S): CommonFiles64Folder = C:\Program Files\Common Files\
Property(S): AppDataFolder = C:\Users\serviceaccount\AppData\Roaming\
Property(S): FavoritesFolder = C:\Users\serviceaccount\Favorites\
Property(S): NetHoodFolder = C:\Users\serviceaccount\AppData\Roaming\Microsoft\Windows\Network Shortcuts\
Property(S): PersonalFolder = C:\Users\serviceaccount\Documents\
Property(S): PrintHoodFolder = C:\Users\serviceaccount\AppData\Roaming\Microsoft\Windows\Printer Shortcuts\
Property(S): RecentFolder = C:\Users\serviceaccount\AppData\Roaming\Microsoft\Windows\Recent\
Property(S): SendToFolder = C:\Users\serviceaccount\AppData\Roaming\Microsoft\Windows\SendTo\
Property(S): TemplateFolder = C:\ProgramData\Microsoft\Windows\Templates\
Property(S): LocalAppDataFolder = C:\Users\serviceaccount\AppData\Local\
Property(S): MyPicturesFolder = C:\Users\serviceaccount\Pictures\
Property(S): AdminToolsFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools\
Property(S): StartupFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup\
Property(S): ProgramMenuFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\
Property(S): StartMenuFolder = C:\ProgramData\Microsoft\Windows\Start Menu\
Property(S): DesktopFolder = C:\Users\Public\Desktop\
Property(S): FontsFolder = C:\windows\Fonts\
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): MsiAMD64 = 6
Property(S): Msix64 = 6
Property(S): Intel = 6
Property(S): PhysicalMemory = 98303
Property(S): VirtualMemory = 98526
Property(S): AdminUser = 1
Property(S): MsiTrueAdminUser = 1
Property(S): LogonUser = serviceaccount
Property(S): UserSID = S-1-5-21-3723389022-3858856549-556620252-1954952
Property(S): UserLanguageID = 1043
Property(S): ComputerName = QAR70092
Property(S): SystemLanguageID = 1043
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 23
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): TextInternalLeading = 3
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): Time = 11:35:27
Property(S): Date = 16-7-2024
Property(S): MsiNetAssemblySupport = 4.8.3761.0
Property(S): MsiWin32AssemblySupport = 6.3.17763.4131
Property(S): RedirectedDllSupport = 2
Property(S): MsiRunningElevated = 1
Property(S): Privileged = 1
Property(S): USERNAME = DMO Ops
Property(S): COMPANYNAME = Ministerie van Defensie
Property(S): DATABASE = C:\windows\Installer\4ffce.msi
Property(S): OriginalDatabase = C:\ProgramData\Package Cache\{DB596761-7A82-4163-93E3-8F6676A285EC}v14.173.3\ServiceDispatcher.msi
Property(S): UILevel = 2
Property(S): ACTION = INSTALL
Property(S): MsiUISourceResOnly = 1
Property(S): MIGRATE = {93D99C61-AEF2-4836-89DD-17F43FC12935}
Property(S): ROOTDRIVE = D:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): INSTALLLEVEL = 1
Property(S): SOURCEDIR = C:\ProgramData\Package Cache\{DB596761-7A82-4163-93E3-8F6676A285EC}v14.173.3\
Property(S): SourcedirProduct = {DB596761-7A82-4163-93E3-8F6676A285EC}
Property(S): ProductToBeRegistered = 1
MSI (s) (0C:88) [11:35:27:150]: Note: 1: 1708 
MSI (s) (0C:88) [11:35:27:150]: Note: 1: 2205 2:  3: Error 
MSI (s) (0C:88) [11:35:27:150]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1708 
MSI (s) (0C:88) [11:35:27:150]: Note: 1: 2205 2:  3: Error 
MSI (s) (0C:88) [11:35:27:150]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 
MSI (s) (0C:88) [11:35:27:150]: Product: Qlik Sense Service Dispatcher -- Installation failed.

MSI (s) (0C:88) [11:35:27:151]: Windows Installer installed the product. Product Name: Qlik Sense Service Dispatcher. Product Version: 14.173.3. Product Language: 1033. Manufacturer: QlikTech International AB. Installation success or error status: 1603.

MSI (s) (0C:88) [11:35:27:215]: Deferring clean up of packages/files, if any exist
MSI (s) (0C:88) [11:35:27:215]: MainEngineThread is returning 1603
MSI (s) (0C:B8) [11:35:27:217]: RESTART MANAGER: Session closed.
MSI (s) (0C:B8) [11:35:27:218]: RESTART MANAGER: Session closed.
MSI (s) (0C:B8) [11:35:27:218]: No System Restore sequence number for this installation.

Jenil_Sangoi · ‎2024-07-16

I would request you to go through the below article and see if you can resolve the issue.

Qlik Sense Enterprise on Windows Upgrade Failed due to MobilityRegistrarService or qlik_notifier_ser...

If the issue still persists, then please refer the below article and provide the complete set of Installation Logs.

How to troubleshoot failed Qlik Sense installations

mpc · ‎2024-07-17

Hi,

Common cause of this issue is bad reference to PostgreSQL msi in package cache folders.
https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repo...

Try to apply step 16 and 17 of this process, and then upgrade Qlik.

Kind regards

From Next Decision and mpc with love
It helps, like it, It solves, mark it

sanrout · ‎2024-07-17

@RvdEnde - Could you please let us know if you are able to resolve the issue ? if yes, please let us know the steps as we also have faced the same issue today.

sanrout · ‎2024-07-18

Hi,

In the Qlik Sense service dispatcher log, the following error is recorded. PostgreSQL is unbundled already but we did uninstallation of OLD Qlik Sense Repository Database just prior to upgrade as mentioned in step 16 of the article mentioned by @mpc. Additionally, we did not perform step 17 of the article mentioned.

Lastly, PostgreSQL service is in running state while upgrade activity is being carried out.

mpc · ‎2024-07-18

Can you check what is running on port 4432 please ?

From Next Decision and mpc with love
It helps, like it, It solves, mark it

sanrout · ‎2024-07-18

Hi,

postgres.exe is running on that port 4432 as expected. We have postgres 14.8 installed using QPI.

mpc · ‎2024-07-18

Perfect, now can you check pg_hba.conf postgresql.conf files ?

From Next Decision and mpc with love
It helps, like it, It solves, mark it

sanrout · ‎2024-07-18

Both file look to be good in my opinion

mpc · ‎2024-07-18

For me too.

Can you try to connect this pgAdmin ? Maybe it's the password the problem ?

From Next Decision and mpc with love
It helps, like it, It solves, mark it

Upgrade Qlik Sense Enterpirse on Windows Error 1603

General Question