Qlik Sense Enterprise on Windows CREATE schema and AUTHORIZATION errors when upgrading

[Zareh_T]

The following error may be seen when upgrading or Qlik Sense Enterprise on Windows:

Error executing database command "CREATE SCHEMA "precedents_service" AUTHORIZATION  Error

"precedents_service" AUTHORIZATION "qliksenserepository"": ERROR: schema

See How To Collect Qlik Sense Installation Log File on collecting the installer log files.

Resolution:

Permissions for the database is not set correctly to user qliksenserepository.

Note: Qlik does NOT support the 3^rd party software mentioned and used in this documentation. Please use them at your own discretion and, if concerned, contact the proper IT team within your company to verify the ability to use non-Qlik related software in the environment.

This script below will need to be run and will ensure that qliksenserepository ownership is correctly applied before running the Qlik Sense installer to perform the upgrade

1. Obtain a precautionary database backup. See How to backup PostgreSQL database in Qlik Sense
2. Connect to the Qlik Sense Repository Database using pgAdmin. See Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti...
3. Connect to the QSR
4. With QSR selected, open the Query Tool
5. Run the below

   ALTER DATABASE "QSR" OWNER TO qliksenserepository; --sets qliksenserepository as owner of the QSR database
   ALTER DATABASE "SenseServices" OWNER TO qliksenserepository; --sets qliksenserepository as owner of the SenseServices database
   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;
   GRANT TEMPORARY, CONNECT ON DATABASE "SenseServices" TO PUBLIC;
   GRANT ALL ON DATABASE "SenseServices" TO postgres;
   GRANT CREATE ON DATABASE "SenseServices" TO qliksenserepository;

6. Run the Qlik Sense installer to perform the upgrade

Related Content:

Qliksenserepository password error: the authentication password fails for user "qliksenserepository"