[Geoserver-users] Problems with an ArcSDE datastore

GeoServer GeoServer User
1

Hi Everyone,

I am trying to get a ArcSDE datastore up and running and seem to be
running into some problems. I am not sure if it has anything to do
with the names of the feature classes, so I thought I would check here
first. I am able to create a new feature class in geoserver, and i am
able to get to it through a WFS connection but a lot of errors are
produced in the log. It does seem to work though. However, I cannot
get anything out of the WMS connection through even the most simple of
SLDs. I thought it might have to do with the styled layer descriptor,
but even the simple "polygon" does not work. The name of the layer is
OMS.OMS.WHO_REG, and I thought that the periods might cause a
problem.

I am using the latest 1.5.4 version with an ArcSDE 9.1 /MS-SQL setup.
I am using the 9.1 jars and the 1.5.4 version extension for geoserver.

Here is a typical snippet from the log when I make a WMS request to output KML.

Thanks for any tips.

Best regards,
Jason

Nov 13, 2007 5:34:00 PM org.vfny.geoserver.servlets.AbstractService doService
INFO: Service handled
Nov 13, 2007 5:34:20 PM
org.vfny.geoserver.wms.requests.GetMapKvpReader
parseOptionalParameters
INFO: Set KMScore: 50
Nov 13, 2007 5:34:20 PM org.vfny.geoserver.servlets.AbstractService doService
INFO: handling request:
GetMap Request
version: 1.1.1
output format: application/vnd.google-earth.kmz XML
width height: 1024,1024
bbox: Env[-50.81813868472601 : 93.77489215952886, -29.96974386011042
: 54.43714880180336]
layers: WHO:OMS.OMS.WHO_REG
styles: OMS.OMS.WHO_REG_style
Nov 13, 2007 5:34:29 PM org.geotools.data.arcsde.ArcSDEQuery getQueryColumns
INFO: No FID attribute was contained in your query. Appending the
discovered one to the list of columns to be fetched.
Nov 13, 2007 5:34:29 PM org.geotools.renderer.lite.StreamingRenderer
processStylers
SEVERE: Wrong number of attributes expected 2 got 3
IllegalAttribute: null , but got null
        at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
        at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
        at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
        at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
        at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
        at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
        at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
        at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
        at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
        at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
        at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
        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:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        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:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Nov 13, 2007 5:34:30 PM org.geotools.renderer.lite.StreamingRenderer
processStylers
SEVERE: Wrong number of attributes expected 2 got 3
IllegalAttribute: null , but got null
        at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
        at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
        at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
        at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
        at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
        at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
        at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
        at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
        at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
        at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
        at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
        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:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        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:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Nov 13, 2007 5:34:30 PM org.geotools.renderer.lite.StreamingRenderer
processStylers
SEVERE: Wrong number of attributes expected 2 got 3
IllegalAttribute: null , but got null
        at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
        at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
        at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
        at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
        at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
        at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
        at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
        at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
        at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
        at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
        at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
        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:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        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:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

2

Jason,

I'd suggest that you try the 1.6.x series of geoserver for it's
much-improved ArcSDE support.

Here's how to do that:

1) Download the latest geoserver beta (or nightly build, if you like).
2) Deploy it without adding anything ArcSDE related. Check that it's
working (say, with a shapefile). WFS should be good, and so should WMS.
3) Grab this file
http://lists.refractions.net/m2/org/geotools/gt2-arcsde/2.4-SNAPSHOT/gt2-arcsde-2.4-SNAPSHOT.jar and put it into your geoserver/WEB-INF/lib directory
4) Put your two jsde_api91.jar and jsde_jpe91.jar files into the
geoserver/WEB-INF/lib directory as well.
5) Restart the whole she-bang and it should work much better.

Good luck!
--saul

On Tue, 2007-11-13 at 17:46 +0100, Jason Pickering wrote:

Hi Everyone,

I am trying to get a ArcSDE datastore up and running and seem to be
running into some problems. I am not sure if it has anything to do
with the names of the feature classes, so I thought I would check here
first. I am able to create a new feature class in geoserver, and i am
able to get to it through a WFS connection but a lot of errors are
produced in the log. It does seem to work though. However, I cannot
get anything out of the WMS connection through even the most simple of
SLDs. I thought it might have to do with the styled layer descriptor,
but even the simple "polygon" does not work. The name of the layer is
OMS.OMS.WHO_REG, and I thought that the periods might cause a
problem.

