article Postgres database moved to new host but some Qlik Sense is still accessing the old database in Official Support Articles

Postgres database moved to new host but some Qlik Sense is still accessing the old database

Sebastian_Linser — Wed, 10 May 2023 14:34:15 GMT

After following the Qlik article Configure Qlik Sense to use a dedicated PostgreSQL server and update the connection string to point to the new host, Qlik Sense appears to work fine at first. However, access by the Qlik Sense Service account to the old host is registered or errors are found in the logs similar to what is found in the example below:

In the AppDistributionService trace logs:

307308 20210104T170444.859+01:00 INFO QLIKSERVER 70 DOMAIN\serviceaccountname Retry attempt: 10/10. Previous result: "No such host is known". 304796
307309 20210104T170451.812+01:00 ERROR QLIKSERVER 70 DOMAIN\serviceaccountname Error processing message queue notifications. System.Net.Sockets.SocketException (11001): No such host is known
at System.Net.Dns.HostResolutionEndHelper(IAsyncResult asyncResult)

Resolution

There are a few new services starting on the September 2019 release of Qlik Sense which did not exist in June 2018. Some of them were also removed/replaced on the new release.

Option 1 (recommended): Updating the files using PowerShell:

Stop all the Qlik Sense services
Open a PowerShell command prompt in administrator mode and then, either run the following:

# Set the Installation Directory for Qlik Sense $installDir = 'C:\Program Files\Qlik\Sense\' #change that to the new database server $newdatabasehostname='new database server' # Specify the new password for the qliksenserepository account $password = 'MyNewPassword' # Find all Configure-Service.ps1 scripts in the installation directory and execute them $files = Get-ChildItem -Path $installDir -Include Configure-Service.ps1 -Recurse foreach ($file in $files) { $ScriptToRun=$($file.FullName) &$ScriptToRun $newdatabasehostname 4432 qliksenserepository $password -postgresHome 'D:\Qlik\Sense\Repository\PostgreSQL\12.5' }

In case of having a custom path Qlik Sense installation, change the last line to:

&$ScriptToRun $newdatabasehostname 4432 qliksenserepository $password -postgresHome 'D:\Qlik\Sense\Repository\PostgreSQL\12.5' }

Where "D:\Qlik\Sense" is Qlik Sense installed folder and where "12.5" is the Postgres version installed.

Option 2: Manually update each file

Change to the following directories with the commands below before running the Configure-Service.ps1 command listed further below.

Repeat the step for every subfolder mentioned below.

Note: If you previously upgraded you may find folders in your system which are not listed here. Ignore them. No steps need to be taken.

Qlik Sense February 2021 and later.

Locate Configure-Service.ps1 in C:\program files\Qlik\Sense\.

It lists all services that need to be changed.

Qlik Sense June 2018:

cd 'C:\Program Files\Qlik\Sense\AppDistributionService'
cd 'C:\Program Files\Qlik\Sense\EntitlementProvisioningService'
cd 'C:\Program Files\Qlik\Sense\HybridDeploymentService'
cd 'C:\Program Files\Qlik\Sense\QseEventProcessor'

Qlik Sense September 2019:

cd 'C:\Program Files\Qlik\Sense\Licenses'
cd 'C:\Program Files\Qlik\Sense\NotifierService\install'
cd 'C:\Program Files\Qlik\Sense\AppDistributionService'
cd 'C:\Program Files\Qlik\Sense\HybridDeploymentService'
cd 'C:\Program Files\Qlik\Sense\MobilityRegistrarService\install'
cd 'C:\Program Files\Qlik\Sense\PrecedentsService\install'

Qlik Sense November 2020:

cd 'C:\Program Files\Qlik\Sense\NLAppSearch\install'

Example:

For AppDistributionService...

PS C:\> cd 'C:\Program Files\Qlik\Sense\AppDistributionService'
PS C:\Program Files\Qlik\Sense\AppDistributionService> .\Configure-Service.ps1 DatabaseHost Databaseport DatabaseUser DatabasePassword

e.g. .\Configure-Service.ps1 newdatabasehostname 4432 qliksenserepository Password123!

The answer will look similar to this:

AppDistributionService configuration started.
WARNING: Skiping the database initialization. No superuser or password specified.
Reading the settings file.
Saving the modified settings.
Exporting the copy of the invocation parameters.
AppDistributionService configuration successful.

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

aashok — Fri, 16 Sep 2022 07:32:43 GMT

Hi ,

My folder is missing with

cd 'C:\Program Files\Qlik\Sense\QseEventProcessor'.

what could be the reason.

I am upgrading from Nov 2020 to May 2022.

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Sonja_Bauernfeind — Thu, 22 Sep 2022 07:45:45 GMT

Hello @aashok

May 2022 does not have this folder any more, so it missing is expected.

All the best,
Sonja

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

aashok — Tue, 27 Sep 2022 13:37:13 GMT

@Sonja_Bauernfeind Thank you. I managed to resolve the issue.

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Lokeshb31 — Wed, 19 Oct 2022 17:06:22 GMT

One question - why are we mentioning localhost if DB is installed on other host? -

.\Configure-Service.ps1 localhost 4432 qliksenserepository Password123!

It should be .\Configure-Service.ps1 <newDBhost> <newDBport> qliksenserepository <newpassword>

Right? I am getting confused here, please help.

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Sonja_Bauernfeind — Mon, 24 Oct 2022 08:50:23 GMT

Hello @Lokeshb31

Please log a support ticket for this query. The work required to troubleshoot this with you is beyond what we can provide in an article.

All the best,
Sonja

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Sebastian_Linser — Thu, 01 Dec 2022 16:13:17 GMT

@Lokeshb31 changed, i also added it in the script above as variable so it can be set up front.

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Tool_Tip — Thu, 12 Dec 2024 06:36:38 GMT

Dear sebastian/sonja,

We have updgraded postgres from bundled 12 to unbundled 14 using QPI tool. We followed everysteps in "https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-postgresql-using-qpi.htm"

Everything is running fine without error now we are concerned about if our qliksense is connected to correct postgres as its path changed from
C:\Program Files\Qlik\Sense\Repository to C:\Program Files\PostgreSQL\14 on same server.

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Sebastian_Linser — Thu, 12 Dec 2024 21:42:28 GMT

@Tool_Tip please contact qlik support and we will have a look together

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Tool_Tip — Tue, 24 Dec 2024 10:30:47 GMT

Dear Sebastian,

Is it free service or paid?

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Sonja_Bauernfeind — Fri, 27 Dec 2024 11:09:06 GMT

Hello @Tool_Tip

A support case was created to help you get access to the support portal.

All the best,
Sonja

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Tool_Tip — Sun, 29 Dec 2024 03:31:32 GMT

Dear Sonja,

I don't need support case. You can cancel it.

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

federicotedesco — Wed, 30 Jul 2025 14:35:18 GMT

Hello Support,

If PostgreSQL is hosted externally (not embedded within the Qlik Sense environment), the

-postgresHome 'D:\Qlik\Sense\Repository\PostgreSQL\12.5'

parameter can be omitted when running the Configure-Service.ps1 script?

Thanks

Federico

article Postgres database moved to new host but some Qlik Sense is still accessing the old database in Official Support Articles

Postgres database moved to new host but some Qlik Sense is still accessing the old database

Resolution

Option 1 (recommended): Updating the files using PowerShell:

Option 2: Manually update each file

Related Content:

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database

Re: Postgres database moved to new host but some Qlik Sense is still accessing the old database