Output Excel file : An unknown error occurred in II_PushRecord.

[Tej_Singh]

Hi All,

Off late I have started to get "An unknown error occurred in II_PushRecord." while outputting even excel file. I am using Alteryx Designer 2020.3.5. I even ensured there is  select tool before each Output tool and the field width is not more than 10000, Still I am getting the error when executing the 2020 designed workflow in Alteryx 2021 designer.

Any advise or thoughts?

[davidskaife]

Hi @Tej_Singh 

There are a couple of reasons that this could be occuring, could you possibly share the workflow/provide screenshots of the section leading up to the output/output settings?

Edit: try putting an Autofield tool on just before the output, see if that works (if there isn't one already)

[Tej_Singh]

@davidskaife Thanks for the reply. Find below the Output tool settings and the select tool before the Output tool   that is giving push error. Any further thoughts?

Select Tool

[davidskaife]

Hi @Tej_Singh 

There is nothing jumping out at me; did you try adding the Autofield tool just before the output, if you're able to and it doesn't mess with the data?

I'd also suggest seeing what happens if you try outputing to a new xlsx file, to test and see if you get the same issue?

Incidently there is a Knowledge Base article of a known issue in 2020.3 https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/After-upgrading-to-2020-3-receive-e... for this error message, but it was happening when writing to SQL tables. Are you in a position to upgrade Alteryx at all as support ends for the version you're on by the 29th March 2022

[Tej_Singh]

@davidskaife Thanks for your reply. After all the investigation it turns out that it was an issue with access to writing out to the output path. It didn't had read/write access hence workflows where throwing errors. Doesn't seems to be the issue with field size or need to have auto filed tool before output tool.

Thanks for your reply though!