Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop 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

‎12-07-2020 02:46 PM - edited ‎07-22-2021 02:16 PM

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.
 
Labels