Failed to process the given spatial condition
|
|
simon hope
|
Hello,
I've come across an issue which i think i may have come across before [1]. I am using the ArcSDE provider: <FeatureProvider> <Name>OSGeo.ArcSDE.3.2</Name> <DisplayName>OSGeo FDO Provider for ArcSDE</DisplayName> <Description>Read/write access to an ESRI ArcSDE-based data store, using Oracle and SQL Server.</Description> <IsManaged>False</IsManaged> <Version>3.2.1.0</Version> <FeatureDataObjectsVersion>3.2.1.0</FeatureDataObjectsVersion> <LibraryPath>ArcSDEProvider.dll</LibraryPath> </FeatureProvider> I am setting a spatial filter on the select query then attempting to set a feature reader by executing the query: OSGeo.FDO.Commands.Feature.IFeatureReader featReader = qrySelect.Execute(); At which point i get an exception: 'Failed to process the given spatial condition'. Has anybody successfully managed to create a spatial filter using the ArcSDE 9.2 v3.2 provider? Cheers Simon [1].http://www.nabble.com/Failed-to-process-the-given-spatial-condition-to13205208s16610.html#a13223966 |
||||||||||||||||
Dan Stoica
|
Hi,
This is the default error message when ArcSDE returns an error in spatial condition cases. I'm surprised there is no native error message. Can you debug and see exactly where it fails? What is in the spatial filter? Dan. -----Original Message----- From: [hidden email] [mailto:[hidden email]] On Behalf Of simon hope Sent: Sunday, December 09, 2007 3:20 PM To: [hidden email] Subject: [fdo-users] Failed to process the given spatial condition Hello, I've come across an issue which i think i may have come across before [1]. I am using the ArcSDE provider: <FeatureProvider> <Name>OSGeo.ArcSDE.3.2</Name> <DisplayName>OSGeo FDO Provider for ArcSDE</DisplayName> <Description>Read/write access to an ESRI ArcSDE-based data store, using Oracle and SQL Server.</Description> <IsManaged>False</IsManaged> <Version>3.2.1.0</Version> <FeatureDataObjectsVersion>3.2.1.0</FeatureDataObjectsVersion> <LibraryPath>ArcSDEProvider.dll</LibraryPath> </FeatureProvider> I am setting a spatial filter on the select query then attempting to set a feature reader by executing the query: OSGeo.FDO.Commands.Feature.IFeatureReader featReader = qrySelect.Execute(); At which point i get an exception: 'Failed to process the given spatial condition'. Has anybody successfully managed to create a spatial filter using the ArcSDE 9.2 v3.2 provider? Cheers Simon [1].http://www.nabble.com/Failed-to-process-the-given-spatial-condition-to13205208s16610.html#a13223966 -- View this message in context: http://www.nabble.com/Failed-to-process-the-given-spatial-condition-tp14242828s18162p14242828.html Sent from the fdo-users mailing list archive at Nabble.com. _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||||
|
simon hope
|
Dan,
The InnerException is: {"Operation Failed (-1)"} "Can you debug and see exactly where it fails?" I'm using the .Net API and it fails when trying to call Execute() on OSGeo.FDO.Commands.Feature.ISelectImp "What is in the spatial filter" qryPropName = new OSGeo.FDO.Expression.Identifier("Shape"); poly = (OSGeo.FDO.Geometry.IPolygon)geomFactory.CreateGeometry("POLYGON((176954.045 5914119.79, 1769564.823 5914473.302, 1770089.64 5914474.08, 1770091.198 5914117.454, 176954.045 5914119.79))"); geom = geomFactory.CreateGeometry(poly); byteArray = geomFactory.GetFgf(geom); OSGeo.FDO.Expression.GeometryValue qryGeomVal = new OSGeo.FDO.Expression.GeometryValue(byteArray); OSGeo.FDO.Filter.Filter fltr; fltr = new OSGeo.FDO.Filter.SpatialCondition(qryPropName, OSGeo.FDO.Filter.SpatialOperations.SpatialOperations_Intersects, qryGeomVal); qrySelect.SetFilter(fltr.ToString()); Cheers Simon
|
||||
|
Dan Stoica
|
Any luck with this?
Unfortunately ESRI's error code = -1 is generic and I cannot tell what's happening. Dan. -----Original Message----- From: [hidden email] [mailto:[hidden email]] On Behalf Of simon hope Sent: Monday, December 10, 2007 3:07 PM To: [hidden email] Subject: RE: [fdo-users] Failed to process the given spatial condition Dan, The InnerException is: {"Operation Failed (-1)"} "Can you debug and see exactly where it fails?" I'm using the .Net API and it fails when trying to call Execute() on OSGeo.FDO.Commands.Feature.ISelectImp "What is in the spatial filter" qryPropName = new OSGeo.FDO.Expression.Identifier("Shape"); poly = (OSGeo.FDO.Geometry.IPolygon)geomFactory.CreateGeometry("POLYGON((176954.045 5914119.79, 1769564.823 5914473.302, 1770089.64 5914474.08, 1770091.198 5914117.454, 176954.045 5914119.79))"); geom = geomFactory.CreateGeometry(poly); byteArray = geomFactory.GetFgf(geom); OSGeo.FDO.Expression.GeometryValue qryGeomVal = new OSGeo.FDO.Expression.GeometryValue(byteArray); OSGeo.FDO.Filter.Filter fltr; fltr = new OSGeo.FDO.Filter.SpatialCondition(qryPropName, OSGeo.FDO.Filter.SpatialOperations.SpatialOperations_Intersects, qryGeomVal); qrySelect.SetFilter(fltr.ToString()); Cheers Simon Dan Stoica wrote: > > Hi, > > This is the default error message when ArcSDE returns an error in spatial > condition cases. I'm surprised there is no native error message. > > Can you debug and see exactly where it fails? What is in the spatial > filter? > > Dan. > > > -----Original Message----- > From: [hidden email] > [mailto:[hidden email]] On Behalf Of simon hope > Sent: Sunday, December 09, 2007 3:20 PM > To: [hidden email] > Subject: [fdo-users] Failed to process the given spatial condition > > > Hello, > > I've come across an issue which i think i may have come across before [1]. > I > am using the ArcSDE provider: > > <FeatureProvider> > <Name>OSGeo.ArcSDE.3.2</Name> > <DisplayName>OSGeo FDO Provider for ArcSDE</DisplayName> > <Description>Read/write access to an ESRI ArcSDE-based data store, > using > Oracle and SQL Server.</Description> > <IsManaged>False</IsManaged> > <Version>3.2.1.0</Version> > <FeatureDataObjectsVersion>3.2.1.0</FeatureDataObjectsVersion> > <LibraryPath>ArcSDEProvider.dll</LibraryPath> > </FeatureProvider> > > I am setting a spatial filter on the select query then attempting to set a > feature reader by executing the query: > > OSGeo.FDO.Commands.Feature.IFeatureReader featReader = > qrySelect.Execute(); > > At which point i get an exception: 'Failed to process the given spatial > condition'. Has anybody successfully managed to create a spatial filter > using the ArcSDE 9.2 v3.2 provider? > > Cheers > > Simon > > > [1].http://www.nabble.com/Failed-to-process-the-given-spatial-condition-to13205208s16610.html#a13223966 > -- > View this message in context: > http://www.nabble.com/Failed-to-process-the-given-spatial-condition-tp14242828s18162p14242828.html > Sent from the fdo-users mailing list archive at Nabble.com. > > _______________________________________________ > fdo-users mailing list > [hidden email] > http://lists.osgeo.org/mailman/listinfo/fdo-users > _______________________________________________ > fdo-users mailing list > [hidden email] > http://lists.osgeo.org/mailman/listinfo/fdo-users > > -- View this message in context: http://www.nabble.com/Failed-to-process-the-given-spatial-condition-tp14242828s18162p14260539.html Sent from the fdo-users mailing list archive at Nabble.com. _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||||
|
simon hope
|
Dan,
I have tested the spatial filter using both the SHP and OGR providers and it works just fine so I'm pretty sure that its not that. When I saw this issue occuring via the MapGuide API a month or so ago I was also testing against SDE 9.2 - a friend was executing similar spatial filters without issue against SDE 9.1 so I have assumed that the problem is with the SDE 9.2 provider. I'm fairly comfortable with developing using the .Net binaries but haven't set up my environment to use or debug the C++ source so I've not managed to get to the root of the issue - would it help if I was buidling the release and debug binaries from source? i.e. to allow me to debug out to the C++? Cheers Simon
|
||||||||||||||||
Crispin_at_1Spatial
|
All,
Did you ever successfully apply a spatial filter to 9.2? We are seeing a situation with 3.3.2 using the SDE 9.2 connections against a 9.2 (SP0!) is ignoring the spatial filter and running a complete tablescan on the database server! I would like to know if this is a SDE 9.2 issue or a problem with this version of the ArcSDE server. If I did a build of the provider any suggestions as to where I could log the actual query being sent to ArcSDE? Crispin
|
||||||||||||||||
| Free Embeddable Forum Powered by Nabble | Help |
