When upgrading Qlik Sense Enterprise to November 2018 Release or newer, the upgrade may fail during Repository upgrade. Checking install logs found in %temp%, the PostgreSQL shows the following line at the end of the file:
Initializing 'QSMQ' database.
No further actions are completed after this point. You may also see several attempts on the same step, up to 10 attempts.
A previous upgrade failure or inconsistency can cause the QMSQ database ownership to be incorrect. Since the Qlik Sense installer tries to validate the connection to all underlying databases, a failure to do so against any of them will result in a failure to upgrade.
Example error message:
This version of Qlik Sense requires a 'SenseServices'" database for multi cloud capabilities. Ensure that you have created a 'SenseServices' database in your cluster before upgrading.
Select the QSMQ database and expand it (to make sure the connection is established)
Go to Tools -> Query
Paste the content below and execute the queries. These queries will re-establish correct ownership of the QSMQ database and allow the upgrade to complete:
ALTER DATABASE "QSMQ" OWNER TO qliksenserepository; --sets qliksenserepository as owner of the QSMQ database
GRANT TEMPORARY, CONNECT ON DATABASE "QSMQ" TO PUBLIC;
GRANT ALL ON DATABASE "QSMQ" TO postgres;
GRANT CREATE ON DATABASE "QSMQ" TO qliksenserepository;
NOTE: This can be performed while all other services are running, since it does not affect any other component in the Repository. Remote database services must be running during the upgrade process.