search

mobidata-bw / ipl-orchestration

MobiData-BW Integrationsplattform (IPL), an API platform that provides mobility data for Baden-Württemberg across many domains.
https://api.mobidata-bw.de
European Union Public License 1.2
0 stars 0 forks source link

Paged WFS requests for transit_stations_with_served_routes fail #270

Closed hbruch closed 2 weeks ago

hbruch commented 2 weeks ago

The following request WFS2.0.0 fails

https://api.mobidata-bw.de/geoserver/wfs?SERVICE=WFS&REQUEST=GetFeature&VERSION=2.0.0&SRSNAME=urn:ogc:def:crs:EPSG::4326&TYPENAME=MobiData-BW:transit_stations_with_served_routes&outputFormat=application/json&count=10&startIndex=5

<ows:ExceptionReport version="2.0.0" xsi:schemaLocation="http://www.opengis.net/ows/1.1 https://api.mobidata-bw.de/geoserver/schemas/ows/1.1.0/owsAll.xsd">
  <ows:Exception exceptionCode="NoApplicableCode">
    <ows:ExceptionText>
      java.lang.RuntimeExceptionCannot do natural order without a primary key, please add it or specify a manual sort over existing attributes
    </ows:ExceptionText>
  </ows:Exception>
</ows:ExceptionReport>

Reason is presumably that the (materialized) view geoserver.stations_with_served_routes which serves layers transit_stations_with_served_routes currently has no unique index.