Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Field reset bug in select tool, after 2020.4 upgrade?

warrencowan
9 - Comet

Hi Guys, 

 

I dont know if this is a known bug, but having recently upgraded to 2020.4 I have found that many of my output tools have either been failing or writing out different field lengths. The output tools in question are all exporting via a drop table config to SQL azure DB's using the ssvb SQL Server Bulk Loader driver.

 

I was alerted when another external process couldn't import the data exported by the alteryx process because the fields formats we're now showing up as huge ntext fields, and it was expecting nvarchar500, which I enforced using v w string and the 500 length in the output tools.

 

Having checked the last field select tools in the process tools they appear to have reset themselves to '1073741823' causing either the export to error due to the unexpected length, or finish but incompatible field settings. 

 

I have had to go through my processes one at a time resetting them.

 

Anyone experienced the same?

 

w

0 REPLIES 0
Labels