Logging issues when trying clean up the database
The size of the Qlogs database has grown too large and the database admin is having resource issues when trying to clean up the database.
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.