AnsweredAssumed Answered

Cannot insert features into SDE Geodatabase

Question asked by filipkral on Jun 25, 2015
Latest reply on Jul 3, 2015 by filipkral

Hello

Can you help me solve a problem which has the following symptoms please?

 

I export a feature class from our ArcSDE Enterprise Geodatabase to a local file geodatabase (using FeatureClassToFeatureClass) and then I want to import the feature class back from the local file geodatabase to the SDE geodatabase (using FeatureClassToFeatureClass) as a new feature class with a new name but I get the following kind of response (with a point feautre class):

 

Executing: FeatureClassToFeatureClass C:\dt\tmp.gdb\fc "Database Connections\THEDB.sde" fc_import # "ID "ID" true true false 4 Long 0 0 ,First,#,C:\dt\tmp.gdb\fc,ID,-1,-1;SRC_ID "SRC_ID" true true false 4 Long 0 0 ,First,#,C:\dt\tmp.gdb\fc,SRC_ID,-1,-1;NAME "NAME" true true false 50 Text 0 0 ,First,#,C:\dt\tmp.gdb\fc,NAME,-1,-1;COUNTRY_CODE "COUNTRY_CODE" true true false 30 Text 0 0 ,First,#,C:\dt\tmp.gdb\fc,COUNTRY_CODE,-1,-1;EASTING "EASTING" true true false 4 Long 0 0 ,First,#,C:\dt\tmp.gdb\fc,EASTING,-1,-1;NORTHING "NORTHING" true true false 4 Long 0 0 ,First,#,C:\dt\tmp.gdb\fc,NORTHING,-1,-1;HYDROMETRIC_AREA "HYDROMETRIC_AREA" true true false 2 Short 0 0 ,First,#,C:\dt\tmp.gdb\fc,HYDROMETRIC_AREA,-1,-1;ELEVATION "ELEVATION" true true false 8 Double 0 0 ,First,#,C:\dt\tmp.gdb\fc,ELEVATION,-1,-1;GEOG_PATH "GEOG_PATH" true true false 50 Text 0 0 ,First,#,C:\dt\tmp.gdb\fc,GEOG_PATH,-1,-1;FIRST_DAY "FIRST_DAY" true true false 8 Date 0 0 ,First,#,C:\dt\tmp.gdb\fc,FIRST_DAY,-1,-1;FIRST_YEAR "FIRST_YEAR" true true false 2 Short 0 0 ,First,#,C:\dt\tmp.gdb\fc,FIRST_YEAR,-1,-1;LATEST_DAY "LATEST_DAY" true true false 8 Date 0 0 ,First,#,C:\dt\tmp.gdb\fc,LATEST_DAY,-1,-1;LATEST_YEAR "LATEST_YEAR" true true false 2 Short 0 0 ,First,#,C:\dt\tmp.gdb\fc,LATEST_YEAR,-1,-1" #
Start Time: Thu Jun 25 10:23:17 2015
WARNING 000597: Failed to insert input record with FeatureID 3966.
WARNING 000595: C:\foo\bar.fid contains the full list of features not able to be copied.
WARNING 000597: Failed to insert input record with FeatureID 3967.
...
WARNING 000597: Failed to insert input record with FeatureID 4000.
ERROR 000224: Cannot insert features
ERROR 000224: Cannot insert features
Failed to execute (FeatureClassToFeatureClass).
Failed at Thu Jun 25 10:23:27 2015 (Elapsed Time: 10.80 seconds)

It has happened with more than one feature class but it does not happen with every feature class. Everything I found about this problem suggests that this problem can occur if the feature that is being inserted has a geometry or attribute value that is not suitable for the data type in the output geodatabase but I cannot find any mismatch (or don't know how to find it) and I would expect ArcGIS to handle this when it's a transfer "from ArcGIS to ArcGIS".

Some features get inserted OK. I looked at some of the features listed in the warning messages but I cannot see anything wrong with them.I tried CopyFeatures but it produced the same result.

All parts are at version 10.2.2.

 

Any hint welcome!

Filip.

Outcomes