python tool output: "PermissionError: unable to delete file"

[Joshman108]

I am getting 

PermissionError: unable to delete file: D:\ProgramData\Alteryx\Engine\Engine_15892_4fc8cc81212046699f225852a85d7cd8_\eb1d8c59-924e-4ba7-bc45-70ed9f97a095\output_1.yxdb

on this line

Alteryx.write(df,1)

I actually have multiple copies of the same workflow open and am running them all concurrently. 

I'm afraid this error is somehow caused by the python tools actually being linked to the same python kernel on the backend which then tries to output the file to a file already in use by another workflow.

Is this what is happening?

Confusingly, this doesn't stop alteryx from streaming out the data, or at least indicating that is it. I'm worried if multiple workflows are trying to access the same yxdb then when workflow 2 throws a permission error but still streams out data, it is actually streaming out data from the yxdb written from workflow 1, not from workflow 2.

Is that correct?

Weird stuff. 

[danilang · Accepted solution]

hi @Joshman108 

I believe that having multiple copies of a workflow open will have all the corresponding Python tools to reference the same instance of the Jupyter notebook.  If you switch the tools to Production mode, they get decoupled and changes made in one tool stop affecting the others. 

Try this and let us know if that fixes your temp file issue as well.

Dan