Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
CASE PORTAL: Inability to view all organizations' cases. We are investigating. Thank you for being so patient.

Qlik Sense Upgrade fails: Initializing 'QSMQ' database

cancel
Showing results for 
Search instead for 
Did you mean: 
Mario_Petre
Support
Support

Qlik Sense Upgrade fails: Initializing 'QSMQ' database

Environment:

 

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.
 

Resolution

 
  1. Stop the install
  2. Download the latest version of PGAdmin from www.pgadmin.org
  3. Follow instructions in the following article to connect to the Database: Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense
  4. Select the QSMQ database and expand it (to make sure the connection is established)
  5. Go to Tools -> Query 
  6. 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. 
  7. Start the install again

 

Labels (1)
Version history
Last update:
‎2021-06-23 09:55 AM
Updated by:
Contributors