topic Re: Scheduled Workflow - Potential Output Conflict in Alteryx Server Discussions

Scheduled Workflow - Potential Output Conflict

bertal34 — Wed, 25 Sep 2019 15:20:22 GMT

I would like to schedule a workflow to run daily. The last step of workflow will Output Data and overwrite a .yxdb file stored on network drive. My question is what happens if a user is running a workflow using this same yxdb file WHILE the daily process is running? Will this be a conflict causing the gallery process to fail? Other ramifications?

Any thoughts are appreciated!!

Re: Scheduled Workflow - Potential Output Conflict

DataInvestigator007 — Wed, 25 Sep 2019 19:12:44 GMT

Append results file name either with user ID or timestamp.

for ex: <ResultsFileName><TimeStamp>.yxdb or <ResultsFileName><UserID>.yxdb.

This can potentially avoid rewriting the results file when 2 processes are running on server and producing a results file which is stored on Network Drive.

--Amar.

Re: Scheduled Workflow - Potential Output Conflict

bertal34 — Wed, 25 Sep 2019 19:29:10 GMT

Appending a timestamp is not an option in order to avoid having to update Inputs using this datasource. I don't understand the rest of your response.

Re: Scheduled Workflow - Potential Output Conflict

joshuaburkhow — Fri, 03 Jan 2020 20:50:28 GMT

Yes this will cause an error. I built a quick sample to show you that if you have the YXDB file open while you are trying to write to it you'll see this 🙂

Now having said that if you have two people running a workflow then it will only error if they are open at the same exact time which is possible but if that's a concern, you should create a different file/folder to mitigate this 🙂

Hope this helps! If this does please mark it as resolved so that others can see it in the community!

Thanks

Joshua