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.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>
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.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
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
--
Gabriel Roldan
OpenGeo - http://opengeo.org
Expert service straight from the developers.