When using a standalone Database for Qlik Sense you might see:
This version of Qlik Sense requires a 'Licenses' database for license capabilities. Ensure that you have created a 'Licenses' database in your cluster before upgrading. Is displayed when trying to upgrade Qlik Sense. This is a setup requirement.
Environment:
- Qlik Sense Enterprise, April 2019 and later with Standalone Remote PostgreSQL database
Cause
The standalone database does not auto-generate this database under the installation.
Resolution
The license database has to be manually created:
See Installing and Configuring PostgreSQL
An example with a script when installing a new server in Azure can be found on the Installing and configuring PostgreSQL on Azure.
Create in the pgAdmin GUI:
- Right-click in Databases > Create > Database
- Name it 'Licenses'
- Set the owner to qsrepository
Create in pgAdmin using script commands:
Connect to the DB with e.g. PG Admin and run the following script:
CREATE DATABASE "Licenses" ENCODING = 'UTF8';
Followed by the setup for the newly created Licenses Database:
GRANT TEMPORARY, CONNECT ON DATABASE "Licenses" TO PUBLIC;
GRANT ALL ON DATABASE "Licenses" TO postgres;
GRANT CREATE ON DATABASE "Licenses" TO qliksenserepository;
For information about PGAdmin, see Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti...