Status: Corrupt: database table is locked: TheData

[ChetRojice]

We have one workflow that is run through Alteryx Scheduler that failed a few days ago with a message that we have not seen before: Status: Corrupt: database table is locked: TheData - The workflow did not show a failed result either.

Anyone know what I need to review to fix this issue? I was able to delete the workflow from the schedule, reschedule it and run it successfully but I would like a better understanding of the issue.

[MichaelAd · Accepted solution]

Hi @ChetRojice,

Can you make sure that the account running Alteryx Serivce has access to modify the directory (Alteryx System Settings - Controller - Persistence). Also make sure that there is no other process having the persistence layer open or locked.

Please let me know if you have other questions.

Thanks.