Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Worker node unable to find shared workflow while Schedule

vepp
8 - Asteroid

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

 

 

3 REPLIES 3
joshuaburkhow
ACE Emeritus
ACE Emeritus

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? 

 

 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
vepp
8 - Asteroid

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

vepp
8 - Asteroid

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.