Cannot change the qliksenserepository password for microservices of the service dispatcher: The system cannot find the file specified

Sebastian_Linser — Wed, 13 Nov 2024 14:25:28 GMT

While updating the qliksenserepository user with any of the Configure-Service.ps1 scripts, you may encounter the following error:

Invoke-Query : Exception calling "Start" with "0" argument(s): "The system cannot find the file specified"
At C:\Program Fi 1es\Qlik\Sense\Mobi1i tyRegistrarService\install\instal1-uti1s\Postgres.psl:56 char :10
+ $ret = Invoke-Query $command
+ Categorylnfo : NotSpecified: (:) [Invoke-Query], MethodlnvocationException
+ FullyQualifiedErrorld : Win32Exception,Invoke-Query

Cause

Some Power-shell scripts have not been updated for the new default value of the Database home.

Different versions of Qlik Sense Enterprise for Windows come with their own bundled PostgreSQL version.

Examples: Qlik Sense Enterprise for Windows from May 2021 to May 2023 will install PostgreSQL 12.5, while previous releases used PostgreSQL 9.6 as a default during a new install. Similarly, from Qlik Sense Enterprise on Windows August 2023 onwards, Qlik pre-installs PostgreSQL 14.8 as the default database. For more details on the default, see the System Requirements for your respective version.

When you upgrade from an earlier release you will keep 9.6 or 12.5 and you should not have the issue.

This leads to issues with the following line:

Variation One:

[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\9.6",

Variation Two:

[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",

Environment

Qlik Sense Enterprise on Windows

Resolution

Apply the actions in this solution on all nodes.

Depending on your version of Qlik Sense Enterprise on Windows different corrections will be needed.

Search for all *.ps1 scripts in C:\Program Files\Qlik\Sense

For example, you can use Notepad++, utilizing its Search > Find in Files option:

Your directory may vary if you have used an alternative folder.
Find out what version of PostgreSQL binaries you have installed with Qlik Sense Enterprise on Windows:
1. Open a Windows File Explorer and browse to C:\Program Files\Qlik\Sense\Repository\PostgreSQL
2. You will find the PostgreSQL binaries folder
After identifying your PostgreSQL binaries version, replace the old path reference in the Configure-Service.ps1 files with the new version.

Examples:

replace

$senseInstallPath\Repository\PostgreSQL\9.6

with

$senseInstallPath\Repository\PostgreSQL\12.5

or

replace

$senseInstallPath\Repository\PostgreSQL\12.5

with

$senseInstallPath\Repository\PostgreSQL\14
Repeat this action on the path C:\Programdata\Qlik and update C:\Programdata\Qlik\Sense\QSMQ\scripts\SetupDatabase.ps1

This is an example list of .ps1 files needing to be edited in the Qlik Sense Enterprise for Windows August 2023 version:

C:\Programdata\Qlik\Sense\QSMQ\scripts\SetupDatabase.ps1

Line 12: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\AppDistributionService\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\DataPrepService\install\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\HybridDeploymentService\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\Licenses\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\MobilityRegistrarService\install\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\NLAppSearch\install\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\NLBroker\install\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\NotifierService\install\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",
C:\Program Files\Qlik\Sense\PrecedentsService\install\Configure-Service.ps1

Line 13: [string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5",

Re: Cannot change the qliksenserepository password for microservices of the service dispatcher: The system cannot find the file specified

Mahamed_Qlik — Mon, 23 Dec 2024 04:24:11 GMT

Dear

After upgrading postgres from 12 to 14, our Qliksense and postgres new path are:

C:\Program Files\Qlik\Sense &

C:\Program Files\PostgreSQL\14

So how can write line 13 ? what will be [string]$postgresHome value?

Re: Cannot change the qliksenserepository password for microservices of the service dispatcher: The system cannot find the file specified

Tool_Tip — Sun, 16 Feb 2025 09:28:14 GMT

Dear

We have successfully upgraded postgres from 12.5 to 14.

But I am unable to see below folder path as you mentioned in above steps:

Thers is no postgres folder available :

article Cannot change the qliksenserepository password for microservices of the service dispatcher: The system cannot find the file specified in Official Support Articles

Cannot change the qliksenserepository password for microservices of the service dispatcher: The system cannot find the file specified

Cause

Environment

Resolution

Re: Cannot change the qliksenserepository password for microservices of the service dispatcher: The system cannot find the file specified

Re: Cannot change the qliksenserepository password for microservices of the service dispatcher: The system cannot find the file specified