topic Re: Output to multiple sheets in same workbook not possible on Server in Alteryx Server Discussions

Output to multiple sheets in same workbook not possible on Server

slobo — Mon, 18 Oct 2021 12:01:17 GMT

Hello,

I have trouble with the output tool. I set the output tool to generate data to one workbook but to different sheets based on data in one column. In designer this is working perfectly, but uploaded to server it gives an error saying that the file is being used by another process. I even created one mini workflow with some random data (see below) and the same thing happens.

Re: Output to multiple sheets in same workbook not possible on Server

mbarone — Mon, 18 Oct 2021 12:13:15 GMT

What's the error message? Are you using UNC path or a mapped drive? Does the server have access to wherever you're writing it to?

Re: Output to multiple sheets in same workbook not possible on Server

slobo — Mon, 18 Oct 2021 14:11:34 GMT

Hi, the error message is:

Unable to open file for write: (file on network folder address) Error Opening file: (file on network folder address) : The process cannot access the file because it is being used by another process. (32)

Yes, UNC.

Yes, server has access to the file.

Thanks!

Re: Output to multiple sheets in same workbook not possible on Server

fmvizcaino — Mon, 18 Oct 2021 15:03:45 GMT

Hey @slobo ,

Another user was talking about this same exact issue last week. Since both of you are using UNC path and it is all working on designer, I'm thinking this could be a bug. What is your Alteryx server version?

Best,

Fernando Vizcaino

Best,

Fernando Vizcaino

Re: Output to multiple sheets in same workbook not possible on Server

slobo — Mon, 18 Oct 2021 20:07:25 GMT

Hi,

Server:
Client: 2019.4.20206
Server: 2019.4.4.20206
Server Binaries: 2019.4.4.20206
Service Layer
Master: 2019.4.4.20206

Designer

2019.3.1.24384

Re: Output to multiple sheets in same workbook not possible on Server

fmvizcaino — Tue, 19 Oct 2021 18:22:32 GMT

Hey @slobo ,

I've tried to reproduce your error in a bunch of different ways and wasn't able to do it.

I know you have created a dummy workflow, but please share that to see if it is somehow related to the workflow itself, not saying you have not configured properly, but maybe related to your workflow version.

If the error persists, it is better for you to open a ticket with Alteryx support showing what is happening.

https://community.alteryx.com/t5/Support/bd-p/SupportPage

Best,

Fernando Vizcaino

Re: Output to multiple sheets in same workbook not possible on Server

carlosteixeira — Tue, 19 Oct 2021 18:30:04 GMT

Hey @slobo

Do you try to change the OUTPUT OPTIONS to Overwrite Sheet or Range or Overwrite File Remove?

Best regards

Re: Output to multiple sheets in same workbook not possible on Server

apathetichell — Tue, 19 Oct 2021 21:26:54 GMT

What happens if you put the output data tool in a batch macro and batch by the file/tablename? or if you change to fullpath (and create fullpaths for each sheet based upon filepath from your input data?

Re: Output to multiple sheets in same workbook not possible on Server

slobo — Wed, 20 Oct 2021 08:46:04 GMT

Thank you all for answers!

General update

Newest thing I tried is to add Block until done tool, and it worked both in Designer and Server. Then I tried to schedule it at some random time (today at 9 a.m) and gave no error.

Workflow is scheduled to run around 5 a.m. every day. I mention this because a few days ago I had a situation where I edited workflow and run it successfully in Designer and Server (both manual and scheduled at around 2 p.m) but next morning around 5 a.m. for some reason gave error.

So now, I have to investigate why gives error when it is scheduled in the morning (I tried one hour earlier, but same error I receive). Also, the file is not used by any other process at that time.

@fmvizcaino Here is the sample workflow.

@carlosteixeira Yes, I tried Overwrite File Remove and it works as same.

@apathetichell Regarding macros, I have to try this because I just started learning them. 😁 The second thing you mentioned I tried and it is the same error.

Re: Output to multiple sheets in same workbook not possible on Server

PeteLacz — Mon, 19 Dec 2022 16:34:22 GMT

@slobo

I'm curious if this issue resurfaced for you after the 2022.1 update like it did for me.

Re: Output to multiple sheets in same workbook not possible on Server

Sfrancisci27 — Wed, 11 Jan 2023 00:40:51 GMT

Having the same issue myself now after the 2022.1 update and it still errors out after adding a block until done

Re: Output to multiple sheets in same workbook not possible on Server

Ariharan — Fri, 13 Jan 2023 18:38:34 GMT

HI @slobo ,

We have faced the same problem earlier. After creating the file in FS location, we found that the file is being scanned by Antivirus. After disabling the antivirus app, we solved this problem.

Regards,

Ariharan R