Message Tool issues on Alteryx Server

Question

Hi Team,

I'm using certain validation on columns for ex. checking correct data type, input columns to be blank, checking for correct date etc. in the input files and displaying the relevant messages to the user if any validation fails and stop the workflow from further proceeding and producing a output file which has all records with incorrect data and user needs to correct it. Now everything is working fine in the desktop version of Alteryx. But when I try it on Server the error messages are displayed correctly but the output file for errors is not produced. Any suggestion or work around on this.

Thanks in Advance!!

hemant86 · Answer

Thanks for your response @TheOC . I tried as you said. I deselected the 2 output options in workflow settings. And also I'm using relative path for both the out files which needs to be produced in case of Errors. But still no luck. The workflow stops with the Error message given in the message tool but no output file is produced to download. Please correct me if I'm wrong.

(Output)Error Records.xlsx

(Output)Total Present Days.xlsx

TheOC · Answer

hey @hemant86

My guess would be that the path to your log file has been packaged, and the output file will be saving into a temporary folder. You can circumnavigate this by deselecting the file when uploading the workflow in 'manage workflow assets':

Ensure that the path is to a network drive or relative path, mapped the same on the server. When a file is selected to be packaged, a version of that file is zipped with the workflow, and put onto the server. The server workflow then uses that specific file, rather than the version of the file that you are wanting to have access to, too.

Hope this makes sense,
Cheers,
TheOC