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

Scheduler Results, Status Corrupted

ericy330
5 - Atom

I have a desktop scheduler and am trying to setup a scheduled workflow (on disk) and the status ends up as corrupted.  The workflow runs fine manually.  Any ideas on what I'm doing wrong?

 

Status.png

6 REPLIES 6
SteveA
Alteryx
Alteryx

Hi there,

 

Generally speaking, it's a good idea to run a module from the Scheduler database instead of a local path unless that module is going to be updated frequently, and you want the module updates to be reflected when run from the Scheduler.  If you do need to Schedule a module from a local path, however, there's several possible reasons why a module run can end up a "corrupted" state, but most likely the module isn't being found correctly by the Scheduler when it's time to execute.

 

The first suggestion is to verify that that app runs correctly when run from the Scheduler database.  Try scheduling the module in this fashion, does it run correctly?

schedule.png

If the module does not run when scheduled in this fashion, then we should examine your Scheduler setup in more detail, as there may be other problems lurking.

 

If it does run, hooray!  And on to the next step...

 

 

When running module from a local location, it's critical that the path you choose is available to (and readable by) the Scheduler, otherwise the module will not be located and execution will fail.  By default, the Scheduler will execute a module as the System account, but your Scheduler may be configured with a "Run As" user in the System Settings dialog:

 

run_as.png

 

Regardless of the user under which your Scheduler is running, the module path must be available to that user.  If you schedule a module from your local account referring to a drive alias (for example, G:\my_modules\module.yxmd) or UNC path (for example, \\remote_drive\my_modules\module.yxmd), that same path must be available to the Scheduler.

 

Can you please confirm that the paths you're using are available to the Scheduler?  If not, try scheduling the module from a path that is available... perhaps that fixes it?

 

 

 

If you have further questions or continue to have difficulty, feel free to follow up here.  I would also encourage you to reach out to your support contact at Alteryx or to Client Services (clientsvcs@alteryx.com) so we can resolve this matter quickly.


Best,

Steve A.

 

 

MacRo
Alteryx
Alteryx

@ericy330 -- If @SteveA's suggestion did not work for you, you might want to try downloading the newest version of Alteryx (10.1, which was released yesterday). I was having a similar issue as the one you're seeing, and it's been fixed with 10.1.

 

calan
6 - Meteoroid

SteveA I'm having a similar issue...the workflow runs fine in the desktop clien but the app fails when run from the Scheduler database...

Scheduler 1.jpg

 

Results Output...

Scheduler 2.jpg

 

What modifications do I need to make in my Scheduler setup to allow this to run?

 

SteveA
Alteryx
Alteryx

Hi @calan,

 

The log is telling us that the Server does not have permissions to access those shared resources (the UNC paths).  You need to ensure that the UNC paths accessed by the scheduled module are readable by the account used by the Server when processing workflows.  By default, the Server will run workflows as a Service account, but that can be changed by specifying a "Run-As" user on the Server as described in this thread.

 

So, either:

  • Specify a Run-As user on the Server with correct access permissions to shared resources accessed by modules scheduled on the Server
  • Leave the Server configuration unchanged but modify the access permissions on the shared resources to allow access to modules scheduled on the Server


Best,

Steve A.

 

calan
6 - Meteoroid

Thanks SteveA.  This resolved it.

JeroenJacobs
7 - Meteor

Make sure you open the workflow that you want to schedule from the network location before scheduling. So when you open the workflow initially, browse to the network location instead of the absolute location and then schedule. This worked for me.