I want to write some 50000 features to Excel with fanout enabled by some attributes.
One of the fanouts contains 23487 features and fails the workspace with the message Error running translation with 8179 features inputted to the writer. If I filter it out the remaining 118 fanout files get written to disk.
I tried both normal writer and FeatureWriter. I have attached the workspace.
I started with FME 2021.1.3 and updated to 2021.2.0.1
I have done a little more digging in to the problem and it seems it has some problems when adding Formatting to rows or cells.
Any suggestions help.
@caracadrian Thanks for including the nice reproduction dataset and workspace. I was able to reproduce your error:
Error running translation.
It looks like it is related to using a template. If you drop in an AttributeCreater and just rename the attributes, I think you might be able to ignore the template xlsx and the translation will run.
In the meantime we'll try and get this fixed
Thank for the info @Mark Stoakes . I will be looking for the fix in the new builds.
I don't understand what you mean by renaming the attributes to ignore the template.
Ignoring the template is not an option for me as it contains an image in the footer and there are no means to insert one via workspace.
As a workaround I filtered the features that cause the crash to a second writer that doesn't use formatting and set borders manually in Excel.