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

ntobon
Alteryx
Alteryx
Created

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:
II_Init
II_UpdateProgress
II_Free

Example:


 
An unknown error occurred in II_Init

 

Cause


Defect: DE27954.
Fixed in version 2021.2.1.35394

Resolution


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.
 
No ratings