Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld online is next week! REGISTER NOW

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastian_Linser

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

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.
 

system requirements not met license database required.png



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

Labels (1)
Version history
Last update:
‎2021-05-02 02:11 AM
Updated by: