We are using yxdb files stored in a common folder as a single source for data but I get an error when two users are connecting to the same yxdb at the same time. Is there a way to prevent this error?
When a YXDB is being written to, your workflow (or you) cannot open it. No way around that, that I know of.
There are ways to run workflows sequentially, so one won't start until another one finishes completely (including all outputs). The Run Command Event will do this. There's a set of "Runner macros" as well with a lot of great functionality, within the crew macro pack (search on "crew macros" and you'll get a lot of great stuff).
We only have this issue with CSVs, but try setting the YXDB files to read only through windows.
Hi @Brendan,
We usually do not get any errors, while using .yxdb files. by multiple users. but if you are still getting an error, please share the error (Screen shot).
Hi Bharti
Here is a screen shot of the error. I am actually not 100% sure that it is when just two workflows are connecting simultaneously as I just tried to recreate the error and it took several tries. But as more and more users are accessing this data I have noticed this error message more frequently. Just trying to trouble shoot how I can prevent it.