laptop and a wrench

Bug

When editing a feature service in ArcGIS Pro with attribute rules applied, the error message is returned, "Unable to complete operation. Setting of value for md_variance failed."

Last Published: April 16, 2021 ArcGIS Pro
Bug ID Number BUG-000138376
SubmittedMarch 23, 2021
Last ModifiedJune 5, 2024
Applies toArcGIS Pro
Version found2.7.1
Operating SystemWindows OS
Operating System VersionN/A
StatusWill Not Be Addressed

Additional Information

User error. The original Arcade script uses {return "null"}, which returns a string of "null" to a double field, causing cast error.

Workaround

The correct script:

=======================================

var startDate = date($feature.md_planned);

var endDate = date($feature.md_actual);

var Diff = DateDiff(endDate, startDate, 'days');

var FinVar = Diff/30.5;

If (IsEmpty(startDate) || IsEmpty(endDate))

{ return null; }

else return FinVar

=======================================

Steps to Reproduce

Bug ID: BUG-000138376

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options