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
