Data Cleansing Tool Getting error on Server
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What version of Alteryx are you running on Server?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Version: 2023.1.1.247
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
