Alteryx Server: workflow publish Errors

Question

I am trying to publish an alteryx workflow to the gallery that runs without errors in alteryx designer. But when saving to gallery throws these errors:

[workflow.yxmd]Tool 186- Cannot find macro "Crew_ParalleBlockUntilDone.yxmc"

[workflow.yxmd]Tool 187- Cannot find macro "Crew_ParalleBlockUntilDone.yxmc"

Tool 3 - Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Tool 4 - Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Tool 5 - Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Tool 6 - Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

In the designer the workflow inputs are sql queries connecting to oracle database.

Does these indicate the macros or data input need to be created explicitly in the gallery? Experts please shed some light.

Thanks

BrianR · Answer

Hi @Yuri24, so there are two issues going on here. First, let's take the data source message. While your local Designer can connect to the required data source (in your case, Oracle), you will need to install the same version Oracle drivers on the Alteryx Server machine, including references to your data sources. For example, if you are using a DSN entry to source your data in Designer, that same DSN should be configured on Server...in short, Alteryx Server needs to know how to locate that particular data source as configured with Designer on your local machine.

This post has some great info on working with data sources both locally in Designer as well as Server.

Regarding macros - while this post isn't specific to your particular macro, there's some detailed discussion on what needs to be done on Server. Similar to data sources, Designer has what it needs to run your workflow including macros you have installed and configured in a workflow. Server doesn't have access to those macros just yet, so you will need to instruct Server on how to access those macros, including installing them on the Server machine, using a shared location that both Designer and Server can access, which is covered in that link above.