topic Re: I have trouble setting up the relationship tables for nested repeat in ArcGIS Survey123 Questions

I have trouble setting up the relationship tables for nested repeat

YukoYokozawa — Wed, 05 Jun 2019 20:50:27 GMT

I'm testing nested repeat using feature service I created in a geodatabase. I made three layers of repeat, and the last repeat will upload images with some notes. It's Survey-Site-Grid-Image structure. I created three related tables (site, grid and image tables) and I enable attachment to only the image table. The "Enable Attachment" created one more table and relationship class. I also created the relationship class for each table (except the last attachment table because the relationship was already created.) When I published the dataset, I added the feature layer, site table, grid table, image table, and the attachment table into the map, then published them.

I created a form from the dataset using Survey123 connect, and edit the XLS. I tried not to touch too much, so I edited only the labels and added "query=1=1 allowUpdates=True" to the bind::saveincomplete field for the begin repeat rows. Then published the form. It published successfully.

I downloaded the form into my field app (Windows version installed into my PC), and filled the survey, then submit. The problem is the submit never complete. The submission got stack with this message below. The table name is the image table in the dataset. I had no problem publishing the form, so I'm guessing I made a mistake during setting up the related tables especially for the image table. Or I shouldn't include the attachment table to the dataset?

Thanks!

Re: I have trouble setting up the relationship tables for nested repeat

RogerFarmer1 — Wed, 05 Jun 2019 21:17:06 GMT

Hi Yuko Yokozawa‌

We had the same issue, and fixed it by not including the attachment table in the map.

Regards,

Roger.

Re: I have trouble setting up the relationship tables for nested repeat

DougBrowning — Wed, 05 Jun 2019 21:48:48 GMT

Yep you now cannot have the attach table in the map when you publish the service. It just figures it out somehow. Used to be able to.

Re: I have trouble setting up the relationship tables for nested repeat

YukoYokozawa — Wed, 05 Jun 2019 22:03:26 GMT

I removed the table from the map and re-published it. Re-created the form and published. Now it stacks here...

It looks better than before (it's sending data) but it's been 30 min, and still not completed. I attached 5 or 6 photos but they are all 10 to 30 KB, I think the total would be less than 100 KB (not MB!). I can't tell if I should wait for more...

Re: I have trouble setting up the relationship tables for nested repeat

YukoYokozawa — Wed, 05 Jun 2019 22:31:05 GMT

Okay, I checked all the features in the geodatabase and found the data I sent. I actually used the iOS field app to try again, and it stacked at the same message. Both data from Windows and iOS apps are in the feature layer and tables. I'm happy the data showed up in the tables, but I don't know what to do with this not stopping message. In the iOS app, I forced to close the app and re-open it, then I found the survey is in the outbox. So I tried to send it again, and the same thing happened, and there are the second set of the data in the geodatabase. This is not good...

Anyway, I forgot to say thanks to you both. At least the data gets into the database...

Re: I have trouble setting up the relationship tables for nested repeat

RogerFarmer1 — Wed, 05 Jun 2019 22:43:03 GMT

Yes, I have had this issue too;

the mobile app paused on sending a collected survey (not an existing record)
stuck on green loop (or perhaps I didn’t wait long enough?)
I used the back button to get out of the loop
The record ended up in SDE (I checked with Arc Pro)
I went back to the app survey and the record was still in the Outbox
I sent again
Now there are two identical records (except for GlobalID and ObjectID) in SDE

This was 22 February 2019, so was Android v 3.2 on Samsung Galaxy Tab S4 SM-T835

Re: I have trouble setting up the relationship tables for nested repeat

YukoYokozawa — Wed, 05 Jun 2019 22:45:51 GMT

Yes, exactly the same! Were you able to fix the issue?

Re: I have trouble setting up the relationship tables for nested repeat

RogerFarmer1 — Wed, 05 Jun 2019 23:24:13 GMT

No, I think it dropped off the radar at the time because the survey was:

not pulling data from a csv file and using it in the instance name, and
the survey for a standalone table not showing in the Data section/tab of the Survey; instead it points to the feature layer in the map.

It was a situation where there were 35 individual surveys pointing to 35 individual standalone tables in a single feature service referencing 35 individual SDE tables.

I don't think I can help much from here, but it's good to know it's not happening to just me.

Regards,

Roger.

Re: I have trouble setting up the relationship tables for nested repeat

YukoYokozawa — Wed, 05 Jun 2019 23:30:57 GMT

I see. Thank you for answering my question! It helped me a lot.

I just found the question and answer for the sending data looping. Here is the answer for it:

"Setting the forward label and the backward labels of the geodatabase relationship class to an identical string value that is not <blank>/null resolved the problem."

I don't really understand what exactly do to fix the problem, but I'll test with my data and post the result here.

Re: I have trouble setting up the relationship tables for nested repeat

RogerFarmer1 — Wed, 05 Jun 2019 23:39:30 GMT

Yes, I do concur with the solution. I wasn't aware of the 'not null' part.

Screenshots not my own.

Re: I have trouble setting up the relationship tables for nested repeat

RogerFarmer1 — Wed, 05 Jun 2019 23:52:05 GMT

I would like to add in this part of the thread that the duplicate record appearing because of backing out of a loop could be a symptom of another issue. At that point, the relationships had already been built for all tables, etc. and this happened once only for only one of 35 similar standalone tables in the feature service.

I think this should be raised as a separate issue.

Re: I have trouble setting up the relationship tables for nested repeat

YukoYokozawa — Thu, 06 Jun 2019 17:46:29 GMT

The solution worked! My survey form works just fine now.

Thanks for the screenshots, I made the setting just like that.

Re: I have trouble setting up the relationship tables for nested repeat

DougBrowning — Thu, 06 Jun 2019 19:58:54 GMT

This may go back to a "bug" I posted a few months ago showing that 123 is not properly creating the relationship classes. No one responded to my post at all though.

It is for sure wrong.

The red circle shows a 123 Relationship class with the name missing.

The blue circle shows my own Relationship class with the name filled on properly.

Will you ever be fixing this guys? Its been in there since v1 I think. It makes these really hard to use in a web map. You cannot even leave it blank when creating so not sure how this happens.

thanks