Knowledge

[Sebastian_Linser]

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...