Skip to main content

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.
  1. In Windows, open Services.

  2. Stop the following services:

    • Qlik Sense Engine Service
    • Qlik Sense Proxy Service
    • Qlik Sense Scheduler Service
    • Qlik Sense Repository Service
  3. Open a command prompt with administrator privileges.

  4. Go to C:\Program Files\Qlik\Sense\Logging.

  5. Run Qlik.Logging.Service.exe archive --cutoff_in_hours X (where X is the number of hours).

  6. Run Qlik.Logging.Service.exe purge --cutoff_in_hours X (where X is the number of hours).

  7. Restart the Qlik Logging Service.

  8. Verify the reclaimed data storage.

  9. Start all stopped Qlik Sense services, beginning with the Qlik Sense Repository Service.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!