article Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _ in Official Support Articles

Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _

Anonymous — Wed, 15 Feb 2023 11:33:38 GMT

Upgrading Qlik Sense running a standalone/remote PostgreSQL Database or a PostgreSQL Database upgraded with the Qlik PostgreSQL Installer fails with the following error:

Setup Requirements

The following information has been collected from your system:

This version of Qlik Sense requires a 'SenseServices' database for multi cloud capabilities. Ensure that you have created a 'SenseService' database in your cluster before upgrading. For more information see Installing and configuring PostgreSQL.

Resolution

Verify that the database is started.

For stand-alone PostgreSQL installations, the database needs to run for the installer to be able to verify its requirements.

The requirement extends to Qlik Sense systems in which the PostgreSQL database has been upgraded with the Qlik PostgreSQL Installer.
Verify that all required databases are created before the upgrade.

See your version of Qlik Sense to verify what databases are required: Databases.

For detailed instructions on how to install and configure PostgreSQL, see: Installing and Configuring PostgreSQL

For an example of the above with the Licenses database, 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
Is traffic encryption enabled?

Looking at the Connection String using the Qlik Sense Utility tool (stored under C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil) verify if the parameter Ssl Mode=Require is included.

The Qlik Sense installer cannot use SSL encryption for establishing connection to PostgreSQL. When SSL encryption is enabled, the installer does not recognize any already installed PostgreSQL databases, and as a consequence, installation cannot be completed.

Workaround: Temporarily disable traffic encryption for the connection to the Qlik Sense database(s) prior to upgrading Qlik Sense Enterprise. See Qlik Sense - Setting up database traffic encryption

Reference: Database traffic encryption
Is FIPS enabled?

The next most common scenario is that the server which Qlik Sense is installed is configured to enforce FIPS policy. Due to a dependency in the install, additional steps are needed to allow the installer to operate in a FIPS environment. Reference article Unable to install Qlik Sense to a remote PostgreSQL database with FIPS enabled for more details on the resolution for this variant of blockers.
Incorrect Database ownership

A previous upgrade failure or inconsistency can cause the QMSQ database ownership to be incorrect. Since the Qlik Sense installer tries to validate the connection to all underlying databases, a failure to do so against any of them will result in a failure to upgrade.

For instructions on how to resolve this issue, see Qlik Sense Upgrade fails: Initializing 'QSMQ' database.

Re: Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _

john_oll — Tue, 18 Jul 2023 12:56:58 GMT

Are there known cases of this happening after updating to PostGre 14 with the Qlik SQL updater and then doing an update??
We just encountered this 😞

Re: Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _

Sonja_Bauernfeind — Thu, 20 Jul 2023 11:14:44 GMT

Hello @john_oll

An update:

Upgrading Qlik Sense after upgrading PostgreSQL with the QPI tool fails with:

This version of Qlik Sense requires a 'SenseServices' database for multi cloud capabilities. Ensure that you have created a 'SenseService' database in your cluster before upgrading. For more information see Installing and configuring PostgreSQL.

To resolve this, start the postgresql-x64-XX service.

does the solution in this section help?

Re: Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _

john_oll — Fri, 21 Jul 2023 07:20:03 GMT

Agreed.
The error happened due to manually stopping the repository database before starting the installation, which you should not do.

Re: Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _

Giovanni_Civardi — Wed, 08 May 2024 10:51:10 GMT

"Workaround: Temporarily disable traffic encryption for the connection to the Qlik Sense database(s) prior to upgrading Qlik Sense Enterprise. See Qlik Sense - Setting up database traffic encryption "

@Sonja_Bauernfeind Can you please detail the procedure for disabling SSL encryption?

Thank you.