laptop and a wrench

Bug

Importing data from Local Government Information Model to a PostgreSQL geodatabase returns the error, "XML Import Error: Column already exist"

Last Published: April 4, 2015 ArcGIS for Desktop
Bug ID Number BUG-000086278
SubmittedMarch 20, 2015
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.2
StatusKnown Limit

Additional Information

This is a known limitation of working with the Local Government Information Model in PostgreSQL because the US National Grid feature class is based on the FGDC standard. Workaround: Prior to importing the Local Government Information Model into your PostgreSQL geodatabase remove the reserve system (XMIN) field and replace it with a field called XMIN_1. 1. Import Local Government XML workspace to a file geodatabase. 2. Delete the XMIN field from the US National Grid feature class. 3. In the US National feature class create a new field and name it something other than XMIN, for example XMIN_1. 4. Export to a new XML workspace, then import it into PostgreSQL geodatabase.

Workaround

- Import XML to file geodatabase. - Rename XMIN to XMIN _1 for feature class USNationalGrid under feature dataset EmergencyOperations. - Copy and paste, or import data to SDE geodatabase.

Steps to Reproduce

Bug ID: BUG-000086278

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options