All,
We have a controller and worker. Worker and controller runs using "Run As" user and it has all required permissions on all the folders. Worker throws an error Failed to find file when the workflow runs on worker node in Schedule Mode. Initially, we thought that user might not have permissions to the file but later confirmed it has all the required permissions.
We use "Run the workflow from its original location on disk" option as we want to keep all the files in shared drive instead of Scheduler DB.
Methods Tried :
->We logged in as Run As user and checked access to the folders - No issues here
->We converted Worker as Controller and executed the workflow from same location -> it also succeeded
Issue : The issue is when controller and Worker are in different machine, worker unable to find the share drive path.
Please let us know a way to solve the issues.
Log from Worker Node :
2019-12-17 10:23:05.807000,NOTICE,6384,AlteryxService,,,,,,,,"ServiceThreadPool_GrowThreads: Growing thread pool count from <0> to <2>"
2019-12-17 10:23:06.147000,NOTICE,5364,AlteryxService,RenderWorkerDaemon,,,,,,,"RenderWorkerDaemon_Start: Started pipe PID <10840>"
2019-12-17 10:23:06.147000,NOTICE,916,AlteryxService,RenderWorkerDaemon,,,,,,,"RenderWorkerDaemon_Start: Started pipe PID <10808>"
2019-12-17 10:26:09.239000,WARN,10656,AlteryxService,ServerB|11ED305A,,USER1,,,,,"SlaveThread_TestFileExists: Failed to find file: <\\ServerA\Workflows\Test.yxmd> Trying to find again."
2019-12-17 10:26:09.761000,WARN,10656,AlteryxService,ServerB|11ED305A,,USER1,,,,,"SlaveThread_TestFileExists: Failed to find file: <\\ServerA\Workflows\Test.yxmd> Trying to find again."
2019-12-17 10:26:10.262000,WARN,10656,AlteryxService,ServerB|11ED305A,,USER1,,,,,"SlaveThread_TestFileExists: Failed to find file: <\\ServerA\Workflows\Test.yxmd> Trying to find again."
2019-12-17 10:26:10.774000,ERROR,10656,AlteryxService,ServerB|11ED305A,,USER1,,,,,"Service_Slave.cpp: 741. Invalid application ID <5df8ad410202c329cc00671e>, requested local path <\\ServerA\Workflows\Test.yxmd>"
2019-12-17 10:26:10.774000,ERROR,10656,AlteryxService,ServerB|11ED305A,,USER1,,,,,"SlaveThread_DoWork_VerifyError: Worker <ServerB|11ED305A> error <Invalid application ID <5df8ad410202c329cc00671e>,
Solved! Go to Solution.
What version are you on?
Also are you saying that you have tried to run manually and it works but only doesn't work when you schedule it?
@joshuaburkhow I am using 2019.3.5. Yes, I am able to run the workflow when I give local disk path (E:\workflows\test) or full UNC path (\\servername\workflows\test) in Local. But when I schedule, it does not work for UNC path.
After much trial and error found the issue and solution. Network path should be given access to Run as user along with computer account to folder.
I.e - User account is like "Alteryxuser" and the alteryx is hosted on machines like "AlteryxMachineA", "AlteryxMachineB" etc
Then network folder should be given access to
Alteryxuser - Read write
AlteryxMachineA$ - Read
AlteryxMachineB$ - Read
Note: $ is important to register the computer to allow Alteryx to access the folders. I think this Windows computer accounts to ensure secure login.
Hope it helps some one.