Workflow Malfunction

[mihir_sampat]

So I have made a custom standard macro as per my need. That macro has a python tool that fetches data from the Cloud. When I call that macro into the workflow and run the workflow, it runs properly. The issue arises when I run two workflows with the same macro simultaneously. 

Very unusual behavior occurs. Let's say I'm fetching table1 in workflow number 1 using my standard macro, and table 2 in workflow number 2 using the same macro. What happens is that workflow 2 throws an error which is as follows:

RuntimeError: Error creating the file " C:\Users\AppData\Local\Temp\Engine_3348_8e44062fd7924c478191425d277d1d82_\0328e956-f7d3-44fa-af6d-262d3ce5e43c\output_1.yxdb ": The process cannot access the file because it is being used by another process. (32)

and workflow 1 outputs the data of workflow 2. 

What could be the issue?

[grazitti_sapna]

@mihir_sampat , suppose I have an excel file called Test and have two tabs tab1 and tab 2 when you will try to run it separately it will work and when you will try to run it in a parallel it will give you this error as they both are processing same file at same time so Alteryx gets confused which workflow should access the file first therefore it gives you this error that the file is currently being used by another process once this process gets over then other workflow will run.

Also as you said it is using same temp file for both the workflows and overlapping each other so in your case this might be an issue.

I am not sure if it is possible but you can give it a try and try changing the engine.workflowdirectory or the temp file path for both your macros keep them separate maybe it will work to run the macros in parallel as the temp files or engine will be stored in separate locations for your separate workflows.

Thanks.