Update Stuck at "Upgrading Repository Database"

[Slindheim]

When installing the newest Update of QlikSense we got stuck at the point "Upgrading Repository Database". Currenty the installer is running for about 3 hours and still hasnt got further.

Is this a common problem? I couldnt find any information regarding this topic.

[Jack_Guo]

Hi @Slindheim ,

Can you check if there is any installation log recorded follow by the below article?

https://community.qlik.com/t5/Official-Support-Articles/How-To-Collect-Qlik-Sense-Installation-Log-F...

[Slindheim]

The last Entry in the log "Qlik_Sense_February_2023_20230316190001_010_PostgreSQL" is:

Action 19:04:41 70 NoExistingDatabaseCheck: Checking if database 'QSMQ' exists using PostgreSQL dir 'C:\Program Files\Qlik\Sense\\Repository\PostgreSQL\9.6\bin\'.

And the last few rows in the log file "Qlik_Sense_update_20230316070302" say:

16.03.2023 19:03:19 - FileOperationManager: RestoreFileToDestination: Install dir: C:\Program Files\Qlik\Sense\\Repository\Util\qlik-sense-util\QlikSenseUtil.exe
16.03.2023 19:03:19 - FileOperationManager: RestoreFileToDestination: Backup path: C:\ProgramData\Package Cache\22ff72b8-4b12-4448-ac17-d5f9d11c754b\Repository\Util\qlik-sense-util\QlikSenseUtil.exe
16.03.2023 19:03:19 - Remove file action reverse InstallDir\Repository\Util\qlik-sense-util\QlikSenseUtil.exe was successful: True
16.03.2023 19:03:19 - Will unregister product 'QlikSenseEnterprisePatch' from 'HKEY_LOCAL_MACHINE'.
16.03.2023 19:03:19 - Deleted subKey 'SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\QlikSenseEnterprisePatch'.
16.03.2023 19:03:19 - FileOperationManager: SchedulePackageCacheEntryRemoval for: C:\ProgramData\Package Cache\22ff72b8-4b12-4448-ac17-d5f9d11c754b
16.03.2023 19:03:19 - FileOperationManager: DeleteFolderStructureAfterReboot: C:\ProgramData\Package Cache\22ff72b8-4b12-4448-ac17-d5f9d11c754b
16.03.2023 19:03:20 - Update uninstalled successfully!
16.03.2023 19:03:20 - Update executed successfully! 456 files were updated
16.03.2023 19:03:20 - Exit code: 0

The Update is now running for 9 hours withour any progress. Still stuck at "Upgrading Repository Database"

[erikz]

Hi, how did you solve this problem @Slindheim?

[Slindheim]

To be honest: we just restarted the server and the problem was solved by itself...

After that we did follow the installationinstructions and everything worked fine.

[erikz]

Thanks! For info - In our case the upgrade actually managed to complete all steps after around 5 hours in state "upgrading repository database". 

[ManuelRühl]

Same problem here. Solution: Reboot ✌

[KHSDM]

How you reboot the server? Did you force kill the installation program? (Since there is no cancel button in the installation window)

[ManuelRühl]

We just forced the server to restart. It worked the last time.
But from May2023P4 to Aug2023 it did not work and we had to restore a backup of the server.
So be careful!

[Jack_Guo]

@ManuelRühl please also check the Qlik Sense installation log before force restart the server.