Dear list

I have a service providing harmonized data.
The service works, only the storedquery 
urn:ogc:def:query:OGC-WFS::GetFeatureById throws an error

I get the first record to find an ID
https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?VERSION=2.0.0&SERVICE=WFS&REQUEST=GetFeature&typeNames=hy-n%3AWatercourseLink&count=1

GetFeature/FeatureID works ok
https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?VERSION=2.0.0&SERVICE=WFS&REQUEST=GetFeature&typeNames=hy-n%3AWatercourseLink&FeatureID=vha_waterloopsegment_100000

The stored query throws an error: Could not find feature with specified id
https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?SERVICE=WFS&REQUEST=GetFeature&VERSION=2.0.0&storedquery_id=urn%3Aogc%3Adef%3Aquery%3AOGC-WFS%3A%3AGetFeatureById&outputformat=application%2Fgml%2Bxml%3B%20version%3D3.2&id=vha_waterloopsegment_100000&typename=hy-n%3AWatercourseLink

I use Geoserver 2.15
Data is stored in sqlserver
I use the AppSchema extension (And I paste the definition below)

Is there something wrong in this definition. The storedquery works all right in 
my other services, that don't use the app schema extension.

For example
https://geoservices.beta.informatievlaanderen.be/overdrachtdiensten/Adressen/wfs?service=WFS&REQUEST=GetFeature&STOREDQUERY_ID=urn:ogc:def:query:OGC-WFS::GetFeatureById&ID=Adrespos.1000320856&typename=Adressen:Adrespos&outputformat=GML2

I examined the log files, but I couldn't find anyting more than "Could not find 
feature with specified id" (GEOTOOLS_DEVELOPER_LOGGING)

Thanks

Bart



        <targetTypes>
                <FeatureType>
                        
<schemaUri>http://inspire.ec.europa.eu/schemas/hy-n/4.0/HydroNetwork.xsd</schemaUri>
                </FeatureType>
        </targetTypes>
        <typeMappings>
                <FeatureTypeMapping>
                        <sourceDataStore>dataStore</sourceDataStore>
                        <sourceType>WatercourseLink</sourceType>
                        <targetElement>hy-n:WatercourseLink</targetElement>
                        <attributeMappings>
                                <AttributeMapping>
                                    
<targetAttribute>nns:beginLifespanVersion</targetAttribute>
                                    <sourceExpression>
                                        <OCQL>beginLifespanVersion</OCQL>
                                        </sourceExpression>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>nns:centrelineGeometry</targetAttribute>
                                        <idExpression>
                                                
<OCQL>strConcat('centrelineGeometry.', getId())</OCQL>
                                        </idExpression>
                                        <sourceExpression>
                                                <OCQL>SHAPE</OCQL>
                                        </sourceExpression>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>nns:fictitious</targetAttribute>
                                        <sourceExpression>
                                                <OCQL>fictitious</OCQL>
                                        </sourceExpression>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>hy-n:flowDirection</targetAttribute>
                                        <ClientProperty>
                                                <name>xlink:href</name>
                                                
<value>flowDirection_href</value>
                                        </ClientProperty>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>hy-n:WatercourseLink</targetAttribute>
                                        <idExpression>
                                                <OCQL>gml_id</OCQL>
                                        </idExpression>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>gml:identifier</targetAttribute>
                                        <sourceExpression>
                                                <OCQL>gml_identifier</OCQL>
                                        </sourceExpression>
                                        <ClientProperty>
                                                <name>codeSpace</name>
                                                <value>gml_codespace</value>
                                        </ClientProperty>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>nns:inNetwork</targetAttribute>
                                        <ClientProperty>
                                                <name>nilReason</name>
                                                <value>inNetwork</value>
                                        </ClientProperty>
                                        <ClientProperty>
                                                <name>xsi:nil</name>
                                                
<value>if_then_else(isNull(inNetwork), Expression.NIL, 'true')</value>
                                        </ClientProperty>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>nns:inspireId/base:Identifier/base:localId</targetAttribute>
                                        <sourceExpression>
                                                <OCQL>inspireId_localId</OCQL>
                                        </sourceExpression>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>nns:inspireId/base:Identifier/base:namespace</targetAttribute>
                                        <sourceExpression>
                                                <OCQL>inspireId_namespace</OCQL>
                                        </sourceExpression>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>hy-n:length</targetAttribute>
                                        <sourceExpression>
                                                <OCQL>length</OCQL>
                                        </sourceExpression>
                                        <ClientProperty>
                                                <name>xsi:nil</name>
                                                
<value>if_then_else(isNull(length), 'true', Expression.NIL)</value>
                                        </ClientProperty>
                                        <ClientProperty>
                                                <name>uom</name>
                                                <value>length_uom</value>
                                        </ClientProperty>
                                </AttributeMapping>
                                <AttributeMapping>
                                        
<targetAttribute>nns:inspireId/base:Identifier/base:versionId</targetAttribute>
                                        <sourceExpression>
                                                <OCQL>inspireId_versionId</OCQL>
                                        </sourceExpression>
                                </AttributeMapping>
                        </attributeMappings>
                </FeatureTypeMapping>
        </typeMappings>

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to