Dear all,
Another issue: when I replace the summation parameter from a simple column
name "sum(pur.lbs_prd_used)" to an equation "sum(pur.lbs_prd_used *
pc.prodchem_pct / 100)", I get the following error:
2017-02-17 18:24:29,758 DEBUG [org.geotools.util] - CRSConverter:
Converting object of class java.lang.String to
org.opengis.referencing.crs.CoordinateReferenceSystem
2017-02-17 18:24:29,759 DEBUG [org.geotools.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation
only.
2017-02-17 18:24:29,759 DEBUG [org.geotools.util] - CRSConverterFactory can
be applied from Strings to CRS only.
2017-02-17 18:24:29,759 DEBUG [org.geotools.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation
only.
2017-02-17 18:24:29,759 DEBUG [org.geotools.util] - CRSConverterFactory can
be applied from Strings to CRS only.
2017-02-17 18:24:29,760 DEBUG [org.geotools.styling] - number of fts set 1
2017-02-17 18:24:29,760 ERROR [org.geoserver.ows] -
org.geoserver.platform.ServiceException: 1 layers requested, but found 2
view params specified.
at
org.geoserver.wms.map.GetMapKvpRequestReader.read(GetMapKvpRequestReader.java:486)
at
org.geoserver.wms.map.GetMapKvpRequestReader.read(GetMapKvpRequestReader.java:84)
at
org.geoserver.ows.Dispatcher.parseRequestKVP(Dispatcher.java:1488)
at org.geoserver.ows.Dispatcher.dispatch(Dispatcher.java:674)
at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:258)
...
When running the raw SQL with the parameters replaced by what the client is
sending, everything works fine on the database. There is no query reported
in the log file, so I think it is failing before it hits the database.
Are there special characters like space, *, or /, that need to be escaped?
There are minimal changes to the query other than the summation variable,
which is why I'm looking there.
Thank you for any guidance you can give,
--Christopher
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
