I have converted the sample 'STATES' shapefile into a feature class of an
ArcSDE database. When I go to preview the layer in GeoServer, it returns a
error saying "824927 [btpool0-4] ERROR org.geotools.rendering - Wrong number
of attributes expected 3 got 4"
- Tyler
Here is the request that causes the error:
http://gisdev:8080/geoserver/wms?bbox=-130,24,-66,50&styles=population&Format=image/png&request=GetMap&layers=mtri:SDE_GEOSERVER.DBO.STATES&width=550&height=250&srs=EPSG:4326
Here is my current configuration...
GeoServer 1.5.x (from nightly build geoserver-1.5.x-073007-bin.zip)
ArcSDE 9.2 plugin (gt2-arcsde.jar built by Saul on 7/3/2007)
Here is the SDE table definition:
sdetable -o describe -t states -i 5190 -s sql1 -D sde_geoserver
ArcSDE 9.2 for SQL Server Build 1137 Mon Mar 5 15:52:01 2007
Attribute Administration Utility
-----------------------------------------------------
Table states:
Column name Attribute type Null? Length,DPs RowID
Column?
-------------------------------------------------------------------------------
OBJECTID SE_INT32 NOT NULL 10 SDE Set
STATE_NAME SE_NSTRING NULL 25
STATE_FIPS SE_NSTRING NULL 2
SUB_REGION SE_NSTRING NULL 7
STATE_ABBR SE_NSTRING NULL 2
LAND_KM SE_FLOAT64 NULL 27,9
WATER_KM SE_FLOAT64 NULL 27,9
PERSONS SE_FLOAT64 NULL 27,9
FAMILIES SE_FLOAT64 NULL 27,9
HOUSHOLD SE_FLOAT64 NULL 27,9
MALE SE_FLOAT64 NULL 27,9
FEMALE SE_FLOAT64 NULL 27,9
WORKERS SE_FLOAT64 NULL 27,9
DRVALONE SE_FLOAT64 NULL 27,9
CARPOOL SE_FLOAT64 NULL 27,9
PUBTRANS SE_FLOAT64 NULL 27,9
EMPLOYED SE_FLOAT64 NULL 27,9
UNEMPLOY SE_FLOAT64 NULL 27,9
SERVICE SE_FLOAT64 NULL 27,9
MANUAL SE_FLOAT64 NULL 27,9
P_MALE SE_FLOAT64 NULL 27,9
P_FEMALE SE_FLOAT64 NULL 27,9
SAMP_POP SE_FLOAT64 NULL 27,9
Shape SE_SHAPE NULL 0
GeoServer log
INFO | jvm 1 | 2007/07/31 09:33:46 | 824896 [btpool0-4] INFO
org.vfny.geoserver.servlets - handling request:
INFO | jvm 1 | 2007/07/31 09:33:46 | GetMap Request
INFO | jvm 1 | 2007/07/31 09:33:46 | version: 1.1.1
INFO | jvm 1 | 2007/07/31 09:33:46 | output format: image/png
INFO | jvm 1 | 2007/07/31 09:33:46 | width height: 250,550
INFO | jvm 1 | 2007/07/31 09:33:46 | bbox: Env[-130.0 : -66.0, 24.0 :
50.0]
INFO | jvm 1 | 2007/07/31 09:33:46 | layers:
mtri:SDE_GEOSERVER.DBO.STATES
INFO | jvm 1 | 2007/07/31 09:33:46 | styles: population
INFO | jvm 1 | 2007/07/31 09:33:46 | 824896 [btpool0-4] INFO
org.geotools.arcsde.data - No FID attribute was contained in your query.
Appending the discovered one to the list of columns to be fetched.
INFO | jvm 1 | 2007/07/31 09:33:46 | 824927 [btpool0-4] ERROR
org.geotools.rendering - Wrong number of attributes expected 3 got 4
INFO | jvm 1 | 2007/07/31 09:33:46 | IllegalAttribute: null , but got
null
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.feature.DefaultFeatureType.create(DefaultFeatureType.java:171)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:144)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:141)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1560)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:711)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:433)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:240)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:368)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:516)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.Server.handle(Server.java:269)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:687)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:492)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
INFO | jvm 1 | 2007/07/31 09:33:46 | 824927 [btpool0-4] ERROR
org.geotools.rendering - Wrong number of attributes expected 3 got 4
INFO | jvm 1 | 2007/07/31 09:33:46 | IllegalAttribute: null , but got
null
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.feature.DefaultFeature.setAttributes(DefaultFeature.java:263)
INFO | jvm 1 | 2007/07/31 09:33:46 | at
org.geotools.feature.DefaultFeature.<init>(DefaultFeature.java:97)
...
--
View this message in context: http://www.nabble.com/geotools-error-when-requesting-an-ArcSDE-layer-tf4193083.html#a11924376
Sent from the GeoServer - Dev mailing list archive at Nabble.com.