Cross Tab Clean works manually but not when scheduled

[MeanLeanDean]

I have several work flows that that use the Cross Tab Clean tool but after upgrading to 2024.1, they have stopped working in scheduled workflows.  They function when running the workflows manually, but not when scheduled. 

There error message I get is "Tool #109 Cannot find macro "Cross Tab Clean\Cross Tab Clean.yxmc".

It's as if the scheduler looks for macros in a different location than Designer.

I tried deleting and rescheduling the workflow, but it made no difference.  How can I fix this?

[alexnajm]

The CrossTab tool is not normally a macro, so I think this is a custom macro. In this case, when you upload to Server you should check the macro under the manage workflow assets. This will package the macro up with the workflow for use. 

If it is saved to a network drive and the Server has access to this drive, then you can make it UNC path and leave it unchecked when uploading. 

[MeanLeanDean]

Thanks for the reply, Alex.

I should have been more clear that the tool in question is a third-party version of the regular Cross Tab tool called Cross Tab Clean which I downloaded from the Gallery. 

The description of the Cross Tab Clean tool is as follows: This is a macro version of the Cross Tab tool which doesn't convert non alphanumeric characters to underscores.

Also, I am using Scheduler which runs as part of Designer on my desktop, similar to Server but not as fancy.  All the scheduled workflows are stored on and run from the same desktop as Designer.

[alexnajm]

Ok then make sure the path is correct and accessible by the scheduler (similar to server)!

[apathetichell]

Is the scheduler running as you. If not ---> does it have access to that directory? next question ---> does that macro use python if so... it won't work. the usual problem here is that it's stored in a directory (or sharedrive) which can't be access by scheduler.

[MeanLeanDean]

Thanks for the reply, Altair.

Yes, Scheduler runs as me with all the same accesses.  There are no python tools in the macro and no tools have any python code.

Are any of those issues new to 2024.1?  I ask because, until upgrading to 2024.1, the tool refreshed fine in Scheduler; had been for months on both 2022.1 and 2023.1.

[apathetichell]

@MeanLeanDean there are two questions here --- are they related or should they be related. 

1) should they be related:

No --- they should not be. And someone at Alteryx may tell you that they are not.

2) are they related:

Almost definitely.

Keep in mind Scheduler is basically a depcrated legacy product. They have not sold it in years. I do not believe it's been for sale since the lowest currently supported version of Designer came out.  Alteryx probably does not test it when rolling out new versions of Designer --- and with the 'changes' that they make between versions this happens. I would strongly recommend keeping Scheduler at whatever version works for Designer at an earlier version.

you can try toggling on/off AMP. Also ---> if you have not yet ---> you should open the macro "Cross Tab Clean\Cross Tab Clean.yxmc in Designer and see what's in it.

My last recommendation would be removing the spaces in the directory/path and the macro and moving it into the same home directory as your workflow.

[MeanLeanDean]

Thanks, Altair, for the suggestions.  I'll work my way through those.  Worst case is I use the standard Cross Tab and use additional tools to mimic what the "Clean" version does.