Cannot Access Data when try to get sum of Shape.Len

447
5
08-11-2021 05:15 AM
Labels (2)
Hussam_AlJabri
Occasional Contributor II

Hi,

We’re facing an issue in ArcGIS Dashboards. When we tried to make statistics to get the sum of SHAPE.LEN of a linear assets the error “ Cannot Access Data” returned as shown in below snapshot:

Hussam_AlJabri_0-1628683837506.png

 

 

Also, we try to get the statistics from the WebMap itself but the below error pop-up:

 

Hussam_AlJabri_1-1628683837509.png

 

 

 

Please support us to figure out the root of the issue.

@DerekLaw 

@JakeSkinner 

 

Tags (1)
0 Kudos
5 Replies
JakeSkinner
Esri Esteemed Contributor

@Hussam_AlJabrilooks like there is an issue with the service.  Are you able to access the attribute table in the web map?

Hussam_AlJabri
Occasional Contributor II

Yes, I'm able to access and interact by filtering Shape.Len and other attributes in the webmap but can't do a statistics in the webmap and dashboard for the Shape.Len, although I can do it for other fields in the same feature service.

 

Basically I tried in Portal and ArcGIS Online and it behaved the same.

0 Kudos
DavidColey
Frequent Contributor

Hi - I can tell you this has been an issue with our dashboards as well for quite some time.  Probably since the winter 2020 arcgisonline update, can't say for sure.

Our workflow is thus: create hosted feature layer for (example: potable water mains) in enterprise 10.9 and collaborate by reference to arcgis online.  When we try to access the SHAPE__Length for summary statistics in dashboard elements we get the same error.  

When the error occurs, our hosting site logs the following REST error:

wMain/FeatureServer: 0 : ERROR: column "shape__length" does not exist Position: 12

When I host the layer directly to arcgis online, we do not get the error, and dashboard elements can access the shape_length field.  To me, this suggests the Dashboards elements want the geometry field(s) names are case-sensitive.

We overcame this temporarily by adding a double data type attribute field "CalcLength" and calculating the feature lengths.  We then use the attribute field for the statistics in dashboard elements.

I understand this workaround is not always possible for some.

@JakeSkinner 

0 Kudos
Hussam_AlJabri
Occasional Contributor II

As I said that I did add the feature service to the ArcGIS Online and Portal but produced the same error!

I thought about your workaround but the feature keep getting update in daily basis and I will keep it as a plan B as long as the issue still not solve!

 

are you still produce the same?

0 Kudos
DavidColey
Frequent Contributor

Yes, I have nothing new to add to this.  ArcGIS Online Hosted feature layers do not throw an error, layers accessed in arcgis online by reference (either from a collaboration or when accessed by 'add item' and providing a service url) do.