MapStore Widgets cannot retrieve Data from Postgres when connected to an attribute table

[Jo-Schie]

Expected Behavior

a widget such as a counter that is connected to an attribute table in the dashbaord should be able to retrieve information from the table (postgres) and perform some operation on it (e.g. "count", "sum", etc.).

If a filter is applied in one of the columns of the attribute tables, then the widget can retrieve the data.

Actual Behavior

Currently the retrieval of data fails if the whole attribute table is shown and no filter is applied. The frontend displays an error message.

"There was an error during data retrieval: "Cannot read properties of undefined (reading '0')"

The problem does not persist, if the counter is connected to the map and retrieval is done using bounding box.

Steps to Reproduce the Problem

1. Create Dashboard
2. Add Table
3. Add Counter and connect to table.

Example here: https://development.demo.geonode.org/catalogue/#/dashboard/2489

Specifications

• GeoNode version: 4.4.X and Master (both affected).

-> reproducible in both public demos of GeoNode

[giohappy]

Thanks @Jo-Schie for reporting this. I will pass this to the MapStore team, since the errors seems between MapStore and the WPS process in Geoserver.

I'm collecting here some technical insights that I will report to them.

The failing WPS request is the POST to https://development.demo.geonode.org/geoserver/wps?service=WPS&version=1.0.0&REQUEST=Execute

with the following payload, that contains an Aggregate operation and a Query with an empty Filter element, which is the problem here.

<?xml version="1.0" encoding="UTF-8"?>
<wps:Execute version="1.0.0" service="WPS"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://www.opengis.net/wps/1.0.0"
	xmlns:wfs="http://www.opengis.net/wfs"
	xmlns:wps="http://www.opengis.net/wps/1.0.0"
	xmlns:ows="http://www.opengis.net/ows/1.1"
	xmlns:gml="http://www.opengis.net/gml"
	xmlns:ogc="http://www.opengis.net/ogc"
	xmlns:wcs="http://www.opengis.net/wcs/1.1.1"
	xmlns:dwn="http://geoserver.org/wps/download"
	xmlns:xlink="http://www.w3.org/1999/xlink" xsi:schemaLocation="http://www.opengis.net/wps/1.0.0 http://schemas.opengis.net/wps/1.0.0/wpsAll.xsd">
	<ows:Identifier>gs:Aggregate</ows:Identifier>
	<wps:DataInputs>
		<wps:Input>
			<ows:Identifier>features</ows:Identifier>
			<wps:Reference mimeType="text/xml" xlink:href="http://geoserver/wfs" method="POST">
				<wps:Body>
					<wfs:GetFeature  outputFormat="GML2" service="WFS" version="1.0.0">
						<wfs:Query typeName="geonode:facilities_schools_health_clinics">
							<ogc:Filter></ogc:Filter>
						</wfs:Query>
					</wfs:GetFeature>
				</wps:Body>
			</wps:Reference>
		</wps:Input>
		<wps:Input>
			<ows:Identifier>aggregationAttribute</ows:Identifier>
			<wps:Data>
				<wps:LiteralData>id</wps:LiteralData>
			</wps:Data>
		</wps:Input>
		<wps:Input>
			<ows:Identifier>function</ows:Identifier>
			<wps:Data>
				<wps:LiteralData>Count</wps:LiteralData>
			</wps:Data>
		</wps:Input>
		<wps:Input>
			<ows:Identifier>singlePass</ows:Identifier>
			<wps:Data>
				<wps:LiteralData>false</wps:LiteralData>
			</wps:Data>
		</wps:Input>
	</wps:DataInputs>
	<wps:ResponseForm>
		<wps:RawDataOutput mimeType="application/json">
			<ows:Identifier>result</ows:Identifier>
		</wps:RawDataOutput>
	</wps:ResponseForm>
</wps:Execute>

The response contains the following exception:

<?xml version="1.0" encoding="UTF-8"?>
<ows:ExceptionReport xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:ows="http://www.opengis.net/ows/1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/ows/1.1 https://development.demo.geonode.org/geoserver/schemas/ows/1.1.0/owsAll.xsd">
    <ows:Exception exceptionCode="NoApplicableCode">
        <ows:ExceptionText>Could not parse XML request.
Parsing failed for Query: java.lang.RuntimeException: Unable to set property: Filter for eobject: {http://www.opengis.net/wfs}QueryType
Unable to set property: Filter for eobject: {http://www.opengis.net/wfs}QueryType
class java.lang.String cannot be cast to class org.geotools.api.filter.Filter (java.lang.String is in module java.base of loader &amp;apos;bootstrap&amp;apos;; org.geotools.api.filter.Filter is in unnamed module of loader org.apache.catalina.loader.ParallelWebappClassLoader @1c80e49b)</ows:ExceptionText>
    </ows:Exception>
</ows:ExceptionReport>

If we remove the empty Filter the request works as expected.

[giohappy]

MapStore issue geosolutions-it/MapStore2#11120