Error in temp file when running in gallery

Question

Hi all,

I run a workflow on the Alteryx gallery (scheduled workflow) and from time to time I receive an error regarding temp files.

Could you please advise how to fix this and avoid this situation for future?

Thank you in advance,

Asia

joannasokolowska · Answer

Hey,

Thanks for this comment - it is very useful! However I decided to change it back into excel (I couldn't figure out error on tool 206/210). I made the output file smaller (remove some columns/filter values) and remove/add output tools again. After that, I do not see this error anymore so I  hope it is solved permanently.

Thanks,

Asia

jrgo · Answer

Can't speak for the errors happening on tool 206 and 210, but for 133 and 208, the issue is that the file path in those output tools contain a part that is not used for CSV file types, highlighted below. That part is intended for data sources that contain tables/sheets, which a CSV file does not support.

You'll likely need to include that into the file name. e.g.:

* [your network path]\Training completions all completed courses 2021-01-04.csv
* [your network path]\Training completions Training completions 2021-01-04.csv

joannasokolowska · Answer

Thanks for looking into this issue! I tried to change output files into csv and I got even more errors now ;/