Data Cleansing Tool Getting error on Server

[prpanw]

I have workflow which is working fine on Alteryx app but while running on UAT Server it is throwing an error;- Errors • DataCleansing.MultiFieldMacro (215): The output connection "Output6" was not valid (ToolId: 37) • DataCleansing.MultiFieldNumericMacro (308): The output connection "Output6" was not valid (ToolId: 37)

[apathetichell]

What version of Alteryx are you running on Server? 

[KGT]

This sounds like a mismatch for the Data Cleansing Tool macro. Do any other workflows loaded to the server with that tool work? If not, then you may need to replace that macro on the server with one that is compatible. But first, as @apathetichell mentioned, check the versions as that may indicate the mismatch.

[prpanw]

Version: 2023.1.1.247

[apathetichell]

more clarity here ---> the data cleansing tool is a macro which is installed in the standard macros directory on your local and on server. it can be open/edited/messed with. It's possible that a) there is a different version of the cleanse tool uploaded specifically for this workflow. b) there is a speciifc version of this cleanse tool needed for this workflow. c) the tool is corrupt on your server. d) the tool is just broken. one of these issues relates to replace white space and the other is for numeric fields allocating a 0. I'd recommend -> copy a macro cleanse tool to your server macro directory. re run -> retest locally.