Error II_PushRecord after upgrade to 2020.4. Any way to fix this??

[Newstart2020]

Hi All,

I found in the community that there is a Defect: DE27954 raised for the version 2020.3

We upgraded to 2020.4 last week and we are getting this II_PushRecord for different workflows on every other day...

Fix for the same is to use autofield or change the test size, however its quite tedious when you have few hundreds on workflows and you realize the failure only whn the scheduled worklfow fails and next day we have a production issue...

Is there any setting we can do on the server level to get rid of this error??  or do we go back to the older version (which we really really do not want at this stage as our 3 days of work will be totally lost)

Hope i get some possitive replies

Thanks

[ntobon]

@Newstart2020 

You are running into a known Defect: "DE27954 - Workflows using MSSQL DB started failed after upgraded to version 2020.3 with "An unknown error occurred in II_PushRecord". Fix of defect DE27954 is targeted for 2021.2.

The issue has been documented with the following KnowledgeBase article:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/After-upgrading-to-2020-3-receive-e...

Workaround:
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.

[ntobon]

Defect DE27954/TSM-317 was fixed in version  2021.2.

[lukas_pavlik]

It still doesn't work even with 2021.2 version ...