"File is being used by another process" while overwriting a yxdb with large field or blob

Question

Hi All,

For what it seems a quite basic, routinely process of updating a yxdb by reading the yxdb and unioning it with the new incoming data, my workflow fails with the classic "Error creating the file: The process cannot access the file because it is being used by another process. (32)"

This approach is commonly and widely used in many of my workflows, as this is the only way of appending yxdb records. But for some reason in this case in specific it does not.

I tried everything: sequencing via control containers (as you can see below), adjusting data types, changing the name of the yxdb. Nothing worked.

Not sure if it helps, but the yxdb file contains three columns: two V_WString (one is just a regular text, and the other one is a JSON value of a day's log) and another DateTime. At the moment, the yxdb only contains one record.

EDIT: I tried removing the JSON value prior to running the workflow and it seems like Alteryx succeeds in ovewriting the file. It seems like it doesn't like to overwrite yxdbs when handling columns with large texts or blobs.

yxdb_overwrite_error.yxzp

frank_saenz · Answer

Thanks for trying @davidskaife. Unfortunately BUD is not an option since my main workflow keeps many control containers (the tool is not compatible with them).

davidskaife · Answer

Hi @frank_saenz

Now the interesting question is does this process using Control Containers work in other Workflows and its just this one that fails?

I tried initially to play around with the sequencing, moving tools into different containers and so forth with no joy. I then thought just use a Block until Done tool, but strangely that was also giving the same error! However if you switch AMP Engine off OR run it in compatibility mode it works using the BUD tool.

Don't know if that helps especially if the process works in other workflows