topic Re: Get Count returns wrong number of rows in ArcGIS Pro Questions

Get Count returns wrong number of rows

DavidKidd2 — Mon, 20 Jun 2022 11:11:46 GMT

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.

Re: Get Count returns wrong number of rows

JohannesLindner — Mon, 20 Jun 2022 13:21:33 GMT

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.

Re: Get Count returns wrong number of rows

DavidKidd2 — Mon, 20 Jun 2022 14:22:55 GMT

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

Re: Get Count returns wrong number of rows

RobertBorchert — Mon, 20 Jun 2022 15:09:59 GMT

Have you compressed the database recently

Re: Get Count returns wrong number of rows

DavidKidd2 — Mon, 20 Jun 2022 20:33:06 GMT

Hi Robert,

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

Re: Get Count returns wrong number of rows

MichaelVolz — Mon, 20 Jun 2022 21:06:30 GMT

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

Re: Get Count returns wrong number of rows

DavidKidd2 — Tue, 21 Jun 2022 07:04:03 GMT

Hi Michael,

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

Dave

Re: Get Count returns wrong number of rows

JoshuaBixby — Tue, 21 Jun 2022 14:13:47 GMT

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.

Re: Get Count returns wrong number of rows

DavidKidd2 — Fri, 24 Jun 2022 11:33:24 GMT

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.

Re: Get Count returns wrong number of rows

DavidKidd2 — Sun, 26 Jun 2022 12:03:26 GMT

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.