Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Zareh_T
Support
Support

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

Last Update:

Apr 19, 2023 7:40:47 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jan 9, 2019 6:07:13 PM

Attachments

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 3rd 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" 

Labels (1)
Contributors
Version history
Last update:
‎2023-04-19 07:40 AM
Updated by: