search

clarity-h2020 / emikat

http://www.emikat.at/?lang=en
1 stars 0 forks source link

EMIKAT WMS doesn't accept parameter SZ_ID #47

Closed p-a-s-c-a-l closed 4 years ago

p-a-s-c-a-l commented 4 years ago

Heat Wave HC-LE Maps not working any more after recalculating studies 33 and 35:

This is the WMS request:

https://service.emikat.at/geoserver/clarity/wms?CQL_FILTER=STUDY_VARIANT=%27BASELINE%27%20and%20TIME_PERIOD=%2720410101-20701231%27%20AND%20EMISSIONS_SCENARIO=%27rcp45%27%20AND%20EVENT_FREQUENCY=%27Rare%27%20AND%20SZ_ID=3189&&service=WMS&request=GetMap&version=1.1.1&layers=clarity%3Aview.2974&styles=T_MRT%0D%0A&format=image%2Fpng&transparent=true&tileSize=1536&info_format=application%2Fjson&width=608&height=496&srs=EPSG%3A3857&bbox=2635682.5000723763%2C4564590.018105872%2C2647300.9283717233%2C4574068.209613231

This is the WMS response:

<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE ServiceExceptionReport SYSTEM "https://service.emikat.at/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd"> <ServiceExceptionReport version="1.1.1" >   <ServiceException code="internalError">
      Rendering process failed
EMIKAT-Server.DB.ConnectionProblem: Can&apos;t access db: java.sql.SQLSyntaxErrorException: ORA-00904: &quot;SZ_ID&quot;: ung?ltiger Bezeichner
 - 
EMIKAT-Server.DB.ConnectionProblem: Can&apos;t access db: java.sql.SQLSyntaxErrorException: ORA-00904: &quot;SZ_ID&quot;: ung?ltiger Bezeichner
 - 
</ServiceException></ServiceExceptionReport>

Note: In Exposure Maps for example, SZ_ID is working:

https://service.emikat.at/geoserver/clarity/wms?CQL_FILTER=SZ_ID=3209&service=WMS&request=GetMap&version=1.1.1&layers=clarity%3Aview.2955&styles=&format=image%2Fpng&transparent=true&tileSize=1536&info_format=application%2Fjson&width=608&height=796&srs=EPSG%3A3857&bbox=2622332.2953509437%2C5791737.539753132%2C2623058.447119653%2C5792688.225292428

image

humerh commented 4 years ago

There was a configuration problem. It should be solved.

p-a-s-c-a-l commented 4 years ago

works again, thanks!