Send Error: GUID FK Issues

Question

I have a feature service comprising of a feature class (outfalls), related table (inspections), and relationship class tying it all together. At first I was receiving the error "conversion failed when converting from a character string to unique identifier". I happened upon this solution and was able to insert the regex conditional statement into Survey123 Connect.

Now, when I submit records in S123, I get "String or binary data would be truncated. The statement has been terminated".

I've removed and replaced every single field and found that the FK is the only troublesome field.

I've attached my xls file to this post, as it seems as though many other have done the same when running into similar issues.

Thanks in advance,

MG

Dry Weather Inspections 2.xlsx

1678205416673.jfif

Anonymous User · Answer

Thanks for the reply, Doug.

After posting the initial message last night, I did just what you suggested. I'm still getting the send error.

When I adjust the field lengths (all 255), I am unable to publish the form. The error only occurs on text fields, not select_one fields. When I match the field lengths to the table counterpart in AGOL, it publishes just fine.

dougbrowning · Answer

Remove or bump up the field length setting.  A GUID is going to be more than 38 chars.  I always do 255 for everything (which is the default).

Hope that helps