Qlik Sense Upgrade Fails On Environment With Manually Migrated PostgreSQL database

[Andrew_Delaney]

The Qlik Sense installer expects either the included database to be present, or a separately hosted database to be present when upgrading. If both are present, the installer stops progressing during the database upgrade step.

A review of the logs will show that the installer is correctly connecting to the separately hosted database but for some reason just ceases to progress. No error is displayed to the user, but Qlik Sense will never successfully upgrade.

Resolution

The simplest workaround for this issue is:

1. Uninstall the existing version of Qlik Sense (retaining the certificate). This will remove the remaining traces of the bundled PostgreSQL
2. Rename the C:\ProgramData\Qlik\Sense folder
3. Reinstall the same version of Qlik Sense which was previously uninstalled
4. Verify functionality and that Qlik Sense connects to the standalone database
5. Upgrade

Cause 

This happens when the manual migration did not fully clean up and remove the old bundled database, it can occur even if you have removed the Qlik Sense Repository Database service and removed the files that the database uses.

Environment

Qlik Sense Enterprise on Windows