Re: [Geoserver-users] Problem with ArcSDE datastore
Hi, 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. Thank's for your help. Gianni. On Fri, Feb 28, 2014 at 5:47 AM, cmaul christian.m...@depi.vic.gov.auwrote: 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 PO Box 500, East Melbourne Vic 3002 Telephone:+61-3-8636 2325 Telefax: +61-3-8636 2813 -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-ArcSDE-datastore-tp5104671p5106519.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Problem with ArcSDE datastore
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 PO Box 500, East Melbourne Vic 3002 Telephone:+61-3-8636 2325 Telefax: +61-3-8636 2813 -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-ArcSDE-datastore-tp5104671p5106519.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Problem with ArcSDE datastore
Thank you Christian, actually with ArcGIS Desktop I can visualize those layers, I think that the problem must be elsewhere. Here http://coreweb1.coremed.it/download/sde.zip you can find the sdellayers row and an extract of the S and F tables. Do you see anything wrong? On Fri, Feb 21, 2014 at 12:12 AM, cmaul christian.m...@depi.vic.gov.auwrote: Any idea? Yes Gianni, 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 PO Box 500, East Melbourne Vic 3002 Telephone:+61-3-8636 2325 Telefax: +61-3-8636 2813 -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-ArcSDE-datastore-tp5104671p5104999.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Problem with ArcSDE datastore
Any idea? Yes Gianni, 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 PO Box 500, East Melbourne Vic 3002 Telephone:+61-3-8636 2325 Telefax: +61-3-8636 2813 -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-ArcSDE-datastore-tp5104671p5104999.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Problem with ArcSDE datastore
Hi, 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.lt;initgt;(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 Any idea? -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users