I am using the latest 1.5.4 version with an ArcSDE 9.1 /MS-SQL setup.
I am using the 9.1 jars and the 1.5.4 version extension for geoserver.

Here is a typical snippet from the log when I make a WMS request to output KML.

Thanks for any tips.

Best regards,
Jason

Nov 13, 2007 5:34:00 PM org.vfny.geoserver.servlets.AbstractService doService
INFO: Service handled
Nov 13, 2007 5:34:20 PM
org.vfny.geoserver.wms.requests.GetMapKvpReader
parseOptionalParameters
INFO: Set KMScore: 50
Nov 13, 2007 5:34:20 PM org.vfny.geoserver.servlets.AbstractService doService
INFO: handling request:
GetMap Request
version: 1.1.1
output format: application/vnd.google-earth.kmz XML
width height: 1024,1024
bbox: Env[-50.81813868472601 : 93.77489215952886, -29.96974386011042
: 54.43714880180336]
layers: WHO:OMS.OMS.WHO_REG
styles: OMS.OMS.WHO_REG_style
Nov 13, 2007 5:34:29 PM org.geotools.data.arcsde.ArcSDEQuery getQueryColumns
INFO: No FID attribute was contained in your query. Appending the
discovered one to the list of columns to be fetched.
Nov 13, 2007 5:34:29 PM org.geotools.renderer.lite.StreamingRenderer
processStylers
SEVERE: Wrong number of attributes expected 2 got 3
IllegalAttribute: null , but got null
        at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
        at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
        at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
        at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
        at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
        at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
        at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
        at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
        at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
        at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
        at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
        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:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        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:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Nov 13, 2007 5:34:30 PM org.geotools.renderer.lite.StreamingRenderer
processStylers
SEVERE: Wrong number of attributes expected 2 got 3
IllegalAttribute: null , but got null
        at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
        at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
        at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
        at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
        at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
        at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
        at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
        at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
        at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
        at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
        at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
        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:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        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:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Nov 13, 2007 5:34:30 PM org.geotools.renderer.lite.StreamingRenderer
processStylers
SEVERE: Wrong number of attributes expected 2 got 3
IllegalAttribute: null , but got null
        at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
        at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
        at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
        at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
        at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
        at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
        at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
        at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
        at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
        at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
        at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
        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:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        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:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

3

Hi Saul,

After some other nasty problems that I worked out with the help of
everyone on the IRC channel, I installed the nightly build, along with
the link below. WMS, WFS and everything are behaving apparently
normally. SDE is not working on this build though. It is not available
when I try and add a new data store.

Any idea what is wrong?

Best regards,
Jason

Here is a snippet from the log..

14 Nov 13:42:24 WARN [org.geotools] - Can't load a service for
category "DataStoreFactorySpi". Cause is "NoClassDefFoundError:
org/geotools/util/logging/Logging".
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'DS_poi:::poi' (layer 2/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'DS_poly_landmarks:::poly_landmarks' (layer 3/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'DS_tiger_roads:::tiger_roads' (layer 4/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfArchsites:::archsites' (layer 5/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfBugsites:::bugsites' (layer 6/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfRestricted:::restricted' (layer 7/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfRoads:::roads' (layer 8/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfStreams:::streams' (layer 9/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'states_shapefile:::states' (layer 10/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'tasmania_cities:::tasmania_cities' (layer 11/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'tasmania_roads:::tasmania_roads' (layer 12/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'tasmania_state_boundaries:::tasmania_state_boundaries' (layer 13/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'tasmania_water_bodies:::tasmania_water_bodies' (layer 14/14)
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".

On Nov 13, 2007 6:01 PM, Saul Farber <sjf8@anonymised.com> wrote:

Jason,

I'd suggest that you try the 1.6.x series of geoserver for it's
much-improved ArcSDE support.

Here's how to do that:

1) Download the latest geoserver beta (or nightly build, if you like).
2) Deploy it without adding anything ArcSDE related. Check that it's
working (say, with a shapefile). WFS should be good, and so should WMS.
3) Grab this file
http://lists.refractions.net/m2/org/geotools/gt2-arcsde/2.4-SNAPSHOT/gt2-arcsde-2.4-SNAPSHOT.jar and put it into your geoserver/WEB-INF/lib directory
4) Put your two jsde_api91.jar and jsde_jpe91.jar files into the
geoserver/WEB-INF/lib directory as well.
5) Restart the whole she-bang and it should work much better.

Good luck!
--saul

