This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have an issue with scheduled workflow on Alteryx gallery. I checked similar topics but I couldn't find solution for my case.
I created a workflow few months ago and it was running with success on Alteryx gallery. Recently the format of the input file has changed (from xlsm into xlsx) and I updated the workflow and saved it in gallery ( I simply removed the input tool and added new one with changed file format) . The location of the file stayed the same. I also updated other workflows with this new input and they work with no issue.
Additionally this workflow works on alteryx gallery when I run it manually, there is only a problem when I schedule it.
This type of error would normally point towards permissions and the account that the workflow is running as when scheduled. But I'm assuming that none of that has changed. Is the filepath UNC? Relative filepaths may cause an error like this as the scheduled job will set up a folder in the Workspace directory. So that's the first thing that I would check, trying it with a UNC path.
I just had the same problem even though I was using UNC to input from a shared network folder. With version Alteryx version 2019.4.8, (compatibility with my company's Gallery version), do not checkbox for any of the inputs under "Manage workflow assets" when saving the workflow to the Gallery which preserves the UNC path. Checking caused inputs to defaults to "_externals" leading other errors when saving.
Under "Set Workflow Credentials" select "Always run this workflow with these credentials". Enter information and hit Enter key. Do not hit "Done" button. There is a bug with the older version of Alteryx that I am using. After using Enter key, a "validating" message will briefly appear and main menu re-appears. Proceed with Save.
Once I followed these steps, the workflow saved to gallery with no further "File not found error". Read files from shared network folder and ran successfully with no errors.