ayuda

126 views

Skip to first unread message

MRA

unread,

Dec 27, 2011, 4:32:41 PM12/27/11

to geoser...@googlegroups.com

Hola,
Disculpen la molestia pero me agradaría un poco de ayuda con una consulta getfeature info sobre una capa WMS que se construye a travez de un sql paramétric view de una base de datos pgsql + postgis.

La peticion es:

GET /geoserver/wms?REQUEST=GetFeatureInfo&EXCEPTIONS=application/vnd.ogc.se_xml&BBOX=-6402134.637611,-2912061.295384,-6398871.731967,-2909022.92351&SERVICE=WMS&VERSION=1.1.1&X=609&Y=247&INFO_FORMAT=text/html&QUERY_LAYERS=Consulta&FEATURE_COUNT=50&Layers=Consulta&viewparams=cap:Lotes%20Luque;op1:=;zon:27&WIDTH=683&HEIGHT=636&format=image/png&Charset=utf-8&styles=&srs=EPSG:900913 HTTP/1.1
Host: 170.10.10.57:8008
Connection: close
Content-type: application/x-www-form-urlencoded
Content-length: 361

y el me devuelve este documento (incluyoo las cabeceras aunque creo que estan correctas)

HTTP/1.1 200 OK

Content-Type: application/vnd.ogc.se_xml; charset=UTF-8

Connection: close

Server: Jetty(6.1.8)

<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE ServiceExceptionReport SYSTEM "http://170.10.10.57:8008/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd"> <ServiceExceptionReport version="1.1.1" >   <ServiceException>

      Internal error occurred

java.io.IOException

null

ERROR: Operation on mixed SRID geometries

</ServiceException></ServiceExceptionReport>

y el log se me llena con:

2011-12-27 18:26:02,702 INFO [geoserver.wms] -

Request: getServiceInfo

2011-12-27 18:26:02,740 ERROR [geoserver.ows] -

org.geoserver.platform.ServiceException: Internal error occurred

at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:177)

at org.geoserver.wms.GetFeatureInfo.run(GetFeatureInfo.java:122)

at org.geoserver.wms.DefaultWebMapService.getFeatureInfo(DefaultWebMapService.java:371)

at sun.reflect.GeneratedMethodAccessor229.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

at org.geoserver.ows.util.RequestObjectLogger.invoke(RequestObjectLogger.java:51)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy26.getFeatureInfo(Unknown Source)

at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:630)

at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)

at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74)

at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394)

at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)

at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)

at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)

at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)

at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)

at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)

at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185)

at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:46)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)

at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)

at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)

at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)

at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)

at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

at org.mortbay.jetty.Server.handle(Server.java:324)

at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)

at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)

at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)

at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)

at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)

at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)

at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)

Caused by: java.lang.RuntimeException: java.io.IOException

at org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:354)

at org.geotools.feature.collection.DecoratingSimpleFeatureCollection.size(DecoratingSimpleFeatureCollection.java:176)

at org.geotools.data.crs.ForceCoordinateSystemFeatureResults.size(ForceCoordinateSystemFeatureResults.java:105)

at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:278)

at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:173)

... 79 more

Caused by: java.io.IOException

at org.geotools.jdbc.JDBCDataStore.getAggregateValue(JDBCDataStore.java:1289)

at org.geotools.jdbc.JDBCDataStore.getCount(JDBCDataStore.java:1219)

at org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:409)

at org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:413)

at org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:327)

... 83 more

Caused by: org.postgresql.util.PSQLException: ERROR: Operation on mixed SRID geometries

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)

at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

at org.geotools.jdbc.JDBCDataStore.getAggregateValue(JDBCDataStore.java:1269)

... 87 more

Como se darán cuenta esta petición tiene parámetros básicos, el proyecto requiere de consultas un poco mas complejas en algunos casos y no tengo idea de lo que esta pasando, por cierto siempre se muestra correctamente la capa en openlayers y me devuelve datos correctos si no le paso parámetros por viewparams.