Knowledge

[AdamSawyer]

An installation or upgrade of Qlik Sense, may fail with "The Centralized logging setup failed" or "Could not validate database user".

Other possible errors include:

Windows Event log:

The following information was included with the event: LOG: invalid value for parameter "lc_time": 
The following information was included with the event: LOG: invalid value for parameter "lc_numeric": 

Event Log Details:

FATAL: password authentication failed for user "qliksenserepository"
DETAIL: Password does not match for user "qliksenserepository"
Connection matched pg_hba.conf line 80: "host all all 127.0.0.1/32 md5"

 

Environment:

• Qlik Sense Enterprise, all versions

Resolution:

Special characters:

• Special character sets in the Operating System region settings prevents the Postgre DB to be installed. Remove additional regions from the local system account in the registry. This article describes how to modify the System locale for Windows: How to change Windows regional settings and make them work in Qlik Sense June and September 2017 ver...

The user qliksenserepositry was changed during the initial install.

• To proceed past the error, the correct name will need to be used.
• Once the install is complete, the following script will need to be run to correct the issue: Qlik Sense repository permission errors related to precedents_service

Incorrect password:

• The password for the qliksenserepository user was entered incorrectly or forgotten. See article How-to reset forgotten PostgreSQL password in Qlik Sense

Adjust IP Address setup:

• During the setup is an Advanced Settings for the IP Addresses. 
• If these are being changed from default IPv6 and IPv4 -- to allow listening for RIM nodes, then add     ::0/0, 0.0.0.0/0