Re: [Geoserver-users] ERROR: zero-length delimited identifier at or near """"
On Mon, Feb 3, 2020 at 5:06 PM Nuno Oliveira
wrote:
> > WHERE "insp_transportnetwork"."" && ST_GeomFromText('POLYGON
> ((13.48338070627539 47.23134025656,
> > 13.48338070627539 47.38967827988002, 13.635281852129754
> 47.38967827988002, 13.635281852129754 47.23134025656,
> > 13.48338070627539 47.23134025656))', null)
>
> ... indeed its very strange and looks like a bug to me, that say its not
> clear were the polygon comes from, from a filter?
>
Hum... the "" attribute is a conventional name for the default geometry,
normally used in bbox filters, and stores should be converting it to the
name of the first geometry column found in the table. I don't know why it's
not happening, but wondering, app-schema does a bit
of its own sql building for joins... does it not? Could it be where it's
happening? Just a shot in the dark...
Cheers
Andrea
==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V
for more information. == Ing. Andrea Aime @geowolf Technical Lead
GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39
0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549
http://www.geo-solutions.it http://twitter.com/geosolutions_it
--- *Con riferimento
alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 -
Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni
circostanza inerente alla presente email (il suo contenuto, gli eventuali
allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i
destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per
errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le
sarei comunque grato se potesse darmene notizia. This email is intended
only for the person or entity to which it is addressed and may contain
information that is privileged, confidential or otherwise protected from
disclosure. We remind that - as provided by European Regulation 2016/679
“GDPR” - copying, dissemination or use of this e-mail or the information
herein by anyone other than the intended recipient is prohibited. If you
have received this email by mistake, please notify us immediately by
telephone or e-mail.*
___
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
Re: [Geoserver-users] ERROR: zero-length delimited identifier at or near """"
Dear Klaus,
in this case it would be important to know which action (creating
layer, WMS request, etc ...) resulted in the shared exception.
Looking at the SQL query:
> WHERE "insp_transportnetwork"."" && ST_GeomFromText('POLYGON
((13.48338070627539 47.23134025656,
> 13.48338070627539 47.38967827988002, 13.635281852129754
47.38967827988002, 13.635281852129754 47.23134025656,
> 13.48338070627539 47.23134025656))', null)
... indeed its very strange and looks like a bug to me, that say its
not clear were the polygon comes from, from a filter?
Kind regards,
Nuno Oliveira
On Tue, 2020-01-21 at 12:46 +, Gäbler Klaus wrote:
> 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_transportnetwor
> k"."geodatenstelle","tna"."insp_transportnetwork"."ds_md_fileidentifi
> er","tna"."insp_transportnetwork"."annex_theme","tna"."insp_transport
> network"."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_transportne
> twork"."inspireid_namespace","tna"."insp_transportnetwork"."beginlife
> spanversion","tna"."insp_transportnetwork"."geographicname","tna"."in
> sp_transportnetwork"."element_href","tna"."insp_transportnetwork"."ty
> peoftransport" 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.23134025656,
> 13.48338070627539 47.38967827988002, 13.635281852129754
> 47.38967827988002, 13.635281852129754 47.23134025656,
> 13.48338070627539 47.23134025656))', 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(ContentFeat
> ureCollection.java:165)
> at
> org.geotools.data.store.ContentFeatureCollection.features(ContentFeat
> ureCollection.java:52)
> at
> org.geotools.data.complex.DataAccessMappingFeatureIterator.initialise
> SourceFeatures(DataAccessMappingFeatureIterator.java:492)
> at
> org.geotools.data.complex.AbstractMappingFeatureIterator.(Abstr
> actMappingFeatureIterator.java:266)
> at
> org.geotools.data.complex.DataAccessMappingFeatureIterator.(Dat
> aAccessMappingFeatureIterator.java:173)
> at
> org.geotools.data.complex.MappingFeatureIteratorFactory.getInstance(M
> appingFeatureIteratorFactory.java:265)
> at
> org.geotools.data.complex.MappingFeatureIteratorFactory.getInstance(M
> appingFeatureIteratorFactory.java:118)
> at
> org.geotools.data.complex.MappingFeatureIteratorFactory.getInstance(M
> appingFeatureIteratorFactory.java:107)
> at
> org.geotools.data.complex.MappingFeatureCollection.features(MappingFe
> atureCollection.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.GML3OutputF
[Geoserver-users] ERROR: zero-length delimited identifier at or near """"
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.23134025656, 13.48338070627539 47.38967827988002, 13.635281852129754
47.38967827988002, 13.635281852129754 47.23134025656, 13.48338070627539
47.23134025656))', 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.(AbstractMappingFeatureIterator.java:266)
at
org.geotools.data.complex.DataAccessMappingFeatureIterator.(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.Framewor
