Select to view content in your preferred language

Export feature class results in less features in output

804
2
Jump to solution
05-24-2023 03:17 AM
Labels (2)
nguyhv2
New Contributor

Hi,

I am exporting one feature class from a geodatabase (Oracle) to another geodatabase (Oracle) using the Feature Class To Feature Class tool but the resulting feature layer have less features than expected. My source have around 12M features, and the output from the tool varies with each run going from 300k to 1M.

The source feature class was created in SQL. Registering the table or not in the geodatabase does not change the result.

I have also tried running the same export through arcpy (using CopyFeatures, FeatureClassToGeodatabase, etc.) while forcing the environment extent to 'MAXOF', but the results are the same with different count nowhere near what is expected.

0 Kudos
1 Solution

Accepted Solutions
MrRamonG
Occasional Contributor

Here are some steps I'd try:

  • Run Check / Repair Geometry geoprocessing tools
  • Export the feature class to an empty geodatabase
  • Break up the feature class into smaller groups
  • Run the export in Catalog, not Pro
  • If it still fails, run the export in ArcCatalog
Layer Slayer

View solution in original post

0 Kudos
2 Replies
MrRamonG
Occasional Contributor

Here are some steps I'd try:

  • Run Check / Repair Geometry geoprocessing tools
  • Export the feature class to an empty geodatabase
  • Break up the feature class into smaller groups
  • Run the export in Catalog, not Pro
  • If it still fails, run the export in ArcCatalog
Layer Slayer
0 Kudos
nguyhv2
New Contributor

Checking the geometry and removing/fixing the problematic geometries fixed the issue.

The check tool didn't work and was stuck, so I had to check the features using Oracle functions (ST_IsValid() and SDO_GEOMETRY.VALIDATE_GEOMETRY()).

I'm still surprised that instead of erroring out, ArcGIS silently stop the geoprocess and marks it as a success...

Note: this behaviour is the same in both Pro (2.7) and Desktop (Catalog).