topic Re: Publish Error in ArcGIS Survey123 Questions

Publish Error

raybricedev — Mon, 14 Dec 2020 04:21:06 GMT

Hi, I've created a FGDB in Catalog 10.8. Added GlobalIDs, then added Guid fields to each table, e.g. Project table has ProjectGuid of type Guid. I've created 1-to-many relationships between the tables based on the GlobalID -> Guid field of the related table. Added all the tables to Arcmap, Shared as a service to AGO. Gave it all the permissions when publishing, e.g. sync, edit, delete, etc. In Survey123 Connect, create new survey from service I just published. I made a couple minor changes in the label field, saved the excel XLSForm which updated the Survey then tried to publish and am getting an error: Parent layer id 11 not found for table T12_Construction_Contractor. I've checked the service and don't see any differences between the fields in the .xls form and the published layer. Thanks for any help! -Ray

Re: Publish Error

ZacharySutherby — Tue, 12 Jan 2021 02:01:02 GMT

Hello @raybricedev,

From the error message it looks like Survey123 is having an issue identifying the parent layer related to the T12_Construction_Contractor table.

Does that table happen to have multiple layers related to it or another tertiary layer or table related to it?

If possible would I be able to obtain a copy of the File Geodatabase with the layers and tables for testing on my end?

If you don't want to share it over Esri Community feel free to email it to my Esri email ZSutherby@esri.com.

Thank you,

Zach

Re: Publish Error

PatrickKent1 — Fri, 07 May 2021 17:12:43 GMT

I am experiencing the same issue. I have a GDB with multiple feature layers and related tables. I created 2 separate survey forms, each with their own target feature layer. But the two target feature layers are both related to a table that makes up many of the questions on the survey. I was able to publish one of the surveys but the other is showing the same error described above. The fact that one worked and the other did not is very confusing since they are virtually the same survey and share the same basic structure and related table. All of the fields in the survey match the table fields. Please post the solution if one has been found.

For context, I have set all relationships based on Global ID to GUID and have enabled attachments for all features and tables.

Thanks!

Re: Publish Error

KellyArmstrong — Tue, 11 May 2021 15:44:36 GMT

I am having the same issue. I get: "The custom feature service submission url is not compatible with this survey (Parent layer id 0 not found for table 'table_name')"

Re: Publish Error

PatrickKent1 — Tue, 11 May 2021 18:06:47 GMT

I have found a workaround to the issue. I think it has to do with basing 2 surveys on 2 feature services that both share a related table. It seems to confuse AGOL when the surveys are published. I was forced to make a copy of the related table to that each feature service would have its own related table. That solution has worked successfully.

Re: Publish Error

ZacharySutherby — Tue, 11 May 2021 19:39:03 GMT

Hello @KellyArmstrong,

If you navigate to the item details page of the feature service your survey is pointing to. At the bottom of the page there is a URL link, if you click the "view" button it will open the REST endpoint of the feature service in a new tab. On the page that it opens towards the top there will be a Layers section. Does the name of the layer with ID 0 match "table_name".

If not you will need to update the value you have in the form_id column of the settings worksheet in the XLSForm to match the name of the layer from the REST endpoint.

Thank you,

Zach

Re: Publish Error

KellyArmstrong — Tue, 11 May 2021 21:27:49 GMT

@ZacharySutherby ,

It doesn't, but that is because I am dealing with a related table, and its ID is 1. In the form_id column, I have the related table name.

Re: Publish Error

ZacharySutherby — Tue, 11 May 2021 22:11:03 GMT

Hello @KellyArmstrong,

If you're pointing the form_id to the related table you will also need to remove the begin and end repeat rows in the survey sheet. The only questions that should be in the survey sheet should be the questions that are in the table.

Please refer to the first six steps of this Tech Support KB article for the workflow.

Thank you,

Zach

Re: Publish Error

ZacharyO — Tue, 16 Nov 2021 20:16:02 GMT

@ZacharySutherby , just to be sure I'm understanding correctly:

One cannot write the output of a survey123 form to an existing table related to a an existing feature if there are ANY repeats in the form. Is that correct?

So this is not possible:

Say I have "Parking Lots" that have a related "inspection" table.

I cannot write some of the answers to the related "inspection" table AND have a repeat section of specific observations too.

In essence I envision that what I want is to write general info about the inspection event (date, inspector, site name). And then have a repeat section that would establish another related survey123 table of specific repeat questions related to the first general inspection event table ?

So "parking lot 1" feature has a related "inspection" table with an inspection on 1NOV and that "inspection" table has "observed defect" table of repeats related to that where on 1NOV a pothole was observed, trash was observed, graffiti was observed as three separate repeat events.

Re: Publish Error

KristinThorpe1 — Fri, 10 Dec 2021 16:16:24 GMT

Hi @PatrickKent1 ! I know it's been awhile, but I'm working on an inspection survey with a similar schema to yours. I have a Site table (child) that is related to two separate layers, a Construction point feature (parent) and an Inspection table (parent) (The KEY fields are GUIDs). When I try and publish my survey, I get the error "Parent layer id 2 (Construction) not found for table Site". I'm wondering if your workaround will work if I copy the Site table. How did you copy your layer? Did it maintain the relationships? Do the two copies still talk to each other so if you edit one the other also updates? Any information will help! Thank you!

Re: Publish Error

PatrickKent1 — Sun, 19 Dec 2021 17:12:54 GMT

Hi Kristin, based on your diagram and description, copying the Sites table might work. It depends on the nature of the table. In my case the table I copied was really just a subset of questions that were not unique to either of the 2 parent features such as lat, long, repair status, ect. It looks like your Sites table might be the same but I am not sure. As long as there does not need to be one Sites dataset that is unique from the other tables.

To answer your question of whether it saves the relationships, the diagram of 2 parents sharing a related table will change. If you make a separate copy table and each parent only has one child then the relationships obviously will work differently. The copies do not talk to each other since they are not one dataset but rather a subset of fields that apply to both parents.

You can copy the table in Pro and just copy paste into the same GDB.

Hope this helps.

-Patrick

Re: Publish Error

cphelan7 — Thu, 09 Jun 2022 17:11:12 GMT

Hello,

I know this thread has gone quiet, but it is the closest discussion I can find to the issue I am having. @ZacharyO , have you gotten an answer to the last question you posted?

I have a dataset of sampling plots where field crews collect data on all the trees that fall within a specific radius of each plot. I am trying to create a survey from our existing data that would allow crews to revisit the plots and cycle through repeats in the survey to update data for all the trees at each plot. I have done all the relates, GlobalIDs, parent guids, etc. I am getting the same error for parent ID not found. Thank you for any help!

Re: Publish Error

ALBJORGUI — Wed, 21 Jun 2023 13:47:20 GMT

Hi @cphelan7 ,

Did you sort it out in the end??