Skip to main content
Solved

Locating a duplicate column

  • August 4, 2025
  • 2 replies
  • 95 views
esmgron
Observer

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!

Best answer by crutledge

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!

lambertus
crutledge
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

crutledge
Influencer
Forum|alt.badge.img+43
  • crutledgeInfluencer
  • Influencer
  • Best Answer
  • August 4, 2025

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!

At your rest service ^B
lambertus
esmgron
Observer
  • esmgronObserver
  • Author
  • August 5, 2025

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 :)

lambertus
crutledge

Community Stats

32,128
Posts
121,966
Replies
39,779
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.