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, failing to do so against any of them will fail 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.