Export feature class results in less features in output

[nguyhv2]

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.

[MrRamonG · Accepted solution]

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

[nguyhv2]

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).