[fdo-users] Failed to process the given spatial condition

[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



simon hope wrote:
> 
> 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
> 
> 
> Dan Stoica wrote:
>> 
>> Any luck with this?
>> 
>> Unfortunately ESRI's error code = -1 is generic and I cannot tell what's
>> happening.
>> 
>> Dan.
>> 
>> -----Original Message-----
>> From: fdo-users-bounces at lists.osgeo.org
>> [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of simon hope
>> Sent: Monday, December 10, 2007 3:07 PM
>> To: fdo-users at lists.osgeo.org
>> 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: fdo-users-bounces at lists.osgeo.org
>>> [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of simon hope
>>> Sent: Sunday, December 09, 2007 3:20 PM
>>> To: fdo-users at lists.osgeo.org
>>> 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
>>> fdo-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>> _______________________________________________
>>> fdo-users mailing list
>>> fdo-users at lists.osgeo.org
>>> 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
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>> 
>> 
> 
> 

-- 
View this message in context: http://n2.nabble.com/Failed-to-process-the-given-spatial-condition-tp2049162p2474198.html
Sent from the FDO Users mailing list archive at Nabble.com.