Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AshutoshBhumkar
Partner
Partner

Qlik Sense Repository PostgreSQL large files

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

12 Replies
ganapati_h
Partner
Partner

@AshutoshBhumkar what is log level set to?

Levi_Turner
Employee
Employee

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
Specialist III
Specialist III

Log level set to default in QMC

 

Thanks,
Rohit

AshutoshBhumkar
Partner
Partner
Author

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
Specialist III
Specialist III

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
Partner
Partner
Author

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

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
Partner
Partner
Author

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
Specialist III
Specialist III

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