Parent layer ID publish error

Question

Hello, hoping someone could help me out because I am beyond stuck!

I've created a gdb in ArcGIS Pro with GlobalID > guid relationships and published to AGOL. Lets say my database consists of Parent1 with layer id 1, Parent2 id 2, child1, child2, child3. The ids are from the service item details page.

I am trying to create two separate surveys for the same existing hosted feature layer. Survey 1 has Parent1 in the form_id colum of the xls form and repeats called child1, child2, child3. Survey 2 has Parent2 in the form_id and the same repeats.

I need this structure because some status fields are edited in the parent layers, and it allows technicians to create entries in each child layer without having to go back to Field Maps and open a new survey for each one.

When I try to publish Survey 1, I get Parent layer ID 2 not found for table child3. The survey publishes when I remove the repeat called child3. When I try to publish survey 2, I get Parent layer ID 1 not found for table child1. When I remove child1, I get Parent layer ID 1 not found for table child2.

I found this thread

https://community.esri.com/t5/arcgis-survey123-questions/publish-error/td-p/1009217

and saw that someone was able to fix this by copying the child layer, but this is not an option because I need all the child data in one layer, regardless of which parent it is related to.

Is there anything I can do to make this work?

OliviaK_99 · Answer

If anyone else comes across this thread, the issue has been logged as a bug: BUG-000120260

OliviaK_99 · Answer

Thank you! I will try going to support

TylerGraham2 · Answer

I think ChatGPT may be partially correct, but not for the reason it thinks it is right. I manage a feature service that uses both Field Maps and Survey123 and a key part of it is multiple geometry feature layers (collected in Field Maps) act as parents to a single table (Data entered in 123) for notes which allows all of our field notes to be in a single table. I don't have any issues with it, though I only have one form created from anything in the feature service.

However, I created a test feature service with 2 parent layers related to 3 child tables to see what would happen. I was able to publish the first survey from a parent layer referencing the child layers without an issue. I ended up with the same problem as you were having when I tried to publish the second survey using the other parent layer with the child tables as repeats. I wonder if this is a bug or an undocumented feature when publishing additional surveys?  It might be worth reaching out to the esri help desk.