Qlik Community

Ask a Question

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
Talk to Experts Tuesday: Live chat Aug. 24th 10 AM ET: Bring your Qlik Gold Client questions REGISTER TODAY

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

Sebastian_Linser

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


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)

...

Environment:

  • Qlik Sense Enterprise on Windows, June 2018 and later

 

Cause:


Additional configuration steps are needed.

 

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.


These files need to be updated as well when moving the postgreSQL database:

Qlik Sense Enterprise June 2018:

C:\Program Files\Qlik\Sense\AppDistributionService\appsettings.json
C:\Program Files\Qlik\Sense\EntitlementProvisioningService\appsettings.json
C:\Program Files\Qlik\Sense\HybridDeploymentService\appsettings.json
C:\Program Files\Qlik\Sense\QseEventProcessor\appsettings.json

 
Qlik Sense Enterprise September 2019:

C:\Program Files\Qlik\Sense\Licenses\appsettings.json
C:\Program Files\Qlik\Sense\NotifierService\appsettings.json
C:\Program Files\Qlik\AppDistributionService\appsettings.json
C:\Program Files\Qlik\Sense\HybridDeploymentService\appsettings.json
C:\Program Files\Qlik\Sense\MobilityRegistrarService\appsettings.json
C:\Program Files\Qlik\Sense\PrecedentsService\appsettings.json
 
Qlik Sense Enterprise November 2020:
 
In addition to the files mentioned for September 2019:
C:\Program Files\Qlik\Sense\NLAppSearch\install\appsettings.json

 


Updating the files using PowerShell:

1.  Stop all the Qlik Sense services
2. 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\'
# Specify the new password for the qliksenserepository account
$password = 'MyNewPassword'
$files = Get-ChildItem -Path $installDir -Include Configure-Service.ps1 -Recurse
foreach ($file in $files) {
    $ScriptToRun=$($file.FullName)
    &$ScriptToRun localhost 4432 qliksenserepository $password
}


... or 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, if you have a folder which is not on your system, please ignore it. If you are in a newer version while reading this article, just search for "Configure-Service.ps1" in C:\program files\Qlik\Sense\ and you will find all the other services you might need to change.


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:
 
In addition to the ones above for September 2019:
cd 'C:\Program Files\Qlik\Sense\NLAppSearch\install'

 

e.g:

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

 


Related Content:

Labels (1)
Version history
Revision #:
6 of 6
Last update:
2 weeks ago
Updated by: