topic Re: Problem QueryRelatedAsync -> Exception in .NET Maps SDK Questions

Problem QueryRelatedAsync -> Exception

MarkoKangas — Mon, 13 Oct 2014 11:49:34 GMT

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.\r\nParameter 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?

Re: Problem QueryRelatedAsync -> Exception

JenniferNery — Mon, 13 Oct 2014 21:18:38 GMT

Are you working with ServiceFeatureTable? Would it be possible for you to share also the JSON response from the QueryRelatedAsync call? I believe this exception has something to do with parsing the Fields in the JSON and would happen only if Fields with type esriFieldTypeString is missing length property.

Thanks.

Jennifer

Re: Problem QueryRelatedAsync -> Exception

PreetiMaske — Mon, 13 Oct 2014 21:48:30 GMT

Hi,

I am unable to repro the problem you are seeing with Querying related rows between two tables. Would it be possible for you to share your data ?

Re: Problem QueryRelatedAsync -> Exception

MarkoKangas — Tue, 14 Oct 2014 05:29:26 GMT

Its working directly from Esri ArcGIS server service query site (Fiddler -> RAW)

If problem isn't those fields. I added all TableB fields to repro. Problem is related those added fields -> (AREANUMBER, ARCHIVE, GLOBALID, TABLEA_GLOBALID).

Here is JSON response (added all fields):

{

"fields": [

{

"name": "OBJECTID",

"alias": "OBJECTID",

"type": "esriFieldTypeOID"

{

"name": "AREANUMBER",

"alias": "AREANUMBER",

"type": "esriFieldTypeInteger"

{

"name": "ARCHIVE",

"alias": "ARCHIVE",

"type": "esriFieldTypeInteger"

{

"name": "GLOBALID",

"alias": "GLOBALID",

"type": "esriFieldTypeGlobalID",

"length": 38

{

"name": "TABLEA_GLOBALID",

"alias": "TABLEA_GLOBALID",

"type": "esriFieldTypeGUID",

"length": 38

{

"name": "CREATOR",

"alias": "Creator",

"type": "esriFieldTypeString",

"length": 20

{

"name": "CREATED",

"alias": "Created",

"type": "esriFieldTypeDate",

"length": 36

{

"name": "CHANGER",

"alias": "Changer",

"type": "esriFieldTypeString",

"length": 20

{

"name": "CHANGEDATE",

"alias": "Changedate",

"type": "esriFieldTypeDate",

"length": 36

}

"relatedRecordGroups": [

{

"objectId": 2262,

"relatedRecords": [

{

"attributes": {

"OBJECTID": 2999,

"AREANUMBER": 1,

"ARCHIVE": 0,

"GLOBALID": "{9830E5CE-3D79-4606-9B50-4912E3072EF2}",

"TABLEA_GLOBALID": "{EFCE8592-7D91-4DD4-93D8-8CEDCE661427}",

"CREATOR": "UnitTest",

"CREATED": 1412695974000,

"CHANGER": "UnitTest",

"CHANGEDATE": 1412695974000

}

{

"attributes": {

"OBJECTID": 3000,

"AREANUMBER": 2,

"ARCHIVE": 0,

"GLOBALID": "{17C7D5EE-09BD-4F3D-AE08-51C47E1C885E}",

"TABLEA_GLOBALID": "{EFCE8592-7D91-4DD4-93D8-8CEDCE661427}",

"CREATOR": "UnitTest",

"CREATED": 1412695974000,

"CHANGER": "UnitTest",

"CHANGEDATE": 1412695974000

}

]

}

]

}

Re: Problem QueryRelatedAsync -> Exception

GregDeStigter — Tue, 14 Oct 2014 17:13:06 GMT

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

Re: Problem QueryRelatedAsync -> Exception

MarkoKangas — Wed, 15 Oct 2014 11:32:20 GMT

Tried and that works so problem is those esriFieldTypeGUID fields.

Need to make workaround and wait bug fix...

Thanks Greg