Hi Farouk,

I just tried a similar change and it worked fine. can you provide the
original schema of the table? Thanks.

-Justin

On Fri, Sep 10, 2010 at 3:34 AM, farouk alhassan <[email protected]>wrote:

> Hi all,
> i created this sql view layer and it worked fine in preview
>
> SELECT
> st_union(the_geom),
> file_name
>   FROM district_borough_unitary_region
>   group by file_name
>
> Now I want to modify it to this
>
> SELECT
> ST_Multi(ST_Union(the_geom)),
> file_name
>   FROM district_borough_unitary_region
>   group by file_name
>
> But its throwing execptions with this stacktrace, [Notce the NPE as the
> cause]
>
>
> org.apache.wicket.WicketRuntimeException: Error attaching this container
> for rendering: [MarkupContainer [Component id = attributePanel]] at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1602)
> at org.apache.wicket.Component.onBeforeRender(Component.java:3727) at
> org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1590)
> at org.apache.wicket.Component.onBeforeRender(Component.java:3727) at
> org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1590)
> at org.apache.wicket.Component.onBeforeRender(Component.java:3727) at
> org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1590)
> at org.apache.wicket.Component.onBeforeRender(Component.java:3727) at
> org.apache.wicket.markup.repeater.AbstractRepeater.onBeforeRender(AbstractRepeater.java:147)
> at org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1590)
> at org.apache.wicket.Component.onBeforeRender(Component.java:3727) at
> org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1590)
> at org.apache.wicket.Component.onBeforeRender(Component.java:3727) at
> org.apache.wicket.extensions.markup.html.tabs.TabbedPanel.onBeforeRender(TabbedPanel.java:205)
> at org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1590)
> at org.apache.wicket.Component.onBeforeRender(Component.java:3727) at
> org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1590)
> at org.apache.wicket.Component.onBeforeRender(Component.java:3727) at
> org.apache.wicket.Page.onBeforeRender(Page.java:1458) at
> org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.Component.prepareForRender(Component.java:2167) at
> org.apache.wicket.Page.renderPage(Page.java:892) at
> org.apache.wicket.protocol.http.WebRequestCycle.redirectTo(WebRequestCycle.java:163)
> at
> org.apache.wicket.request.target.component.PageRequestTarget.respond(PageRequestTarget.java:58)
> at
> org.apache.wicket.request.AbstractRequestCycleProcessor.respond(AbstractRequestCycleProcessor.java:104)
> at
> org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1245)
> at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316) at
> org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418) at
> org.apache.wicket.RequestCycle.request(RequestCycle.java:532) at
> org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356) at
> org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:145)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:158)
> 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.doPost(FrameworkServlet.java:511)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:48)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
> at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
> at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at
> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at
> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at
> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at
> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
> at
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> at
> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
> at
> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
> at java.lang.Thread.run(Thread.java:619) Caused by:
> java.lang.NullPointerException at
> org.geoserver.web.data.resource.FeatureResourceConfigurationPanel$2.populateItem(FeatureResourceConfigurationPanel.java:78)
> at org.apache.wicket.markup.html.list.ListView.onPopulate(ListView.java:573)
> at
> org.apache.wicket.markup.repeater.AbstractRepeater.onBeforeRender(AbstractRepeater.java:127)
> at org.apache.wicket.Component.internalBeforeRender(Component.java:1009) at
> org.apache.wicket.Component.beforeRender(Component.java:1041) at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1590)
> ... 108 more
>
>
>
> ------------------------------------------------------------------------------
> Automate Storage Tiering Simply
> Optimize IT performance and efficiency through flexible, powerful,
> automated storage tiering capabilities. View this brief to learn how
> you can reduce costs and improve performance.
> http://p.sf.net/sfu/dell-sfdev2dev
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to