Qlik Sense Repository PostgreSQL large files

[AshutoshBhumkar]

Hi,

We have large amount of files being generated from last few days on below path

C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6\base\16386

This is occupying server's C drive space.

What is the reason ? Any solution for this ?

@Michael_Tarallo , @rohitk1609

Regards,

Ashutosh

[ganapati_h]

@AshutoshBhumkar what is log level set to?

[Levi_Turner]

That path contains binary files for the tables in the underlying database(s) that Qlik Sense uses. You're welcome to use the attached app for a clearer representation of things. That will drill down to the database and/or tables.

[rohitk1609]

Log level set to default in QMC

Thanks,
Rohit

[AshutoshBhumkar · Accepted solution]

Hello,
Thanks for your response. We solved this query with Qlik Support team.
We disabled database logging which was responsible to create those large files under mentioned folder.

Regards,
Ashutosh.

[rohitk1609]

So if I got you correctly, you have off logging from all services i.e. engine, scheduler .. of Logging and Tracing section but if you disabled it what will you feed to Governance app ?

[AshutoshBhumkar]

File Logs.
We changed 'SET db_v_file_override' variable to 1;

[rohitk1609]

Hi Ashutosh,

If I understand correct, there are two ways to Qlik stores logs, one in centralized DB QLOGS and other is text files which are in log folder and archived logs folder and generated on events in Qlik. Now you are saying you have disabled the logs for all services in QMC, so it is affecting your QLOGS centralized DB. MY Question is: if I change settings in QMC, won't it affect the log text files data too ?
Now lets say I set 'SET db_v_file_override' variable to 1; in governance apps so these apps will pick data from logs text files which are in log folder and archived logs folder and run smoothly.

If I am right, we have 5 governance apps, how can i set 'SET db_v_file_override' variable to 1 in each apps ?
how to test it ?
third, Is there any way to disable centralize logging by one step rather then go to QMC , then services then disabled trace drop down?

Thanks,
Rohit

[AshutoshBhumkar]

Hi Rohith,
1. We didn't change anything in QMC. As discussed with Support team, we disabled DB logging using following Qlik help link, hence no effect on file data logs.
Qlik help : https://help.qlik.com/en-US/sense/February2018/Subsystems/PlanningQlikSenseDeployments/Content/Deplo...

2. One of Governance App, 'Operations Monitor' by default checks for File Logs. Another one 'Reload Monitor' checks for DB logs first, If not found then goes for Files logs.
(As I understood from Governance Apps script).

3. Refer Qlik help link from point 1 to disable Database Logging on server.

Thanks,
Ashutosh

[rohitk1609]

Thanks for such important notes:
Can you clear few points
1. Qlik.Logging.Service.exe update – archive_age_in_days 15 –purge_age_in_days 30 , command archive QLogs DB in every 15 days and cleanse the DB in every 30 days ?
2. Qlik.Logging.Service.exe update --database_logging off. my only question here on this point is, we have logs file in Archived folder in fileshare and QLog DB, why do we need QLogs DB,what is its use if governance apps can run without QLogs DB ?
3. Qlik.Logging.Service.exe update --maximum_db_size_in_gb n. If n is a value less than two (2), the enforcement functionality is disabled,what is the meaning of
enforcement functionality, lets say I put 2 on place of n in command so it means my QLogs DB will never be more than 2 GB ?

regards ,
rohit