Qlik Community

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
CASE PORTAL: Inability to view all organizations' cases. We are investigating. Thank you for being so patient.

Qliksenserepository password error and an error contacting the license service

cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastian_Linser

Qliksenserepository password error and an error contacting the license service

After changing the Qlik Sense DBserviceuser password (see How-to reset forgotten PostgreSQL password in Qlik Sense), the Qlik Sense log files log password errors for qliksenserepository user.

The C:\ProgramData\Qlik\Sense\Log\Repository\Trace\*_System_Repository log will have a WARN message with this information:

There was an error contacting the license service. Keep retrying... (1 failed requests) GET /v1/licenses/overview StatusCode: InternalServerError Response: .    Could not connect to the license service

 
The C:\Program File\Qlik\Sense\License log may register an Error message with this information:

*failed to create service: pq: LDAP authentication failed for user \"user\"*


The Qlik Sense C:\ProgramData\Qlik\Sense\Log\AppDistributionService\Trace\*_AppDistributionService_* logs read:

Failure creating schema. 28P01: the authentication password fails for user "qliksenserepository"

Waiting for Message Queue to start. Error 28P01: the authentication password fails for user "qliksenserepository"

Retry attempt: 1/10. Previous result: 28P01: the authentication password fails for user "qliksenserepository"


The Windows Event log reads:

The description for Event ID '0' in Source 'PostgreSQL' cannot be found.  The local computer may not have the necessary registry information or message DLL files to display the message, or you may not have permission to access them.  The following information is part of the event:
FATAL:  the authentication password fails for user "qliksenserepository"
DETAIL:  The password does not match for the user«qliksenserepository».
   The connection coincided with the line 80 de pg_hba.conf: «host    all             all             127.0.0.1/32            md5»



Environment:

  • Qlik Sense Enterprise on Windows, all versions

 

The old password is still cached and needs to be updated.

C:\ProgramData\Qlik\Sense\AppDistributionService\config.params
C:\ProgramData\Qlik\Sense\QseEventProcessor\config.params
C:\ProgramData\Qlik\Sense\HybridDeploymentService\config.params
C:\ProgramData\Qlik\Sense\Licenses\config.params

 

Resolution:


After testing with qliksenseUtil that the repository.exe.config had the right password and configuration, but the errors are still logged. 

This can be caused by .params files cashing the old password, still encrypted. These files need to be manually updated. 

Look for the below files in your installation. If a file in the list does not exist, it is version dependent. Skip it.

C:\ProgramData\Qlik\Sense\AppDistributionService\config.params
C:\ProgramData\Qlik\Sense\QseEventProcessor\config.params
C:\ProgramData\Qlik\Sense\HybridDeploymentService\config.params
C:\ProgramData\Qlik\Sense\Licenses\config.params

To update the password in these files, take a backup of the param files below and open an (run as administrator) elevated Powershell command prompt. It may be necessary to change temporarily the ExecutionPolicy.  If so, either following these steps below or scroll down for two other alternatives.

Check the current Policy setup: Get-ExecutionPolicy -list

If restricted run: Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope LocalMachine

Type 'yes' and Enter

After running the commands below, set it back to restricted:

Set-ExecutionPolicy -ExecutionPolicy Restricted -Scope LocalMachine

Type 'yes' and Enter.

Run the following commands:

cd "C:\Program Files\Qlik\Sense\QseEventProcessor"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourNewPassword

cd "C:\Program Files\Qlik\Sense\AppDistributionService"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourNewPassword

cd "C:\Program Files\Qlik\Sense\HybridDeploymentService" 
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourNewPassword cd "C:\Program Files\Qlik\Sense\Licenses"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourNewPassword

cd "C:\Program Files\Qlik\Sense\NotifierService"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourNewPassword

cd "C:\Program Files\Qlik\Sense\MobilityRegistrarService"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourNewPassword

cd "C:\Program Files\Qlik\Sense\PrecedenceService"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourNewPassword

After each execution of Configure-Service.ps1 an output will be written that the service has been configured, unless it does not apply to the current version or deployment of Qlik Sense.

Example:

Reading the settings file.
Saving the modified settings.
Exporting the copy of the invocation parameters.
AppDistributionService configuration successful.

 

Alternative:

The alternative to find all the PowerShell files programmatically:

# 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
}

 

 

Labels (3)
Comments
Rakesh_Basappa
Support
Support
Christopher-Reiter

Regarding the section that uses -plain-password in the services.conf file - is it possible to re-encrypt that after the change of the password?  It is not common to allow plain passwords in configuration files.

 

Sebastian_Linser

@Christopher-Reiter 

Hello,

yes its possible to re encrypt the password by taking  -plain-password of in the services.conf 

and then just to rerun the configure-service.ps1 scripts for all the microservices which will save the passwords encoded again. Similar to this article here https://community.qlik.com/t5/Knowledge/Postgres-database-moved-to-new-host-but-some-Qlik-Sense-is-s...

 

best regards

Sebastian

Version history
Last update:
‎2021-10-27 08:16 AM
Updated by: