Bug: Using Field Calculator on a feature service in ArcGIS Pro changes all other field values to NULL
An issue has been found that impacts feature service layers in ArcGIS Pro 1.0.
When using the Field Calculator to calculate a field against a web feature layer (layer or table from a feature service), the fields that are not updated by the Field Calculator are set to NULL.
This only applies when working directly against the feature service. If working directly against other data sources such as a file geodatabase, an enterprise geodatabase, or shapefiles, this issue does not occur.
At most, the number of rows affected by this issue is the number specified by the 'MaxRecordCount' property in the connected portal or server. This is set to 1000 rows by default.
Managed fields (such as OID, GlobalID, or editor tracking fields) are not affected by this issue.
This is a known issue: BUG-000086874.
Esri has provided a fix for this issue in the 1.0.2 update to ArcGIS Pro. The next time ArcGIS Pro is opened, accept the prompt to download and install this update. If you have disabled ArcGIS Pro from checking for updates, please visit my.esri.com to download the latest updates for ArcGIS Pro.
For more information, visit the following link about applying ArcGIS Pro software updates.
This issue has been fixed in the aforementioned ArcGIS Pro 1.0.2 update.
However, there are additional workarounds for this issue.
- Using ArcMap 10.x, make a local copy of the feature service for editing. Perform the edits against the local copy and then synchronize the edits back to the server.
- If the data is hosted on ArcGIS.com, use the ArcGIS.com map viewer to calculate fields. See the ArcGIS Online web help topic, Work with fields, for additional information.
- If the feature service is using an enterprise geodatabase as the back-end data storage mechanism, connect to the enterprise geodatabase directly in ArcGIS Pro to calculate the field values.