topic Re: Cannot Access Data when try to get sum of Shape.Len in ArcGIS Dashboards Questions

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

Hussam_AlJabri — Wed, 11 Aug 2021 12:15:24 GMT

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:

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

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

@DerekLaw

@JakeSkinner

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

JakeSkinner — Wed, 11 Aug 2021 12:52:36 GMT

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

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

DavidColey — Wed, 11 Aug 2021 14:37:28 GMT

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

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

Hussam_AlJabri — Wed, 11 Aug 2021 19:24:23 GMT

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.

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

Hussam_AlJabri — Wed, 11 Aug 2021 19:21:59 GMT

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?

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

DavidColey — Thu, 12 Aug 2021 13:55:22 GMT

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.

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

shildebrand — Tue, 14 Dec 2021 20:22:44 GMT

Also have the same problem. Any updates?

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

Hussam_AlJabri — Sun, 19 Dec 2021 04:21:29 GMT

I found a BUG-000132927 that the services registered with the Oracle database will not allow us to get the statistics of the Shape.Len or Shap.Area

The workaround is to create a one-way parent-to-child replica to a file geodatabase and use it for creating the dashboard.