Logging issues when trying clean up the database
Possible cause
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.
Proposed action
Shut off database logging to clean up the storage problem.
Warning noteThis 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.