Dear list users,
we are currently testing GS 2.16.1, based on CentOS 7.7, Tomcat 8.5.50, OpenJDK
1.8.0 and PostgreSQL 11.
When running an AppSchema based on a view in PostgreSQL we encountered the
error below.
Neither the underlying view in the DB nor the resulting app schema feature has
a geometry column involved.
The offending SQL part from GS of the request is
WHERE "insp_transportnetwork"."" && St_geomfromtext(
The same AppSchema is working nicely in GS 2.15.0.
Any ideas how to avoid this error?
Thanks in advance!
Klaus
2020-01-21 11:21:31,869 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2020-01-21 11:21:31,870 DEBUG [org.geotools.data.jdbc] - exporting PropertyName
2020-01-21 11:21:31,871 DEBUG [org.geotools.data.jdbc] - exporting
LiteralExpression
2020-01-21 11:21:31,871 DEBUG [org.geotools.data.util] - CRSConverterFactory
can be applied from Strings to CRS only.
2020-01-21 11:21:31,872 DEBUG [org.geotools.data.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation only.
2020-01-21 11:21:31,873 DEBUG [org.geotools.jdbc] - SELECT
"tna"."insp_transportnetwork"."statename","tna"."insp_transportnetwork"."geodatenstelle","tna"."insp_transportnetwork"."ds_md_fileidentifier","tna"."insp_transportnetwork"."annex_theme","tna"."insp_transportnetwork"."featuretype","tna"."insp_transportnetwork"."localid","tna"."insp_transportnetwork"."namespace_base","tna"."insp_transportnetwork"."gml_identifier_codespace","tna"."insp_transportnetwork"."gml_id","tna"."insp_transportnetwork"."gml_identifier","tna"."insp_transportnetwork"."inspireid_namespace","tna"."insp_transportnetwork"."beginlifespanversion","tna"."insp_transportnetwork"."geographicname","tna"."insp_transportnetwork"."element_href","tna"."insp_transportnetwork"."typeoftransport"
FROM "tna"."insp_transportnetwork" INNER JOIN (SELECT DISTINCT
"tna"."insp_transportnetwork"."gml_id" FROM "tna"."insp_transportnetwork" WHERE
"insp_transportnetwork"."" && ST_GeomFromText('POLYGON ((13.48338070627539
47.237777134025656, 13.48338070627539 47.38967827988002, 13.635281852129754
47.38967827988002, 13.635281852129754 47.237777134025656, 13.48338070627539
47.237777134025656))', null) ORDER BY "tna"."insp_transportnetwork"."gml_id"
ASC LIMIT 3) "insp_transportnetwor_1" ON ("insp_transportnetwork"."gml_id" =
"insp_transportnetwor_1"."gml_id" ) ORDER BY
"tna"."insp_transportnetwork"."gml_id" ASC
2020-01-21 11:21:31,876 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2020-01-21 11:21:31,877 INFO [org.vfny.geoserver.servlets] - OutputStream was
successfully aborted.
2020-01-21 11:21:31,878 ERROR [org.geoserver.ows] -
java.lang.RuntimeException: java.io.IOException
at
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:165)
at
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:52)
at
org.geotools.data.complex.DataAccessMappingFeatureIterator.initialiseSourceFeatures(DataAccessMappingFeatureIterator.java:492)
at
org.geotools.data.complex.AbstractMappingFeatureIterator.<init>(AbstractMappingFeatureIterator.java:266)
at
org.geotools.data.complex.DataAccessMappingFeatureIterator.<init>(DataAccessMappingFeatureIterator.java:173)
at
org.geotools.data.complex.MappingFeatureIteratorFactory.getInstance(MappingFeatureIteratorFactory.java:265)
at
org.geotools.data.complex.MappingFeatureIteratorFactory.getInstance(MappingFeatureIteratorFactory.java:118)
at
org.geotools.data.complex.MappingFeatureIteratorFactory.getInstance(MappingFeatureIteratorFactory.java:107)
at
org.geotools.data.complex.MappingFeatureCollection.features(MappingFeatureCollection.java:164)
at
org.geotools.feature.collection.DecoratingFeatureCollection.features(DecoratingFeatureCollection.java:68)
at org.geotools.xsd.Encoder.encode(Encoder.java:1096)
at org.geotools.xsd.Encoder.encode(Encoder.java:552)
at
org.geoserver.wfs.xml.GML32OutputFormat.encode(GML32OutputFormat.java:151)
at
org.geoserver.wfs.xml.GML3OutputFormat.complexFeatureStreamIntercept(GML3OutputFormat.java:412)
at org.geoserver.wfs.xml.GML3OutputFormat.write(GML3OutputFormat.java:310)
at
org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:198)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:1031)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:269)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:52)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998)
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:26)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:69)
at org.geoserver.monitor.MonitorFilter.doFilter(MonitorFilter.java:140)
at
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:66)
at
org.geoserver.flow.controller.IpBlacklistFilter.doFilter(IpBlacklistFilter.java:89)
at
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:66)
at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:73)
at
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:66)
at
org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:37)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74)
at
org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74)
at
org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at
org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:51)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74)
at
org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
at
org.geoserver.security.filter.GeoServerBasicAuthenticationFilter.doFilter(GeoServerBasicAuthenticationFilter.java:81)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at
org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:52)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74)
at
org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at
org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:142)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:101)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.geoserver.filters.XFrameOptionsFilter.doFilter(XFrameOptionsFilter.java:79)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:46)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:42)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:609)
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623)
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.IOException
at
org.geotools.appschema.jdbc.JoiningJDBCFeatureSource.getJoiningReaderInternal(JoiningJDBCFeatureSource.java:1244)
at
org.geotools.appschema.jdbc.JoiningJDBCFeatureSource.getReaderInternal(JoiningJDBCFeatureSource.java:1363)
at
org.geotools.data.store.ContentFeatureSource.getReader(ContentFeatureSource.java:609)
at
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:163)
... 117 more
Caused by: java.sql.SQLException: org.postgresql.util.PSQLException: ERROR:
zero-length delimited identifier at or near """"
Position: 880
at org.geotools.jdbc.JDBCFeatureReader.runQuery(JDBCFeatureReader.java:263)
at org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:143)
at
org.geotools.appschema.jdbc.JoiningJDBCFeatureSource.getJoiningReaderInternal(JoiningJDBCFeatureSource.java:1238)
... 120 more
Caused by: org.postgresql.util.PSQLException: ERROR: zero-length delimited
identifier at or near """"
Position: 880
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.jdbc.JDBCFeatureReader.lambda$new$0(JDBCFeatureReader.java:143)
at org.geotools.jdbc.JDBCFeatureReader.runQuery(JDBCFeatureReader.java:252)
... 122 more
2020-01-21 11:21:31,899 INFO [org.geoserver.flow] - releasing flow controllers
for [WFS 2.0.0 GetFeature]
2020-01-21 11:21:31,900 INFO [org.geoserver.flow] - Request completed, running
requests: 0, blocked requests: 0
Wichtiger Hinweis: Diese E-Mail Nachricht kann Betriebs- oder
Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Wenn
Sie nicht der Adressat sind und diese Nachricht irrtümlich erhalten haben, ist
Ihnen eine Verwendung des Inhalts, eine Vervielfältigung oder Weitergabe dieser
Nachricht ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten
Sie die empfangene Nachricht. Vielen Dank. Please Note: This e-mail message may
contain trade secrets or privileged, undisclosed or otherwise confidential
information. If you are not the intended recipient and have received this
message in error or by mistake any unauthorized use, reproduction or
distribution of this message is strictly prohibited. Please notify us
immediately and destroy the original transmittal. Thank you for your
cooperation. Austro Control Österreichische Gesellschaft für Zivilluftfahrt mit
beschränkter Haftung Sitz/Registered address: Wien/ Vienna; Registriert
unter/registered under: FN 71000m Competent court/Firmenbuchgericht: HG
Wien/commercial court Vienna; Rechtsform/legal form: GmbH Postanschrift/postal
address: Wagramer Straße 19 - 1220 Wien/Vienna DVR: 0447277 ?
_______________________________________________
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
