Logging issues when trying clean up the database
The size of the
Shut off database logging to clean up the storage problem.
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.