Problem QueryRelatedAsync -> Exception

MarkoKangas

Hi,

I have two tables both are ObjecClass (no geometry).

• TableA
  • OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
  • GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , editable: false , nullable: false , length: 38 )
  • CHANGER( type: esriFieldTypeString , alias: CHANGER, editable: true , nullable: false , length: 20 )
  • CHANGEDATE ( type: esriFieldTypeDate , alias: CHANGEDATE , editable: true , nullable: false , length: 36 )
  • CREATOR ( type: esriFieldTypeString , alias: CREATOR , editable: true , nullable: false , length: 20 )
  • CREATED ( type: esriFieldTypeDate , alias: CREATED , editable: true , nullable: false , length: 36 )
• TableB
  • OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
  • AREANUMBER( type: esriFieldTypeInteger , alias: AREANUMBER, editable: true , nullable: false )
  • ARCHIVE ( type: esriFieldTypeInteger , alias: ARCHIVE, editable: true , nullable: false )
  • GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , editable: false , nullable: false , length: 38 )
  • TABLEA_GLOBALID ( type: esriFieldTypeGUID , alias: MKI_GLOBALID , editable: true , nullable: true , length: 38 )
  • CHANGER( type: esriFieldTypeString , alias: CHANGER, editable: true , nullable: false , length: 20 )
  • CHANGEDATE ( type: esriFieldTypeDate , alias: CHANGEDATE , editable: true , nullable: false , length: 36 )
  • CREATOR ( type: esriFieldTypeString , alias: CREATOR , editable: true , nullable: false , length: 20 )
  • CREATED ( type: esriFieldTypeDate , alias: CREATED , editable: true , nullable: false , length: 36 )

- TableA has relationship to TableB 1..n (BelongsTo (13) -- Related To: TableB (16))

If I try after opening and querying TableA to (ServiceFeatureTabke) QueryRelated from TableB I Get exception ({"Specified argument
was out of the range of valid values.Parameter name: length"} ) :

*    at Esri.ArcGISRuntime.Data.FieldInfo..ctor(String name, String alias, FieldType type, Nullable`1 length, Boolean editable, Boolean nullable, Domain domain)

   at Esri.ArcGISRuntime.Tasks.Query.RelationshipResult.GetFieldsFromJsonDictionary(JsonDictionary jsonDictionary)

   at Esri.ArcGISRuntime.Tasks.Query.RelationshipResult.FromJsonDictionary(JsonDictionary jsonDictionary, String tableName)

   at Esri.ArcGISRuntime.Tasks.Query.QueryTask.<ExecuteRelationshipQueryInternal>d__2c.MoveNext()

I have tried change  Thread currentculture to en-US no effect. Using 10.2.4 SDK.

Any clue ? workaround?

GregDeStigter

This looks like an issue we've seen with GUID fields in related tables that is slated to be fixed in the next version. I'm curious, if you perform your query using a QueryTask and filter out the 'TABLEA_GLOBALID' field if it will return successfully.  Please try the following type of query with your data:

var relParam = new RelationshipParameters(new long[] { 1L }, 0L);

relParam.OutFields = new OutFields(new string[] { "AREANUMBER", "ARCHIVE", "GLOBALID" });

var queryTask = new QueryTask(new Uri(FeatureServiceUrl));

var result = await queryTask.ExecuteRelationshipQueryAsync(relParam);

-Greg