Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Apr 19, 2023 7:40:47 AM
Jan 9, 2019 6:07:13 PM
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.
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
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;
Qliksenserepository password error: the authentication password fails for user "qliksenserepository"