topic Re: Update error code 1000 - "statement conflicted with the reference constraint..." in ArcGIS Survey123 Questions

Update error code 1000 - "statement conflicted with the reference constraint..."

BrentKinal1 — Thu, 28 Jun 2018 21:32:10 GMT

Any thoughts on what is causing this error?

Re: Update error code 1000 - "statement conflicted with the reference constraint..."

JamesTedrick — Thu, 28 Jun 2018 21:39:45 GMT

Hi Brent,

It appears that something might be at issue with the parentglobalid being submitted. Is the parentglobalid this in the form itself (or not in the form but present as it's required for a repeat)? Are you the DBA for this database (it does not look like a hosted service)?

Re: Update error code 1000 - "statement conflicted with the reference constraint..."

BrentKinal1 — Thu, 28 Jun 2018 22:02:33 GMT

Hi James, Thanks for you quick reply, The parentglobalid is required for a repeat. The database is a agol hosted service. I am just not sure where to look to find the issue.

Re: Update error code 1000 - "statement conflicted with the reference constraint..."

JamesTedrick — Thu, 28 Jun 2018 22:04:48 GMT

By required, are you meaning that parentglobalid occurs in the XLSForm? If so, it sounds like the format being submitted might be incorrect. Can you provide an example of the data being submitted?