Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
fbar
Contributor
Contributor

Qlik Sense Enterprise can't be patched or upgraded (May 2023 after Qlik PostgreSQL Installer was used) - Stuck on May 2023 IR

Hey,

we have a fully functional May 2023 Initial Release installation (14.129.6). Before that, February 2023 versions with patches.

As we tried to upgrade to August 2023 (and following patches), the installer asked us to upgrade to stand-alone Postgres (14). We did that using Qlik PostgreSQL Installer. Afterwards Postgres125.msi was used to uninstall it - success.

Everything in QMC/Hub still works fine, Qlik Sense Util shows no error or issue. Task are running, all connections there, etc. Apparently, the connection to the DB and SenseShare are fine.

But now, instead of asking for Postgres-debundling, the August 2023 installer talks about changing from synchronized to shared persistence. We have only a central node which is correctly using PostgreSQL and the SenseShare-folder, so this does not make sense. When I put in the correct folder from QMC, it does not work.

Also, when trying to install any May 2023 Patch, the patch-installer won't recognize the May 2023 IR ("Update failed: Ensure that Qlik Sense May 2023 is installed before you install Qlik Sense May 2023 Patch 7.").

---------

  • Full administrator rights ("root"-admin")
  • SenseShare-Folder is "shared" with the "Qlik Sense Users Group" and owned by the service-user
  • In C:\ProgramData\Package Cache has other installs or (old) patches, only May 2023
  • Control Panel > Software has no other Updates or Installations 
  • I tried re-naming the folder with C:\ProgramData\Package Cache\{...}\Qlik_Sense_setup.exe which seems to be help with other problesm.
  • We used the "repair" function of May 2023 installer - no help. Repair .logs appear fine
  • Qlik Sense May 2023 Initial Release is fully functional, before and after PostgreSQL debundling

-----------

Is this general issue known? I found some similar ones, sometimes a few years old but not exact this one.

Is there a known fix?

I assume if there is no solution here, I am left with uninstalling May 2023 and installing August 2023 instead, importing the DB and SenseShare backup?

I can provide more or special logs.

Best,

Fabian

Qlik Sense Enterprise on Windows

 

-----------

There are the last lines from the August 2023 IR setup log before it's stopping; part of the text in blue when the error is thrown.

[0478:136C][2023-10-20T18:13:13]i000: GetVersionActivity: Started.
[0478:136C][2023-10-20T18:13:13]i000: Version: 14.139.4.
[0478:136C][2023-10-20T18:13:13]i000: InstalledVersion: 14.129.6.0.
[0478:136C][2023-10-20T18:13:13]i000: GetVersionActivity: Done.
[0478:136C][2023-10-20T18:13:13]i000: UpgradePersistenceModeWF: Done
[0478:136C][2023-10-20T18:13:13]i000: SharedPersistenceUIWF: Started
[0478:0754][2023-10-20T18:13:13]i000: Prerequisite check: Validating server operating system.
[0478:0754][2023-10-20T18:13:13]i000: Prerequisite check: Validating if PowerShell is installed.
[0478:0754][2023-10-20T18:13:13]i000: Prerequisite check: Validating PowerShell version.
[0478:136C][2023-10-20T18:13:13]i000: SharedPersistenceUpgradeUIWF: Started
[0478:136C][2023-10-20T18:13:13]i000: InvalidCertificateUIWF: Started
[0478:136C][2023-10-20T18:13:13]i000: WelcomeUIWF: Started
[0478:136C][2023-10-20T18:13:13]i000: Trying to navigate to WelcomeView
[0478:0C6C][2023-10-20T18:13:13]i000: The ViewModel Qlik.Burn.UI.Common.ViewModels.WelcomeViewModel was initialized.
[0478:0754][2023-10-20T18:13:13]i000: Prerequisite check: Validating if current user is LocalSystem.
[0478:0754][2023-10-20T18:13:13]i000: Prerequisite check: Validating allowed PostgreSQL database encryption.
[0478:0754][2023-10-20T18:13:13]i000: Qlik Sense installation mode: Upgrade.
[0478:0754][2023-10-20T18:13:13]i000: Prerequisite check: Validating if there is both a standalone and a local database that could cause problems when doing upgrade.
[0478:0754][2023-10-20T18:13:13]i000: Could not validate duplicate databases since ConnectionStringEntity is null.
[0478:0754][2023-10-20T18:13:13]i000: Prerequisite check: Validating if a standalone database exists with same paths as Qlik Sense on install or upgrade.
[0478:0754][2023-10-20T18:13:13]i000: Service: postgresql-x64-14 is installed.
[0478:0754][2023-10-20T18:13:13]i000: A standalone database service for PostgreSQL v 14.x is installed with name: postgresql-x64-14.
[0478:0754][2023-10-20T18:13:13]i000: No standalone database validation needed since no local PostgreSQL database wih Qlik Sense paths exists.
[0478:0C6C][2023-10-20T18:13:14]i000: QuickInstall pressed.
[0478:0C6C][2023-10-20T18:13:14]i000: Navigation to bookmark QuickInstall was initiated.
[0478:136C][2023-10-20T18:13:14]i000: WelcomeUIWF: Done
[0478:136C][2023-10-20T18:13:14]i000: Trying to navigate to LicenseAgreementView
[0478:0C6C][2023-10-20T18:13:15]i000: The ViewModel Qlik.Burn.UI.Common.ViewModels.LicenseAgreementViewModel was initialized.
[0478:0C6C][2023-10-20T18:13:33]i000: Navigation to bookmark Next was initiated.
[0478:136C][2023-10-20T18:13:33]i000: RepositoryRoleUIWF: Started
[0478:136C][2023-10-20T18:13:33]i000: RepoRoleConfig.IsCentralRepo: true
[0478:136C][2023-10-20T18:13:33]i000: ExistingSetup.IsCentral: true
[0478:136C][2023-10-20T18:13:33]i000: RepositoryRoleUIWF: Done
[0478:136C][2023-10-20T18:13:33]i000: RimNodeTypeUIWF: Started
[0478:136C][2023-10-20T18:13:33]i000: RimNodeTypeUIWF: Done
[0478:136C][2023-10-20T18:13:33]i000: SharedPersistenceStorageUIWF: Started
[0478:136C][2023-10-20T18:13:33]i000: Trying to navigate to SharedPersistenceStorageView
[0478:0C6C][2023-10-20T18:13:33]i000: The ViewModel Qlik.Burn.UI.Sense.ViewModels.SharedPersistenceStorageViewModel was initialized.
[0478:0C6C][2023-10-20T18:13:40]i000: Navigation to bookmark Next was initiated.
[0478:136C][2023-10-20T18:13:40]i000: Unexpected error during configuration: System.ArgumentNullException: Value cannot be null.
at Qlik.Burn.Common.SecureStringHelper.ConvertSecureStringToString(SecureString secureString)
at Qlik.Burn.WF.Activities.ValidationActivities.ValidateSharedPathsActivity.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
[0478:136C][2023-10-20T18:13:40]i000: In Error workflow: started
[0478:136C][2023-10-20T18:13:40]i000: GetStringPropertyActivity retrieved the value C:\Users\QLIKSE~1\AppData\Local\Temp\Qlik_Sense_August_2023_20231020181256.log from property WixBundleLog
[0478:136C][2023-10-20T18:13:40]i000: Trying to navigate to InstallFailureView
[0478:0C6C][2023-10-20T18:13:40]i000: The ViewModel Qlik.Burn.UI.Common.ViewModels.InstallFailureViewModel was initialized.

Labels (1)
1 Reply
ajaykakkar93
Specialist III
Specialist III

Hi,

Honestly telling you, Please take a backup of DB, Reinstall Qlik Sense May 2023 & restore your backup it will work perfectly fine & it will be future-proof also. 

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting