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:
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\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'
cd 'C:\Program Files\Qlik\Sense\NLAppSearch\install'
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.