On Tue, 2007-11-13 at 17:46 +0100, Jason Pickering wrote:
> Hi Everyone,
>
> I am trying to get a ArcSDE datastore up and running and seem to be
> running into some problems. I am not sure if it has anything to do
> with the names of the feature classes, so I thought I would check here
> first. I am able to create a new feature class in geoserver, and i am
> able to get to it through a WFS connection but a lot of errors are
> produced in the log. It does seem to work though. However, I cannot
> get anything out of the WMS connection through even the most simple of
> SLDs. I thought it might have to do with the styled layer descriptor,
> but even the simple "polygon" does not work. The name of the layer is
> OMS.OMS.WHO_REG, and I thought that the periods might cause a
> problem.
>
> I am using the latest 1.5.4 version with an ArcSDE 9.1 /MS-SQL setup.
> I am using the 9.1 jars and the 1.5.4 version extension for geoserver.
>
> Here is a typical snippet from the log when I make a WMS request to output KML.
>
> Thanks for any tips.
>
> Best regards,
> Jason
>
>
>
> Nov 13, 2007 5:34:00 PM org.vfny.geoserver.servlets.AbstractService doService
> INFO: Service handled
> Nov 13, 2007 5:34:20 PM
> org.vfny.geoserver.wms.requests.GetMapKvpReader
> parseOptionalParameters
> INFO: Set KMScore: 50
> Nov 13, 2007 5:34:20 PM org.vfny.geoserver.servlets.AbstractService doService
> INFO: handling request:
> GetMap Request
> version: 1.1.1
> output format: application/vnd.google-earth.kmz XML
> width height: 1024,1024
> bbox: Env[-50.81813868472601 : 93.77489215952886, -29.96974386011042
> : 54.43714880180336]
> layers: WHO:OMS.OMS.WHO_REG
> styles: OMS.OMS.WHO_REG_style
> Nov 13, 2007 5:34:29 PM org.geotools.data.arcsde.ArcSDEQuery getQueryColumns
> INFO: No FID attribute was contained in your query. Appending the
> discovered one to the list of columns to be fetched.
> Nov 13, 2007 5:34:29 PM org.geotools.renderer.lite.StreamingRenderer
> processStylers
> SEVERE: Wrong number of attributes expected 2 got 3
> IllegalAttribute: null , but got null
> at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
> at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
> at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
> at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
> at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
> at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
> at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
> at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
> at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
> at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
> at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
> at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
> at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
> at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
> at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
> at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
> at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
> at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
> 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:175)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> 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:263)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> at java.lang.Thread.run(Thread.java:619)
> Nov 13, 2007 5:34:30 PM org.geotools.renderer.lite.StreamingRenderer
> processStylers
> SEVERE: Wrong number of attributes expected 2 got 3
> IllegalAttribute: null , but got null
> at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
> at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
> at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
> at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
> at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
> at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
> at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
> at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
> at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
> at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
> at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
> at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
> at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
> at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
> at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
> at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
> at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
> at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
> 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:175)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> 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:263)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> at java.lang.Thread.run(Thread.java:619)
> Nov 13, 2007 5:34:30 PM org.geotools.renderer.lite.StreamingRenderer
> processStylers
> SEVERE: Wrong number of attributes expected 2 got 3
> IllegalAttribute: null , but got null
> at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
> at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
> at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
> at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
> at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
> at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
> at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
> at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
> at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
> at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
> at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
> at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
> at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
> at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
> at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
> at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
> at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
> at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
> 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:175)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> 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:263)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

4

Jason,

Hmm. Those errors are very strange.

Can you try this?

1) Remove ALL featuretypes from your data_dir (or however you've got GS
configured)

2) Put the three arcsde jarfiles in place (gt2-arcsde-XXX.jar,
jsde_api91.jar and jsde_jpe91.jar)

3) Start up geoserver 'empty' and see if you get any strange error
messages on startup.

If there are errors in step 3, can you send them along in another email?

thanks,
--saul

On Wed, 2007-11-14 at 14:46 +0100, Jason Pickering wrote:

Hi Saul,

After some other nasty problems that I worked out with the help of
everyone on the IRC channel, I installed the nightly build, along with
the link below. WMS, WFS and everything are behaving apparently
normally. SDE is not working on this build though. It is not available
when I try and add a new data store.

Any idea what is wrong?

Best regards,
Jason

Here is a snippet from the log..

