Workflow failed with error "file not found" however file is present in the folder

poojamate92

Hi Team,

We have a workflow which schedule to runs daily 2 times a day (1st run is at 6am and 2nd run is at 11 am). The workflow using 1 zip file and 2 .csv files which are places at same folder. From last two weeks the workflow is getting failed once a week with error that it cannot find one file i.e. xyz.csv (Rest two files are able to fetch by WF).  However, the file is already present in the given folder and

e.g. In recent case I checked that the xyz,csv file is written at the file location at 1 AM and workflow runs at 6 AM still it got failed with error that WF cannot find the xyz.csv file.

This case happened two time till now. Can anyone suggest what are the causes for the error ?

Please Note - 

1. The WF failed at first run only. In second run it runs successfully.

2. We observed that whenever workflow failed at first run with the given error, In second run it takes more time than usual. (usually it'll finish running in 1 hour but when failed at 1st run it takes 2+hours to run)

jrgo

Hi @poojamate92 

Being that the error is not persistent, I don't think the issue roots in Alteryx, however, some other questions to help with troubleshooting:

• Are you noticing any pattern on when the workflow errors (i.e., always on X day on the 11am run), or is it completely random?
  • This could help to determine if there's something else happening at this time within the share folder if there is a pattern.
• Are the files being accessed from a network share folder hosted by a Windows Server or from a shared folder from a machine that's NOT a server?
  • If it's shared folder from someone else's desktop machine, it could be hitting a concurrent user limit if that share folder is also actively used by other users.
• Is the error always against the same CSV file?
  • Again, this is just to determine if there's a pattern.
• Are the 3 files static or are they updated/replaced frequently? if the latter, when and which files, if not all?
  • this could help with determining the problem if the error happens after some event happens with the files it's reading.

You may also want to look through the Windows Event Viewer logs on both the machine hosting your Alteryx Server and the network share. This may have logged a more descriptive reason for why the file was not read/found.

Hope this helps!

Jimmy