Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AarizShah
Partner - Contributor III
Partner - Contributor III

enable centralized logging for sense system performance analyzer

Hi,

I am trying to use the sense system performance analyzer. It's requirement is to enabe the centralized logging. I tried reading few articles. One of the articles asks me to go to C:\Program Files\Qlik\Sense\Logging\ in QMC or centralized node

However, the logging folder does not even exist there. Is there any other way to enable centralized logging so that we can start using the sense system performance analyzer

 

Regards

Labels (3)
13 Replies
rzenere_avvale
Partner - Specialist II
Partner - Specialist II

Goodmorning @AarizShah ,

are you following this kb article? https://support.qlik.com/articles/000059077
The mentioned folder C:\Program Files\Qlik\Sense is the default folder for installing QS. If you have installed QS in a different folder you should check for <Disk>:\<QS installation folder>\Logging.

I hope this helps,
Riccardo

AarizShah
Partner - Contributor III
Partner - Contributor III
Author

Hi @rzenere_avvale ,

Many thanks for the reply. You were right. It was at another location. However, when I try to execute the command

 Qlik.Logging.Service.exe validate, I get an error Failed to Validate logging database

Do you have any suggestions on how to fix this?

Regards

Aariz

rzenere_avvale
Partner - Specialist II
Partner - Specialist II

Hm, could you check another could of things?

  1. did you run the command from an elevated prompt (so with Administrator rights)?
  2. is the Qlik Sense Logging Service running? Usually I set it to 'Manual' run when I don't have the centralized logging configured

Riccardo

AarizShah
Partner - Contributor III
Partner - Contributor III
Author

You are actually right. The service was stopped and set to manual. However, it is not starting. Windows event log viewer shows this error

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

FATAL: password authentication failed for user "senselog_writer"
DETAIL: Role "qlogs_writer" does not exist.
Connection matched pg_hba.conf line 82: "host all all ::1/128 md5"

AarizShah
Partner - Contributor III
Partner - Contributor III
Author

Where can I set this user role, password etc? The user that starts the service is a different one than mentioned here
rzenere_avvale
Partner - Specialist II
Partner - Specialist II

I'm not sure why it is reported 'senselog_writer'. 'qlogs_writer' is a user that exists only in the repository, just like 'postgres' or 'qliksenserepository'.
Did you change anything in the file C:\ProgramData\Qlik\Sense\Log\QlikCentralizedLogging.config ?
Also, on which version of QS are you working?
AarizShah
Partner - Contributor III
Partner - Contributor III
Author

I only changed one entry in the QlikCentralizedLogging to enable CentralizedLoggingLogEnabled
rzenere_avvale
Partner - Specialist II
Partner - Specialist II

Ok... So I'm still not sure why you get that 'qsenselog_writer'. Could you check the file C:\ProgramData\Qlik\Sense\Log\QlikCentralizedLogging.config and look if, for some reasons, it is mentioned qsenselog_writer?
Also, another question that I should have asked you before: in your environment has ever been configured the centralized logging? The kb article I mentioned earlier is used to enable/disable the centralized logging when you have already configured it. If during your installation you haven't selected the possibility to use it, then the QLogs database (which is the one used by this configuration) hasn't been created and neither the users. In this case, the kb article to follow should be this: https://support.qlik.com/articles/Basic/How-to-set-up-the-Qlik-Sense-Logging-Service?articleId=How-t...
AarizShah
Partner - Contributor III
Partner - Contributor III
Author

Yes, it was never configured. This is the first time I have to configure it. regarding the error, I pasted a wrong event. For the logging error, the correct event error is

FATAL:  password authentication failed for user "qlogs_reader"
DETAIL:  Role "qlogs_reader" does not exist.
 Connection matched pg_hba.conf line 82: "host    all             all             ::1/128                 md5"