Alteryx Server Issue Writing to Multi-Sheet Excel File

[ImenMersani]

Hello, I’m encountering an issue when publishing a workflow on Alteryx Server. My workflow performs calculations and then writes the results into an existing Excel template containing multiple sheets.

I use Control Containers (one per sheet) to write the data into each worksheet, and when running the workflow in Designer everything works correctly. However, once published on the server, I sometimes get an error indicating that the Excel file is being used by another program, even though the file is not open.

It seems that the server tries to write to the file at the same time without respecting the order of the Control Containers. I also tested using a Block Until Done, but the same issue persists.

Has anyone already encountered this behavior on Alteryx Server, and is there a solution or best practice to force sequential writing into the same multi-sheet Excel file on the server?

[fmvizcaino]

Hi @ImenMersani ,

I`m using control containers to order processes and save files on the Server since the feature was released, and I have never faced this issue before. The only thing you have to do is guarantee that the containers are connected.

Could you please share a screenshot showing how you are configuring the control containers? To make sure it is set up correctly. 

Are you saving the files to a shared folder? I’m wondering if this could be a shared folder issue, where the file is still being synchronized to the file server when the second control container is triggered.

Best,

Fernando Vizcaino