Skip to main content
Question

Is there a way to create output Feature Classes in an ESRI Enterprise Geodatabase that have fields named with SQL Reserved words


mitchvan
Participant

I am running some simple jobs that merely move datasets from one location/format to another to provide access from multiple systems and applications. When one of the source datasets contains a field name that is a SQL reserved work (SQL Server in this case) FME Workbench is unable to create the output feature class and the job fails.

 

For example I have a Shapefile of airports that has a text field in it named "Name". When I attempt to write this dataset to an enterprise geodatabase without changing that field name the job fails with this error -

"An error occurred while attempting to create the feature class 'airports_metro'. The error number from ArcObjects is: '-2147215961'. The error message from ArcObjects is: {Invalid database name [08004:[Microsoft][SQL Server Native Client 11.0][SQL Server]Database 'NVARCHAR' does not exist. Make sure that the name is entered correctly.] [EGH_PUBLIC_WGS.ARCMAP_ADMIN.airports_metro]}"

 

Is there a way to get FME to bracket "[]" the field names when issuing the command to create the output dataset so that I can move data around without having to change schemas from one location to the next. Or has anyone else run into this issue and found a workaround.

 

NOTE: If I move the dataset using ArcGIS tools (Copy of Feature Class to Feature Class) the output table is created and populated. I am trying to avoid these tools because I also often have to project the datasets and am trying to avoid the two step process of moving and then projecting using ArcGIS tools.

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings