ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord" when writing to a SQL table


Environment Details

  • Alteryx Designer
    • 2020.3
  • Database: Microsoft SQL Server
  • Driver: ODBC SQL Server Native Client 11 or Driver 11 version

Starting with version 2020.3, users are getting An unknown error when trying to load very large text fields (size 1073741823) into SQL Server with workflows that work in older versions.

Error: Output Data (127): An unknown error occurred in II_PushRecord

or you could also get below error:
Error: Output Data (127): An unknown error occurred in PI_Close

The Error could also occur with other functions:


An unknown error occurred in II_Init



Defect: DE27954


Add a Select tool ahead of the Output Data tool and change the size of the field from 1073741823 to smaller value (for example 9999) or put the Autofield tool ahead of the Output Data tool.