Internal Error - Deadlock Detected on Alteryx Server

[cin5097]

I uploaded a workflow to server, and whenever I try to run it, I get the internal error. On Desktop, it runs fine. Because there are a lot of SQL inputs, I've checked "Read Uncommitted" hoping that would work. I've also turned off AMP engine. Is there any solution to this?

It seems like it happens towards the end of the run where I'm creating a final output of the workflow.

[albert_alaluf]

Hi,

I suggest you to create a brand new workflow. You can copy and paste just the SQL scripts you have. Try to add your input data one by one, and save and run. If it works well, then add the second one. So go very controlled. I had these issues before I don't know why. Mostly it fixed a new workflow and added smaller pieces. I hope this helps.