Subquery BUG

AlexProtyagov — Mon, 04 Apr 2011 19:51:54 GMT

I am trying to Sync down a feature layer with subquery in WhereClause

ROUTE_ID IN (SELECT ROUTE_ID FROM B)

So, my code just does this in SQL terms:

SELECT * FROM A WHERE ROUTE_ID IN (SELECT ROUTE_ID FROM B);

That gives me InvalidOperationException exception, stack trace is

  Stack Trace:
   at ESRI.ArcGIS.Mobile.MobileServices.FeatureDataReader.InitCursor()
   at ESRI.ArcGIS.Mobile.MobileServices.FeatureDataReader.Reset()
   at ESRI.ArcGIS.Mobile.MobileServices.FeatureDataReader..ctor(FeatureLayer featureLayer, QueryFilter queryFilter, EditState requestedEditState, Boolean lockedRead, String[] columnNames)
   at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.GetFidChecksumDictionary(QueryFilter filter)
   at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.DownloadExtent(BinaryWriter binaryWriter, QueryFilter filter, Boolean markAsCached, FeatureLayerSyncResults results)
   at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.ProcessDecomposedExtents(String whereClause, Boolean markAsCached, FeatureLayerSyncResults results, IList`1 decomposedExtents)
   at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.Download(QueryFilter downloadFilter, FeatureLayerSyncResults results)
   at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.Synchronize()

On ArcGIS server I have verbose log enabled and it does show correct number of return rows:

MobileSync: Get Feature Count for AMS_KY.M_SIGN_INVENTORY [70 features in 1.607800 seconds: rate (43.5 f/s)].

Re: Subquery BUG

AlexProtyagov — Mon, 04 Apr 2011 19:53:34 GMT

I need to mention that I use ArcGIS Mobile 10 (Build 2475).

topic Subquery BUG in ArcGIS for Windows Mobile Questions

Subquery BUG

Re: Subquery BUG