Error:Unsupported relationship type esriFieldTypeGlobalID in key field GlobalID for table GlobalID

[SueBoelk2]

First, I appreciate the help extended here, as I ask alot of questions.

Trying to publish this survey brings up error after error.

One error is fixed and another crops up.

The survey was created on Survey123 Connect and we do have an Enterprise db to which we publish.

Enclosed find the latest:

Thanks so much to you all.

[CodyPatterson]

Hey @SueBoelk2 

Since it was created in Connect, would this here work?

https://community.esri.com/t5/arcgis-survey123-questions/submission-url-not-compatible-with-s123/td-...

I'm also seeing you may need to add a field called parentglobalid string 255 in the table as well:

https://community.esri.com/t5/arcgis-survey123-questions/unsupported-relationship-type-when-publishi...

Cody

[SueBoelk2]

Thank you Cody. I have our Software Admin helping me and will ask him.

[SueBoelk2]

Hi Cody-

In answer to your suggestions, we did try to publish under feature service but we were still getting publishing errors as referenced above.

Also our ParentGlobalID was String and it wasn't working so we changed it to GUID as suggested by another fix.

Thank you. 

[CodyPatterson]

Hey @SueBoelk2 

Did the change over to GUID end up fixing it? I think you're referencing this here maybe?

https://community.esri.com/t5/arcgis-survey123-questions/issue-with-globalid-field-generated-in-surv...

Cody

[SueBoelk2]

No, it didn't 😞

[DougBrowning]

These names will not work as table name SDE.Samples_of_Milk  The name in the begin repeat line as to match the table name in the service.

For the globalid issue I suggest to make a copy of the form and publish it as its own new form with no submission url.  Look at the schema it builds and match that exactly in your other service.

[SueBoelk2]

Thank you Doug. Will pass this along to my co-workers and try to get this going.

We appreciate our help!