Select to view content in your preferred language

Attribute calculator only processing 40 records at a time

917
6
03-07-2022 08:17 AM
Labels (2)
KeithOlson
New Contributor III

I'm trying to populate attribute values using both the Attributes pane and the field calculator in ArcGIS Pro 2.8.4. Both methods only set/calculate the cell values for 40 records at a time even though I have many more than that (sometimes all records) selected. The Extent environment setting is set at Default, so it isn't limiting anything. I have to run the calculation, re-select records that didn't get populated and run the calculation again, etc. Only 40 records are being populated each time. The feature class is in a SQL Server enterprise geodatabase.  

6 Replies
KimGarbade
Regular Contributor

Can you provide a screen shot of the calculation your running?

Almost sounds like a TOP keyword is being used somewhere (in SQL Server) or like the system (either on the database end or on the client side) is running out of resources.  I.E. its doing its job in 40 row chunks and it fails after the first one because it runs out of memory or diskspace... 

0 Kudos
Reinaldo_Cartagena
New Contributor III

You can make edits to a geodatabase edit version, check the results, reconcile, and post the version. Some editing options:

1) Use query by attribute in the content (feature class (right click: properties and definition query). See the following link: https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/definition-query.htm 

2) Usar python script. Ver el siguiente enlace: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/calculate-field-examples.htm 

 

Reinaldo.

0 Kudos
KeithOlson
New Contributor III

This was happening with any kind of field calculation or even just setting values in the Attributes pane (entering manually or selecting from a domain dropdown).

One update. I previously had it joined to another table. Once I removed the join, the issue went away. So, it does sound like a resources issue. This is a versioned enterprise database, so there's TON of stuff going on behind the scenes to make this all happen.

0 Kudos
KarlKemp
New Contributor II

I have encountered similar issues with the 40 rows being some sort of magic number with respect to joins against a SQL server enterprise geodatabase.  

1. If I use SelectLayerByAttributes from a stand-alone Python script against a joined layer it only returns the first 40 matching rows

2. If I use the FeatureClassToFeatureClass tool in ArcGIS Pro with a where clause against a joined layer the resulting feature class will have the correct number of output rows, but all rows after row 40 are duplicates (of row 40)

tmichael_wpjwa
New Contributor III

Same thing is happening to me.  I'm using ArcGIS Pro 3.0.3 and my geodatabase is SQL Server in AWS RDS.  While having two feature classes joined by GLOBALID the Calculate Field tool will only update 40 at a time.  Other issues include the attribute table not displaying at all after the Select by Attributes tool is used on the joined table.

BobPerham
Occasional Contributor

Same here. Just starting out with 3.0.3.  I'm calculating a SQL feature class field but I have a SQL Server table joined to it as well and it only calculates 40 records at time. Removed the join and it did them all.

0 Kudos