community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

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

Do CREW macros need to be installed on Gallery box in order to run successfully?

Comet

Hi,

 

I believe the answer to this question is "Yes" but I wanted to confirm and to also understand if there are viable workarounds.

 

Here's the situation:

 

- We have a workflow that uses a Conditional Runner to call a workflow that resides in Dropbox.

 

- The workflow in Dropbox leverages a macro that also lives in Dropbox, since the Runner macros cannot "unzip" a packaged workflow, i.e. all assets used by the workflow being called by a Runner cannot be packaged.

 

- This all performs fine when we run the workflow locally.  But when we save the workflow to Gallery and try to run it, we get errors because certain assets required by the Runner macro are not accessible. 

 

Here is what our Runner macro configuration looks like:

 

runner config.png

 

 

Even though I've selected the Conditional Runner workflow in the macro assets, I still get this error when I save to gallery:

 

runner error 2.png

 

And when I run that workflow from Gallery, I get the following error:

 

runner error 1.png

So, working off of the assumption that all of these files need to be packaged into the workflow, I went back to the workflow in Designer and included these files:

 

runner config 2.png

 

I was unclear how to set up the AlteryxRunner executable file into an appropriate nested folder, which I believe is the cause of the error I get on Gallery when I try to run this modified workflow.

 

runner error 3.png

Is there anything I am missing?  Any help/guidance here would be appreciated. :-)

 

Highlighted
Alteryx
Alteryx

Packaging macros is not necessarily recommended, as if the Macro changes, you will have to repackage and re-publish the workflows that point to that Macro.

 

The better route is to have someone with access to your server machine log onto the machine and open Alteryx designer and install the macros the same way that you would on a local designer instance -> User Settings -> Macros.

 

I personally recommend storing all 'productionalized' macros somewhere that both users and the server can get access to (like a shared drive) and then the references are identical between users and published workflows.

 

Let me know if this is clear as much and I can expand on the idea.

 

Cheers!

Zak

Comet

Thanks Zak.  That is exactly what we are trying to pursue.  Have you encountered any issues installing the CREW macros onto the gallery server?  I know they aren't officially supported tools, but they seem pretty robust.

Alteryx
Alteryx

While not officially supported, they have worked continuously for a long time. 'Officially supported' just means that with each release we specifically check them for continuity, since they were developed by CReW (a partner of Alteryx), they are not checked in such a manner, but they havent had to change or release updates for almost 2 years.

 

Its also worth noting that Adam Riley, one of the CReW members involved in creating them, is a principle software engineer here at Alteryx - long story short, they are stable and I recommend them to my customers regularly.