Conv Errors when using CReW Macros Runner

I have a workflow that runs clean with no conversion errors, but when I use a CReW Macros Runner to run the workflow I always get the message " Runner (3) Tool #2: The field "Field_1" was truncated in record #4". Has anyone seen this before? I saw some suggestions about adding a Select tool and increasing field sizes, but that hasn't had any impact.

Developer Tools

Error Message

Macros

Accepted answers

HarikaAttipalli

Modifying field length in Run Command solves the issue. Crew Runner -> Run Command tool--> Read Results --> Input --> change the Field Length to some higher length which you would think appropriate for your purpose( I set to 2000 ) ..by default it was set to 254.

All comments

WayneWooldridge

Hi @abartoszek,

Without really knowing what your data looks like, it appears your data may have a data type for field length problem. Take a look at the metadata of the first field in record four and see what it looks like. If this doesn't resolve the issue, I suggest contacting Alteryx Customer Support at support@alteryx.com to have them take a closer look. If can include a copy of your workflow and data in that email, that will really help them so they can help you.

pkkrish22

Hi @abartoszek,

did you get any solution for the issue you have mentioned, If yes please let me know what is the solution.

abartoszek

Unfortunately, I didn't have time to pursue it further. It seems to not cause me any data issues as of yet, and it's only a warning so my job doesn't fail. Sorry I couldn't be more help. : (

SCLB

I am getting the same error and have traced it to the Crew runner macro itself which is reading in an output file and trimming "Field_1". These conversion errors are stopping the runner working in the server, although it works on the desktop.

abartoszek

I did fix this a little while ago, but I kinda forgot where I repaired it. I remember it had to do with editing the macro and changing the truncate limit in one of the tools...

Cointribe

Hey,

The solution to this error is to set the limit on Conversion error greater than the number of errors your workflow is producing. You can find this under run-time tab in the designer window. I have attached the screenshot for your reference.