Has anyone come across this error message before?
The output is to a MS SQL Server table (in the same database in which I've been working all day,FWIW). Nothing special about this particular append-to table that I can see.
And it appears I've stumped Google with this one:
Solved! Go to Solution.
I've encountered the same problem and changing the size of data type really helps using select tools! thank you for the solution. Thank god we have this community, so i do not have to scratch my head till it turn bald haha
We started getting this error when we upgraded to 2020.3.8. It wasn't present before this version and the solution is to just use Auto Field tool at the end of every workflow. It's better than select because it will automatically take care of all text fields. As a general practice, I put Auto Field tools at the start and end of all of my workflows to minimize data set size.
This problem still exists as of May 2021. Autofield saved a lot of time, and i manually shortened the length of all of the string fields, and then the write to SQL went smoothly. Before that, though, it was a series of seemingly random errors, trying to write some fields, then other fields and getting non-specific error messages which didn't enlighten me OR solve the problem. The Thrill of Solving, indeed!
Thanks to the community for lightening the load, again. Alteryx is a big complicated tool that can do everything, and usually someone knows how to do anything you can think of, but connecting those facts to achieve a solution is often fairly magical. I really appreciate everyone sharing their expertise and experience. Thank you.
saved my day in 2022!!!
I receive this error when running my workflow via Alteryx Server but when I run the same exact workflow in Designer it yields a result. Why is the Server having an issue?
Hi @tomekz1283
Can you add an auto field tool right before the output tool?
This may help you resolve the issue on the server machine.
Hope this helps. If it does, please like the post.
I am using the auto filled option for my flow as well while migrating the data into the SQL server. Can anyone tell me how autofill works?
What will be the impact on data for while doing it ?