Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Status: Corrupt: database table is locked: TheData

ChetRojice
5 - Atom

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.

 

Capture.PNG

1 REPLY 1
MichaelAd
Alteryx
Alteryx

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.

Michael Adler
Sr. Customer Support Engineer -- Knowledge Management Coach
Alteryx, Inc.

Labels