14 Nov 13:42:24 WARN [org.geotools] - Can't load a service for
category "DataStoreFactorySpi". Cause is "NoClassDefFoundError:
org/geotools/util/logging/Logging".
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'DS_poi:::poi' (layer 2/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'DS_poly_landmarks:::poly_landmarks' (layer 3/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'DS_tiger_roads:::tiger_roads' (layer 4/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfArchsites:::archsites' (layer 5/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfBugsites:::bugsites' (layer 6/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfRestricted:::restricted' (layer 7/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfRoads:::roads' (layer 8/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'sfStreams:::streams' (layer 9/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'states_shapefile:::states' (layer 10/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'tasmania_cities:::tasmania_cities' (layer 11/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'tasmania_roads:::tasmania_roads' (layer 12/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'tasmania_state_boundaries:::tasmania_state_boundaries' (layer 13/14)
14 Nov 13:42:25 INFO [geoserver.global] - Loading feature type
'tasmania_water_bodies:::tasmania_water_bodies' (layer 14/14)
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".

On Nov 13, 2007 6:01 PM, Saul Farber <sjf8@anonymised.com> wrote:
> Jason,
>
> I'd suggest that you try the 1.6.x series of geoserver for it's
> much-improved ArcSDE support.
>
> Here's how to do that:
>
> 1) Download the latest geoserver beta (or nightly build, if you like).
> 2) Deploy it without adding anything ArcSDE related. Check that it's
> working (say, with a shapefile). WFS should be good, and so should WMS.
> 3) Grab this file
> http://lists.refractions.net/m2/org/geotools/gt2-arcsde/2.4-SNAPSHOT/gt2-arcsde-2.4-SNAPSHOT.jar and put it into your geoserver/WEB-INF/lib directory
> 4) Put your two jsde_api91.jar and jsde_jpe91.jar files into the
> geoserver/WEB-INF/lib directory as well.
> 5) Restart the whole she-bang and it should work much better.
>
>
> Good luck!
> --saul
>
>
> On Tue, 2007-11-13 at 17:46 +0100, Jason Pickering wrote:
> > Hi Everyone,
> >
> > I am trying to get a ArcSDE datastore up and running and seem to be
> > running into some problems. I am not sure if it has anything to do
> > with the names of the feature classes, so I thought I would check here
> > first. I am able to create a new feature class in geoserver, and i am
> > able to get to it through a WFS connection but a lot of errors are
> > produced in the log. It does seem to work though. However, I cannot
> > get anything out of the WMS connection through even the most simple of
> > SLDs. I thought it might have to do with the styled layer descriptor,
> > but even the simple "polygon" does not work. The name of the layer is
> > OMS.OMS.WHO_REG, and I thought that the periods might cause a
> > problem.
> >
> > I am using the latest 1.5.4 version with an ArcSDE 9.1 /MS-SQL setup.
> > I am using the 9.1 jars and the 1.5.4 version extension for geoserver.
> >
> > Here is a typical snippet from the log when I make a WMS request to output KML.
> >
> > Thanks for any tips.
> >
> > Best regards,
> > Jason
> >
> >
> >
> > Nov 13, 2007 5:34:00 PM org.vfny.geoserver.servlets.AbstractService doService
> > INFO: Service handled
> > Nov 13, 2007 5:34:20 PM
> > org.vfny.geoserver.wms.requests.GetMapKvpReader
> > parseOptionalParameters
> > INFO: Set KMScore: 50
> > Nov 13, 2007 5:34:20 PM org.vfny.geoserver.servlets.AbstractService doService
> > INFO: handling request:
> > GetMap Request
> > version: 1.1.1
> > output format: application/vnd.google-earth.kmz XML
> > width height: 1024,1024
> > bbox: Env[-50.81813868472601 : 93.77489215952886, -29.96974386011042
> > : 54.43714880180336]
> > layers: WHO:OMS.OMS.WHO_REG
> > styles: OMS.OMS.WHO_REG_style
> > Nov 13, 2007 5:34:29 PM org.geotools.data.arcsde.ArcSDEQuery getQueryColumns
> > INFO: No FID attribute was contained in your query. Appending the
> > discovered one to the list of columns to be fetched.
> > Nov 13, 2007 5:34:29 PM org.geotools.renderer.lite.StreamingRenderer
> > processStylers
> > SEVERE: Wrong number of attributes expected 2 got 3
> > IllegalAttribute: null , but got null
> > at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
> > at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
> > at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
> > at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
> > at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
> > at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
> > at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
> > at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
> > at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
> > at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
> > at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
> > at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
> > at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
> > at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
> > at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
> > at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
> > at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
> > at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
> > at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
> > at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
> > 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:175)
> > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> > 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:263)
> > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
> > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> > at java.lang.Thread.run(Thread.java:619)
> > Nov 13, 2007 5:34:30 PM org.geotools.renderer.lite.StreamingRenderer
> > processStylers
> > SEVERE: Wrong number of attributes expected 2 got 3
> > IllegalAttribute: null , but got null
> > at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
> > at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
> > at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
> > at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
> > at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
> > at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
> > at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
> > at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
> > at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
> > at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
> > at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
> > at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
> > at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
> > at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
> > at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
> > at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
> > at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
> > at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
> > at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
> > at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
> > 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:175)
> > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> > 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:263)
> > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
> > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> > at java.lang.Thread.run(Thread.java:619)
> > Nov 13, 2007 5:34:30 PM org.geotools.renderer.lite.StreamingRenderer
> > processStylers
> > SEVERE: Wrong number of attributes expected 2 got 3
> > IllegalAttribute: null , but got null
> > at org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
> > at org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
> > at org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
> > at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
> > at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1564)
> > at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:715)
> > at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
> > at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:238)
> > at org.vfny.geoserver.wms.responses.map.kml.KMZMapProducer.writeTo(KMZMapProducer.java:164)
> > at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:495)
> > at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:592)
> > at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
> > at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
> > at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
> > at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
> > at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
> > at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
> > at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
> > at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
> > at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
> > 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:175)
> > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> > 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:263)
> > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
> > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems? Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

