topic Re: Worker node unable to find shared workflow while Schedule in Alteryx Server Discussions

Worker node unable to find shared workflow while Schedule

vepp — Tue, 24 Dec 2019 12:12:55 GMT

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>,

Re: Worker node unable to find shared workflow while Schedule

joshuaburkhow — Tue, 24 Dec 2019 12:17:05 GMT

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?

Re: Worker node unable to find shared workflow while Schedule

vepp — Tue, 24 Dec 2019 13:27:39 GMT

@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.

Re: Worker node unable to find shared workflow while Schedule

vepp — Sat, 28 Dec 2019 12:10:41 GMT

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.