Get Count returns wrong number of rows

[DavidKidd2]

ArcGIS Pro 2.9.3

I have a point featureclass evd_bend_profile that contains 69972 records but Get Count returns 314 records. When I run Calculate Field (and other tools) they only operate on 314 rows.

[JohannesLindner]

From the down arrow in the tool parameter, it seems like you don't use the actual feature class, but the layer from the map. If you have a selection or definition query in that layer, most tools will only affect the selected rows.

Drag&Drop the actual feature class from the database into the tool parameter (or use the folder button to browse to the feature class) and try again.

[DavidKidd2]

Hi Johannes

Thanks for the suggestion Johannes, but alas not the problem as no definition query set and I get the same result when running with the FeatureClass directly from the database rather than the layer.

Dave

Dave

[RobertBorchert]

Have you compressed the database recently

[DavidKidd2]

Hi Robert,

The FGDB has never been compressed. I just ran Compact and still the same.

[MichaelVolz]

Are you working on a local drive or network share?  If network share, try copyng the data to a local drive and try again.

[DavidKidd2]

Hi Michael,

Yes, FGDB on network drives are a pain. It is on a local drive. 

Dave

[JoshuaBixby]

Likely your feature class is corrupted.  Unfortunately, there is no simple fix.  Take a look at How To: Recover a corrupted feature class in ArcGIS Pro or ArcMap (esri.com). Also, if the network share supports file system snapshots, you should look back in time and see if you can recover some previous versions of the FGDB.

[DavidKidd2]

Update: I have now been running the fix program for two and a half days and it is still running and the featureclass is locked preventing me seeing how many records are in the new feature class. Iterations seem to be slower than when the model first started with each on now taking around four seconds compared to one and a half at the start. 68000 records * 4 seconds = 3.15 days so it should have finished soon, if it works.

[DavidKidd2 · Accepted solution]

I discovered that this was a generic problem with all featureclasses in the project, so created a new project file and the problem did not reappear. The problem was with the project file and not the data.