Skip to main content
Solved

Error message when converting four shapefiles into one FGDB.

  • January 12, 2022
  • 2 replies
  • 13 views

arash_hokm
Contributor
Forum|alt.badge.img+8

Error message when converting four shapefiles into one FGDB. Error consists of:

An error occurred while attempting to create the feature class 'SB_Aussenkasten'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create double column table.}

CraeteFGDBI would be thankful. if someone could tell me what the problem is.

Thanks very much.

 

 

Best answer by nielsgerrits

The source (SB_Aussenkasten) apparently has the attributes "BAUTEILNUM" and "Bauteilnum".

 

This can happen if you have multiple shapes with the same names in different folders.

 

In a GDB featureclass columns are not case sensitive and this is not allowed as these are seen as the same. So you need to fix that or rename one of them before writing to gdb.

 

You can do this using an AttributeRenamer, rename "BAUTEILNUM" to "Bauteilnum".

 

If you have a lot of columns you also can use a BulkAttributeRenamer to change all columns to lowercase.

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

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • Best Answer
  • January 12, 2022

The source (SB_Aussenkasten) apparently has the attributes "BAUTEILNUM" and "Bauteilnum".

 

This can happen if you have multiple shapes with the same names in different folders.

 

In a GDB featureclass columns are not case sensitive and this is not allowed as these are seen as the same. So you need to fix that or rename one of them before writing to gdb.

 

You can do this using an AttributeRenamer, rename "BAUTEILNUM" to "Bauteilnum".

 

If you have a lot of columns you also can use a BulkAttributeRenamer to change all columns to lowercase.


arash_hokm
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • 44 replies
  • January 12, 2022

The source (SB_Aussenkasten) apparently has the attributes "BAUTEILNUM" and "Bauteilnum".

 

This can happen if you have multiple shapes with the same names in different folders.

 

In a GDB featureclass columns are not case sensitive and this is not allowed as these are seen as the same. So you need to fix that or rename one of them before writing to gdb.

 

You can do this using an AttributeRenamer, rename "BAUTEILNUM" to "Bauteilnum".

 

If you have a lot of columns you also can use a BulkAttributeRenamer to change all columns to lowercase.

@nielsgerrits​ Many thanks for your help. I also have other question about creating relationship between Excel spreadsheet and FeatureClass in an FGDB. i will ask in other post.