Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I am successfully logged through pg admin using postgres user account and password.
Can you check everything here:
(Antivirus, service account and so on)
I referred this article. And yes, our environment is conforming to the requirements mentioned in that article.
It is not solved. We found the error in de ServiceDispatcher giving a waring "No superuser or password specified". The start of the install Qlik Sense Repository Database superuser password isn’t ask (Running the upgrade application point 6 is skipped)
Log PostgresSQL14 is successful:
MSI (s) (0C:64) [11:26:36:964]: Windows Installer installed the product. Product Name: PostgreSQL14. Product Version: 14.173.3. Product Language: 1033. Manufacturer: QlikTech International AB. Installation success or error status: 0.
ServiceDispatcher:
Action 11:34:43 66 ConfigMerger::ProcessFileMerge::end
MSI (s) (0C:88) [11:34:43:676]: Executing op: ActionStart(Name=CA_StartDatabase,,)
Action 11:34:43 66 CustomAction PersistConfig completed
MSI (s) (0C:88) [11:34:43:676]: Executing op: CustomActionSchedule(Action=CA_StartDatabase,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="C:\windows\SysWOW64\net.exe" start "QlikSenseRepositoryDatabase")
MSI (s) (0C:3C) [11:34:43:678]: Invoking remote custom action. DLL: C:\windows\Installer\MSI9871.tmp, Entrypoint: CAQuietExec
MSI (s) (0C:08) [11:34:43:678]: Generating random cookie.
MSI (s) (0C:08) [11:34:43:682]: Created Custom Action Server with PID 9156 (0x23C4).
MSI (s) (0C:A0) [11:34:43:706]: Running as a service.
MSI (s) (0C:A0) [11:34:43:708]: Hello, I'm your 32bit Elevated Non-remapped custom action server.
CAQuietExec: The service name is invalid.
CAQuietExec:
CAQuietExec: More help is available by typing NET HELPMSG 2185.
CAQuietExec:
CAQuietExec: Error 0x80070002: Command line returned an error.
CAQuietExec: Error 0x80070002: QuietExec Failed
CAQuietExec: Error 0x80070002: Failed in ExecCommon method
MSI (s) (0C:88) [11:34:43:755]: Executing op: ActionStart(Name=CA_UpgradeADS,,)
CustomAction CA_StartDatabase returned actual error code 1603 but will be translated to success due to continue marking
MSI (s) (0C:88) [11:34:43:756]: Executing op: CustomActionSchedule(Action=CA_UpgradeADS,ActionType=11265,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (0C:0C) [11:34:43:757]: Invoking remote custom action. DLL: C:\windows\Installer\MSI98C0.tmp, Entrypoint: CAQuietExec
CAQuietExec: AppDistributionService configuration started.
CAQuietExec: WARNING: Skiping the database initialization. No superuser or password specified.
CAQuietExec: Reading the settings file.
CAQuietExec: Saving the modified settings.
CAQuietExec: Exporting the copy of the invocation parameters.
MSI (s) (0C:88) [11:34:45:101]: Executing op: ActionStart(Name=CA_UpgradeDPS,,)
CAQuietExec: AppDistributionService configuration successful.
MSI (s) (0C:88) [11:34:45:101]: Executing op: CustomActionSchedule(Action=CA_UpgradeDPS,ActionType=11265,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (0C:90) [11:34:45:103]: Invoking remote custom action. DLL: C:\windows\Installer\MSI9E01.tmp, Entrypoint: CAQuietExec
CAQuietExec: DataPrepService configuration started.
CAQuietExec: WARNING: Skiping the database initialization. No superuser or password specified.
CAQuietExec: Creating schema 'dataprep_service'.
CAQuietExec: Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema_name = 'dataprep_service'": ps
CAQuietExec: ql: error: connection to server at "localhost" (::1), port 4432 failed: Connection refused (0x0000274D/10061)
CAQuietExec: Is the server running on that host and accepting TCP/IP connections?
CAQuietExec: connection to server at "localhost" (127.0.0.1), port 4432 failed: Connection refused (0x0000274D/10061)
CAQuietExec: Is the server running on that host and accepting TCP/IP connections?
CAQuietExec: At D:\Qlik\Sense\DataPrepService\install\install-utils\Postgres.ps1:109 char:9
CAQuietExec: + throw "Error executing database command "" ...
CAQuietExec: + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CAQuietExec: + CategoryInfo : OperationStopped: (:) , Exception
CAQuietExec: + FullyQualifiedErrorId : Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema
CAQuietExec: _name = 'dataprep_service'": psql: error: connection to server at "localhost" (::1), port 4432 failed: Connection
CAQuietExec: refused (0x0000274D/10061)
CAQuietExec: Is the server running on that host and accepting TCP/IP connections?
CAQuietExec: connection to server at "localhost" (127.0.0.1), port 4432 failed: Connection refused (0x0000274D/10061)
CAQuietExec: Is the server running on that host and accepting TCP/IP connections?
CAQuietExec:
CAQuietExec: Error 0x80070001: Command line returned an error.
CAQuietExec: Error 0x80070001: QuietExec Failed
CAQuietExec: Error 0x80070001: Failed in ExecCommon method
CustomAction CA_UpgradeDPS returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)