Skip to main content

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

No ratings
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

Last Update:

May 2, 2021 2:11:15 AM

Updated By:

Ranganath_DR

Created date:

Aug 29, 2019 7:51:10 AM

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: