deadlock error with Alteryx and sql

[Nandakishore]

Hello ,

I have this strange problem . 

When i am loading data into SQL DB using Alteryx , the other person who is working on db / front end ..is unable to perform any update like run db, run portal, run power bi, etc . 

May be the alteryx solution is causing locks when loading data .  Any solution for this . 

Thanks.

[gawa]

@Nandakishore 

If you use Input tool, try to check option "Read Uncommitted". With this, you can read SQL data without lock. Otherwise sql db is locked till transaction is completed, and sometimes trouble like your case take place.

Refer to this past thread for reference.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Input-Data-tool-Queries-should-not-l...