Cannot find macro "CReW_ListRunner.yxmc".

[df]

Hello,

i am trying to run a workflow in the scheduler.
When i start the workflow on Designer it runs without error.

When i schedule it i get "Cannot find macro "CReW_ListRunner.yxmc"."

Options -> Advanced Options -> System Setting -> "Run As ..."
i have entered the windows User

Options -> Advanced Options -> Workflow Dependencies
i dont see the CReW Macro.
But i also added a testing macro in the same folder and when i put "UNC" to that the Scheduler finds it.

So how do i tell my Scheduler where the CReW macro is located?

[BS_THE_ANALYST]

@df do you have the CReW macros downloaded?

If not, you can download and follow the instructions from here:
http://www.chaosreignswithin.com/p/macros.html 

Then you'll get this in your tool palette:

[DataNath]

Hey @df, I'd imagine the current issue is that the macro isn't currently accessible by your Scheduler. When you go schedule your workflow, if you go to the 'Manage workflow assets' configuration:

You should see an unticked box like this next to the macro:

If you go ahead and tick that and try again, does that help?

More info here: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Assets-and-Packaging-Workflows/ta-p/4...

[df]

Hi @BS_THE_ANALYST 

Yes i have them downloaded and installed

[df]

Hi @DataNath 

where do i find 'Manage workflow assets'
Is this Alteryx Server?
I am using Designer with Scheduler.


But by trying to find this option i found this
Options -> Export Workflow

My test macro has the UNC path here.
The CReW macro has the normal path. So it is not found by the Scheduler

[DataNath]

Hey @df both Scheduler and Server will have those export options. That configuration is exactly what you're after. If you tick the box next to the CReW macro list now as well and then export/try to run it that should work.

[df]

hi @DataNath 

so i exported the workflow -> getting a package.
i imported the package.

the paths did change.
but the error remains the same when i put that into the scheduler.
(also my normal macro is not found now)

but i can see the CReW macro now under "workflow dependancies"

now i did change all the paths here and it does work now when scheduled.
(changed everything to UNC paths)

Thank you for your help.

But is this the way to go? everytime i use crew_macro to export the workflow to make the crew_macro path visible and change its path?
is there no easier way?

[DataNath · Accepted solution]

Glad to hear it's working on the Scheduler now @df. You shouldn't need to play around with workflow dependencies - you can keep everything absolute. The reason for this is that, when you package the workflow (i.e. tick the assets in 'Manage workflow assets'), Alteryx will create the 'externals' folder that you can now see, which sits next to the workflow itself. During export, it will automatically switch the dependencies to be relative to the workflow i.e. pointed towards this externals folder.