Hi Chris, it may be a bug, either on the esri sde libaries or on the geotools plugin. Note I don't have a way to test against 9.1 though. The error being produced when calling calculateTableStatistics makes me suspect. That method is called when the query counts need to be calculated, and though I'm pretty sure it works for 9.2 and 9.3 under oracle and sql server, I can't tell about 9.1. Can you tell me what database and version are you using with your arcsde and if you have applied any arcsde service pack? also could you try with the 9.1 jars instead of the 9.2 ones?
Cheers, Gabriel Chris Hodgson wrote: > I'm testing this error using a point layer in SDE which I am accessing > in Google Earth using the KML reflector. This is against Geoserver 1.7.x > from SVN, with SDE 9.1 and using the 9.2 DLLs. > > By default the KML reflector uses superoverlay mode (which is what we > want to do) but this seems to fail giving the following stack trace. By > specifying mode=refresh it works fine. Have I done something wrong or is > this possibly a bug? > > 14 Apr 13:37:40 ERROR [org.geotools.arcsde.pool] - Command execution > failed for Session 4 in thread 122 > org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE > LEVEL ERROR OCCURRED.][Extended desc= > ] > at org.geotools.arcsde.pool.Session$2.call(Session.java:205) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) > at java.lang.Thread.run(Thread.java:619) > Caused by: com.esri.sde.sdk.client.SeException: > at com.esri.sde.sdk.client.k.a(Unknown Source) > at com.esri.sde.sdk.client.k.a(Unknown Source) > at com.esri.sde.sdk.client.SeQuery.calculateTableStatistics(Unknown > Source) > at org.geotools.arcsde.data.ArcSDEQuery$2.execute(ArcSDEQuery.java:583) > at org.geotools.arcsde.data.ArcSDEQuery$2.execute(ArcSDEQuery.java:567) > at org.geotools.arcsde.pool.Session$2.call(Session.java:202) > ... 5 more > > Also here are the networkLinks I'm using in my KML to access this layer > (not functional outside of my machine but useful for demonstrating my > parameters): > > <NetworkLink> > <name>KML Reflector in (default) superoverlay mode</name> > <Link> > > <href>http://localhost:8000/geoserver/wms/kml?layers=topp:WHSE_WATER_MANAGEMENT.SSL_SNOW_PILLOW_LOCATION_SVW</href> > > > <viewRefreshMode>onStop</viewRefreshMode> > <viewRefreshTime>0.5</viewRefreshTime> > </Link> > <LatLonBox> > <north>90</north><south>-90</south> > <east>180</east><west>-180</west> > </LatLonBox> > </NetworkLink> > <NetworkLink> > <name>KML Reflector in refresh mode</name> > <Link> > > <href>http://localhost:8000/geoserver/wms/kml?layers=topp:WHSE_WATER_MANAGEMENT.SSL_SNOW_PILLOW_LOCATION_SVW&mode=refresh</href> > > > <viewRefreshMode>onStop</viewRefreshMode> > <viewRefreshTime>0.5</viewRefreshTime> > </Link> > <LatLonBox> > <north>90</north><south>-90</south> > <east>180</east><west>-180</west> > </LatLonBox> > </NetworkLink> > > > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > High Quality Requirements in a Collaborative Environment. > Download a free trial of Rational Requirements Composer Now! > http://p.sf.net/sfu/www-ibm-com > _______________________________________________ > Geoserver-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-devel -- Gabriel Roldan OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
