Output Excel file : An unknown error occurred in II_PushRecord.

Question

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?

Tej_Singh · Answer

@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!

davidskaife · Answer

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-error-quot-An-unknown-error/ta-p/677355 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 · Answer

@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