Logging issues when trying clean up the database
Possible cause
The size of the
Proposed action
Shut off database logging to clean up the storage problem.
Warning: This solution should only be used as a last resort. All purges are permanent.
Do the following:
-
In Windows, open Services.
-
Stop the following services:
- Qlik Sense Engine Service
- Qlik Sense Proxy Service
- Qlik Sense Scheduler Service
- Qlik Sense Repository Service
-
Open a command prompt with administrator privileges.
-
Go to C:\Program Files\Qlik\Sense\Logging.
-
Run Qlik.Logging.Service.exe archive --cutoff_in_hours X (where X is the number of hours).
-
Run Qlik.Logging.Service.exe purge --cutoff_in_hours X (where X is the number of hours).
-
Restart the Qlik Logging Service.
-
Verify the reclaimed data storage.
-
Start all stopped Qlik Sense services, beginning with the Qlik Sense Repository Service.
Thanks for helping us improve!