I’m trying to catalog an arcsdeLayer but the openlayer preview fails and the geoserver log shows a com.esri.sde.sdk.client.SeException (below the full exception trace).
The same geoserver is able to show other arcsde layers and is fully configurated for ArcSDE datastores.
GeoServer 2.3.3, with Jpe, Jsde 9.3
ArcSDE 9.3
It seems that Geotools fails in those lines of code, but I wonder why…
// To prevent errors in ArcSDE, we first trim the user's Filter
// geometry to the extents of our layer.
GeometryBuilder gb = GeometryBuilder.builderFor(Polygon.class);
SeExtent seExtent = this.sdeLayer.getExtent();
SeShape extent = new SeShape(this.sdeLayer.getCoordRef());
extent.generateRectangle(seExtent);
Caused by: java.lang.RuntimeException: com.esri.sde.sdk.client.SeException:
at org.geotools.arcsde.filter.GeometryEncoderSDE.addSpatialFilter(GeometryEncoderSDE.java:291)
at org.geotools.arcsde.filter.GeometryEncoderSDE.visit(GeometryEncoderSDE.java:298)
at org.geotools.renderer.lite.FastBBOX.accept(FastBBOX.java:127)
at org.geotools.arcsde.filter.GeometryEncoderSDE.encode(GeometryEncoderSDE.java:155)
at org.geotools.arcsde.data.ArcSDEQuery$FilterSet.getSpatialFilters(ArcSDEQuery.java:1127)
at org.geotools.arcsde.data.ArcSDEQuery.createSeQueryForFetch(ArcSDEQuery.java:386)
at org.geotools.arcsde.data.ArcSDEQuery.getSeQuery(ArcSDEQuery.java:348)
at org.geotools.arcsde.data.ArcSDEQuery.execute(ArcSDEQuery.java:797)
at org.geotools.arcsde.data.ArcSDEAttributeReader.<init>(ArcSDEAttributeReader.java:140)
at org.geotools.arcsde.data.ArcSDEDataStore.getFeatureReader(ArcSDEDataStore.java:380)
at org.geotools.arcsde.data.ArcSDEDataStore.getFeatureReader(ArcSDEDataStore.java:323)
at org.geotools.arcsde.data.ArcSdeFeatureSource.getfeatureReader(ArcSdeFeatureSource.java:342)
at org.geotools.arcsde.data.ArcSdeFeatureCollection.reader(ArcSdeFeatureCollection.java:117)
at org.geotools.arcsde.data.ArcSdeFeatureCollection.openIterator(ArcSdeFeatureCollection.java:131)
at org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:199)
at org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:188)
at org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:79)
at org.geotools.data.crs.ForceCoordinateSystemFeatureResults.openIterator(ForceCoordinateSystemFeatureResults.java:95)
at org.geotools.feature.collection.AbstractFeatureCollection.features(AbstractFeatureCollection.java:69)
at org.geotools.feature.collection.AbstractFeatureCollection.features(AbstractFeatureCollection.java:53)
at org.geotools.renderer.lite.StreamingRenderer.drawPlain(StreamingRenderer.java:2475)
at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:2045)
at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:829)
at org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:491)
… 104 more
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeShape.f(Unknown Source)
at com.esri.sde.sdk.client.SeShape.generateRectangle(Unknown Source)
at org.geotools.arcsde.filter.GeometryEncoderSDE.addSpatialFilter(GeometryEncoderSDE.java:260)
… 127 more
what if geoserver is right and there is an error in the SDE.layers table,
which provides the connection to the S and F tables of this layer and
contains also the minx, miny, maxx and maxy?
That your other layers work seems to indicate that there is something
particular with this layer.
Cheers
Christian
-----
____________________________
Dr Christian Maul
Project Manager
Information Services Branch
Department Environment and Primary Industries
Level13, Marland House, 570 Bourke Street
Melbourne 3000
what if geoserver is right and there is an error in the SDE.layers table,
which provides the connection to the S and F tables of this layer and
contains also the minx, miny, maxx and maxy?
That your other layers work seems to indicate that there is something
particular with this layer.
Cheers
Christian
Dr Christian Maul
Project Manager
Information Services Branch
Department Environment and Primary Industries
Level13, Marland House, 570 Bourke Street
Melbourne 3000
No unfortunately not, all values in the F-Table are within the bounding box
and that you are using one grid for all levels, that looks all unsuspicious
to me.
-----
____________________________
Dr Christian Maul
Project Manager
Information Services Branch
Department Environment and Primary Industries
Level13, Marland House, 570 Bourke Street
Melbourne 3000
eventually we solved this problem on the ArcSDE side, with a de-registration and a new registration of the oracle table on the sde catalog with different srs and extent values.
No unfortunately not, all values in the F-Table are within the bounding box
and that you are using one grid for all levels, that looks all unsuspicious
to me.
Dr Christian Maul
Project Manager
Information Services Branch
Department Environment and Primary Industries
Level13, Marland House, 570 Bourke Street
Melbourne 3000