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
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

How to set up the Qlik Sense Logging Service

Andrew_Delaney
Support
Support

How to set up the Qlik Sense Logging Service

Qlik Sense Logging Service can be setup during or after installation. The simplest approach is to simply use the existing PostgreSQL software installed with Qlik Sense when the database is hosted on the central node. However, a dedicated PostgreSQL server may also be used.

If it has been enabled during installation it can also simply be disabled. See How To Enable/Disable Centralized Logging Mode

Please note that by enabling Centralized Logging Qlik Sense will still log events to log files by default. More info under Qlik Logging Service

Environment:

  • Qlik Sense Enterprise, September 2017 and later

 

Resolution:


In order to configure Centralized Logging after an upgrade, run the following commands:

Step 1:

cd "C:\Program Files\Qlik\Sense\Logging\"

Step 2: 

.\Qlik.Logging.Service.exe setup --hostname FQDNofTheDatabase --port 4432 --postgres_user postgres --postgres_pswd PostgresUserPassword --writer_pswd IntendedWritePassword --reader_pswd ReaderWritePassword

 Step 3:

.\Qlik.Logging.Service.exe update --hostname FQDNofTheDatabase  --port 4432 --postgres_user postgres --postgres_pswd PostgresUserPassword --writer_pswd IntendedWritePassword --reader_pswd ReaderWritePassword --database_logging on


Note: If your password for any of these accounts has special characters, you may need to wrap the password in double quotes. Example:
 --postgres_pswd "p@$$\/\/0rd"Strictly speaking the special characters for Windows command line are <, >, |, &, and ^. But wrapping the passwords in double quotes will eliminate any confusion here.
Note: This was written assuming a default installation path. You may need to adjust the path from "C:\Program Files\Qlik\Sense\Logging"\ to your installation path.
Note: The FQDN of your database is the Fully Qualified Domain Name such as servername.domain

There are additional configuration options available for the logging service. You may review the list by typing in the command line qlik.Logging.Service.exe /?
Among useful options the below is listed:
--archive_age_in_days n  After n days, logs will be moved from the main tables to archive tables in the database, to help keep the log process performant
--purge_age_in_days n After n days, logs in the Archived table will be permanently deleted to prevent the database from growing too large
--maximum_db_size_in_gb n Log entries will be automatically deleted when the database reached n GB in size, starting with entries in the archived table, then if necessary logs in the main tables as well.

Also see additional information under Qlik Help site under Qlik Logging Service

Labels (2)
Version history
Revision #:
3 of 3
Last update:
‎2020-08-24 08:20 AM
Updated by:
 
Contributors