topic Re: CReW Macros not Working in Workflows Saved to the Gallery in Alteryx Server Discussions

CReW Macros not Working in Workflows Saved to the Gallery

Greg_Murray — Mon, 04 Mar 2019 14:55:51 GMT

We have been having issues with using the CReW macros in workflows on our Gallery. We are specifically interested in using the Runner macros to chain workflows together. We have the recurring error message of 'Cannot find macro "CReW_Runner.yxmc".' The macros are on a shared drive that both the server and I have access to. I have ensured that CReW.ini files on the server match my .ini files. I have also had no issues opening and running the workflow from the Alteryx Designer client on the server. Has anyone else experienced this? Did I miss something? I've tried uninstalling and reinstalling, and restarting the server VM. Any help is greatly appreciated.

Thanks,

Greg

Re: CReW Macros not Working in Workflows Saved to the Gallery

LisaL — Wed, 06 Mar 2019 22:36:16 GMT

@Greg_Murray

The .ini files have to specify the UNC path because mapped drive letters are specific to a user account. Similarly, if the macros are stored in a user directory, then the AlteryxService probably doesn't have access.

Re: CReW Macros not Working in Workflows Saved to the Gallery

LisaL — Wed, 20 Mar 2019 23:07:18 GMT

@Greg_Murray

One other thing I neglected to mention. The Runner macros are not well suited for use with Desktop Automation or Gallery because they override the queuing functions that allow those to schedule workflows. If at all possible, I'd recommend you schedule the sequential workflows rather than using the Runner macros.

Re: CReW Macros not Working in Workflows Saved to the Gallery

kat — Thu, 21 Mar 2019 12:16:23 GMT

Hi @LisaL

I use the CReW runner a lot on server and intrigued by your post. How would I mange the scheduling of individual workflows, getting around the issue of one workflow not having been completed before the last?

Thanks

Katrin

Re: CReW Macros not Working in Workflows Saved to the Gallery

bharatandalam — Fri, 14 Jun 2019 05:45:32 GMT

You can use the crew conditional runner and have a block until done then other conditional runner and so on.

Re: CReW Macros not Working in Workflows Saved to the Gallery

levell_x_dunn — Sat, 15 Jun 2019 02:29:25 GMT

in my opinion and usage of the server @kat Crew macros is the only way to solve that problem, besides creating a huge gap of time where it each workflow should be finished.

But Crew Macros do trigger another workflow to run so if you use a lot of Crew Macros like we do, I turn down my number of simultaneous workflows knowing that runner macros will trigger additional ones beyond my settings.

Re: CReW Macros not Working in Workflows Saved to the Gallery

ChaitanyaReddy — Thu, 09 Jul 2020 13:17:13 GMT

Hi i am facing the same issue that cannot find crew_runner.yxmc . can someone help me with the solution?

Re: CReW Macros not Working in Workflows Saved to the Gallery

bharatandalam — Wed, 14 Oct 2020 23:47:55 GMT

You can use the crew conditional runner and have a block until done then other conditional runner