Alteryx Server Knowledge Base

Definitive answers from Server experts.

How To Troubleshoot: Corrupt Database Table is Locked

MichaelAd
Alteryx
Alteryx
Created

Environment Details


Alteryx Designer + Scheduler



Cause


idea Skyscrapers

The above error "Corrupt Database Table is Locked" is usually caused by missing permissions.



Resolution


  • The account running Alteryx Serivce has to have access to modify the directory (Alteryx System Settings - Controller - Persistence).

 

  • There should not be other process having the persistence layer open or locked.