5

Jason Pickering ha scritto:

Hi Saul,

After some other nasty problems that I worked out with the help of
everyone on the IRC channel, I installed the nightly build, along with
the link below. WMS, WFS and everything are behaving apparently
normally. SDE is not working on this build though. It is not available
when I try and add a new data store.

Any idea what is wrong?

Best regards,
Jason

Here is a snippet from the log..

14 Nov 13:42:24 WARN [org.geotools] - Can't load a service for
category "DataStoreFactorySpi". Cause is "NoClassDefFoundError:
org/geotools/util/logging/Logging".

...

14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
not (...) arcsde.ArcSDERasterFormatFactory".
14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could

Ouch, you have some serious classloading issues there. Ah, I get it,
you're using that GeoServer nightly which is two days old, but
you got a very recent arcsde jar. In these two days we changed
all of the classes in GeoServer to fix a nasty logging redirection
issue and the result is that the classes are binary incompatible
with the ones from 2 days ago.

I'm trying to build geoserver right now but I'm having some issues...
Jason, can you wait until I get a build going?
Cheers
Andrea

6

HI Saul and Andrea,
Thanks for your help. Will do. Let us know when there is a new version.

Best regards,
Jason

On Nov 14, 2007 5:35 PM, Andrea Aime <aaime@anonymised.com> wrote:

Jason Pickering ha scritto:
> Hi Saul,
>
> After some other nasty problems that I worked out with the help of
> everyone on the IRC channel, I installed the nightly build, along with
> the link below. WMS, WFS and everything are behaving apparently
> normally. SDE is not working on this build though. It is not available
> when I try and add a new data store.
>
> Any idea what is wrong?
>
> Best regards,
> Jason
>
> Here is a snippet from the log..
>
>
>
> 14 Nov 13:42:24 WARN [org.geotools] - Can't load a service for
> category "DataStoreFactorySpi". Cause is "NoClassDefFoundError:
> org/geotools/util/logging/Logging".
...

> 14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
> category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
> not (...) arcsde.ArcSDERasterFormatFactory".
> 14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
> category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
> not (...) arcsde.ArcSDERasterFormatFactory".
> 14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
> category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
> not (...) arcsde.ArcSDERasterFormatFactory".
> 14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
> category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
> not (...) arcsde.ArcSDERasterFormatFactory".
> 14 Nov 13:42:26 WARN [org.geotools] - Can't load a service for
> category "GridFormatFactorySpi". Cause is "NoClassDefFoundError: Could
>

Ouch, you have some serious classloading issues there. Ah, I get it,
you're using that GeoServer nightly which is two days old, but
you got a very recent arcsde jar. In these two days we changed
all of the classes in GeoServer to fix a nasty logging redirection
issue and the result is that the classes are binary incompatible
with the ones from 2 days ago.

I'm trying to build geoserver right now but I'm having some issues...
Jason, can you wait until I get a build going?
Cheers
Andrea