topic Re: Related records error when submitting in ArcGIS Collector Questions

Related records error when submitting

MarkYerington — Thu, 07 Mar 2019 20:46:14 GMT

I get the attached error when trying to submit a related record with the new collector for arcgis. This works fine in the classic collector. The relationship is not built on a guid.

Re: Related records error when submitting

GeoJosh — Thu, 07 Mar 2019 21:43:12 GMT

Hey Mark,

Can you give me a little more information about the relationship class? What types of fields (e.g. ObjectID, Long, Short, etc.) specifically is the relationship class built on?

-Josh

Re: Related records error when submitting

MarkYerington — Fri, 08 Mar 2019 12:33:23 GMT

The relationship class key field is the ObjectID, there are some number domains with text description, otherwise pretty normal.

Mark Yerington │GIS Manager│ GISP

Muscatine Area Geographic Information Consortium

c/o Muscatine Power & Water | 3205 Cedar Street | Muscatine, IA 52761

Office: 563.262.3316│Cell: 563.260.4525 Email: myerington@mpw.org│Web: magic-gis.com<https://magic-gis.com/>

Re: Related records error when submitting

GeoJosh — Fri, 08 Mar 2019 14:08:02 GMT

Mark,

Is the foreign key an editable field? If so, this is a known issue and a defect has been written for it. If you manually remove the contents of that field and repopulate it with the same information, the related record should submit successfully.

BUG-000119842: Submitting related records fails with the error message, "The data type are incompatible" in Collector for ArcGIS (iOS) if the relationship is between the feature class ObjectID and an editable field in the related table.

-Josh

Re: Related records error when submitting

MarkYerington — Fri, 08 Mar 2019 14:15:28 GMT

Ok thanks for the bug report. So I tried to make this not editable, but that doesn't seem to clear up the issue. Guess I will just wait until it is fixed.

Re: Related records error when submitting

GeoJosh — Fri, 08 Mar 2019 14:20:57 GMT

Mark,

Did you rebuild the relationship class after you made that field uneditable? I'm not sure if this will solve the issue, but it's just a thought.

-Josh

Re: Related records error when submitting

MarkYerington — Fri, 08 Mar 2019 15:20:48 GMT

This is our production database so if I need to do that it will have to happen after hours. I was thinking you were talking about editable in the web map popup. That is a pretty invasive workaround, I think this should be a software change not a complete database modification.

Mark Yerington │GIS Manager│ GISP

Muscatine Area Geographic Information Consortium

c/o Muscatine Power & Water | 3205 Cedar Street | Muscatine, IA 52761

Office: 563.262.3316│Cell: 563.260.4525 Email: myerington@mpw.org│Web: magic-gis.com<https://magic-gis.com/>

Re: Related records error when submitting

JohanLagerkvist — Mon, 03 Jun 2019 10:11:26 GMT

I get the same error - any thoughts on when this issue may be fixed?

//Johan

GIS-developer

Municipality of Karlstad

Sweden

Re: Related records error when submitting

MaudeSundborg — Wed, 30 Oct 2019 17:56:01 GMT

When will this bug be fixed? Manually entering the foreign key will certainly leed to errors... This is stopping us from using Collector for assets assessment directly on the field.

Is this bug occuring even if using a GlobalID field/foreign key?

Re: Related records error when submitting

JohanLagerkvist — Thu, 31 Oct 2019 08:29:20 GMT

This is not occuring when using GlobalID.

Since I didn't want to wait for an eventual future bug-fix I have gone through all our collector-solutions and made them based on GlobalID instead of ObjectID (stopped arcgis services, added GlobalID's on every feature dataset, rebuild the relationship-class and where we had existing related records based on objectID populated the new "REL_GLOBALID" with some nice logic in FME).

Yes this took som time and struggle and yes we obviuosly had som downtime for our users since I had to stop active ArcGIS services in order to free up the database from locks. But now we finally are over and uses the new collector.

//Johan