I'm experiencing issues where ESRI.ArcGIS.Geodatabase.IFeatureClass.Search with a spatial filter hangs indefinitely. I've let this run for well over a 24 hour period and the call never returns. Even more perplexing is that the call typically returns in under a second but on some calls it ends up hanging forever. There is no CPU, RAM, or Disk activity on the ArcMap client and no activity in the database. The last call to the database appears to be the query that the FeatureClass.Search would have generated and returned successfully. Arcmap must be exited by killing the ArcMap.exe process via the task manager. I've been able to reproduce this against multiple client machines and multiple copies of the SDE data. We are running 9.3.1 Sp1 of ArcMap and SDE. I've reproduced this with both direct connect and sde connect.
... View more