Write output gets stuck at 97%

Question

Hey

So I've done a temporary workaround to filter and write each tab individually, but in case this happens again I would like to understand anyone's experience in resolving this.

I'm writing a file to Excel (overwrite sheet), with five tabs, one particular file has 240,000 lines and the others range from 1500 to 40,000.  The output to tabs with 1500 to 40000 lines write fine, but when it starts to write the 240,000 tab it just gets stuck at 97%.  If I filter the path output to just this 240,000 it outputs fine...

Even tried leaving it overnight but the PC just went into hibernate

Any thoughts welcome!

Thanks

Cass

DawnDuong · Answer

Hi @ck2024

Sounds like AMP engine memory issue.

one way to circumvent is to cut into smaller pieces when you write (but that’s annoying!!!)

Dawn

AkimasaKajitani · Answer

Sometimes AMP Engine may cause the errors. When PC's memory is not enough, AMP Engine can behave strangely.

ck2024 · Answer

Thanks Dawn - I think part of the problem might be related to the AMP engine - a file just would not read today no matter what i did, and as soon as i unticked the AMP engine away it went...is that normal behaviour or does it point to a problem with my PC maybe?

Thanks