Qlik QPI installer

[heij1421]

I want to upgrade my existing version of Qlik Sense Enterprise from release February 2023 to February 2024. The existing version still uses the PostgreSQL 9.6 database. So I want to use the Qlik PostgreSQL Installer to upgrade and unbundle the PostgreSQL database.

I used version 1.3 instead of 1.4 of the QPI tool as my folder where Qlik is installed is not the default "C:\program files\qlik\sense" folder.

After a few minutes the QPI returns an error and refers to the log folder. Within this log folder in the install-postgresql.log file, the following lines are included:

-----------------------------------

Called ClearAcl (C:\Program Files\PostgreSQL\14\data)...
Executing batch file 'rad811EC.bat'...
C:\Program Files\PostgreSQL\14\data NT SERVICE\TrustedInstaller:(I)(F)
NT SERVICE\TrustedInstaller:(I)(CI)(IO)(F)
NT AUTHORITY\SYSTEM:(I)(F)
NT AUTHORITY\SYSTEM:(I)(OI)(CI)(IO)(F)
BUILTIN\Administrators:(I)(F)
BUILTIN\Administrators:(I)(OI)(CI)(IO)(F)
BUILTIN\Users:(I)(RX)
BUILTIN\Users:(I)(OI)(CI)(IO)(GR,GE)
CREATOR OWNER:(I)(OI)(CI)(IO)(F)
APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)
APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)

Successfully processed 1 files; Failed processing 0 files

Removing inherited ACLs on (C:\Program Files\PostgreSQL\14\data)
Called Die(Failed to reset the ACL (C:\Program Files\PostgreSQL\14\data))...
Failed to reset the ACL (C:\Program Files\PostgreSQL\14\data)

Script stderr:
Program ended with an error exit code

-----------------------------------

I'm an admin and I run the tool as administrator. Also I disabled UAC, but without any success. Please help.

[mpc]

Hi,

You can check the changelog here: https://community.qlik.com/t5/Official-Support-Articles/Release-Notes-Qlik-Sense-PostgreSQL-installe...

An issue was detected on QPI 1.3.0 and prevents an upgrade from PG 9.6
Moreover, you should uninstall Qlik Sense patch before using QPI.

Version 1.4.0 of QPI should detect installation on another default folder, since PG runs on standard 4432 port

Kind regards

[heij1421]

Version 1.4.0 doesn't detect the default folder, see Solved: Qlik PostgreSQL Installer doesn't detect database - Qlik Community - 2447279

So I cannot use QPI version 1.3.0 as I'm using PG 9.6

and I cannot use QPI 1.4.0 as the program was not installed in the default folder.

Any advice?

[EdwardLee]

Qliksense is the worst at upgrading. It has all kinds of problems and seriously affects later maintenance.

[mpc]

Last time I'v done an upgrade like yours, I've backup my Qlik Sense site, uninstall it, and restore to the same version, with Postgre 11. Then, I've upgraded to 14 via QPI, and then I've upgraded Qlik Sense. 
Quite complex, but working great. 

Regards

[mpc]

Oups, I mean Postgre 12.X and not 11.X, my bad