Skip to main content

SOLVED - I found the error

 

Hello!

I've been working on a script that has 56 columns (client needs all the fields of information), and now I need to write it using an Esri File Geodatabase writer. I have double- and triplechecked whether there is an invalid character (since gdbs are quite strict with field names) or a duplicate of one of the fields, but I cannot find it. Is there a tool in FME that let's you identify a duplicate of a whole column in the attribute table? Or a duplicate field name? Or does anyone know if there is another common solution to this error?

This is the error code:

ERROR |An error occurred while attempting to create the feature class 'Test'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column. .Test]}
 

I am using FME form 2024.1.

Thank you in advance!

Hi ​@esmgron 
Check and see if there are any system fields in your writer. I typically see this when I have objectid or OBJECTID or Length or some type of auto generated field that Esri uses on create.

Hope this helps!


Hi @crutledge 

Thank you for the tip! Of course 5 minutes after I posted this I immediately found the error…

Would be great if we could mark a post as solved without replies :)