Skip to main content
  • EN
  • Home
  • Forums
  • FME Flow
  • Automation
  • I have multiple FME workflows that trigger once via my directory watch. How do I avoid a SQL deadlock since they all upload to the same SQL database table?
I have multiple FME workflows that trigger once via my directory watch. How do I avoid a SQL deadlock since they all upload to the same SQL database table?

Set up job queues to route them all to one specific engine so there can only be one running at any one time?

Set up job queues to route them all to one specific engine so there can only be one running at any one time?

Agree completely, this is probably the easiest workaround.

For a more performant solution, if necessary, have a look at your database back-end and how it supports concurrency and avoiding race conditions. For example, here are some ideas relevant to SQL Server: https://dba.stackexchange.com/a/187411

Reply


Community Stats

30,162
Posts
114,482
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.