topic Re: Survey send database error, possibly due to pulldata@layer in ArcGIS Survey123 Questions

Survey send database error, possibly due to pulldata@layer

mshanaghan — Tue, 28 Mar 2023 13:26:10 GMT

My survey is set up to calculate a geoshape question with the geometry from a hosted feature layer on the Portal. The calculation appears to work fine while filling out the form (building footprints appear in the map), but I receive a "database error" upon hitting submit.

Any ideas why surveys would not submit when pulling in geometry from a hosted feature layer? Without the pull data geoshape calculation, surveys do submit.

A screencap of my xls form is below. Thank you.

Re: Survey send database error, possibly due to pulldata@layer

jcarlson — Tue, 28 Mar 2023 13:46:33 GMT

Have you manually set the length of your temporary fields?

Make sure that you set the length of the get_record1 and gr1_shape_temp fields to something really large. If you don't manually specify the length, even though it's a null field, the survey will truncate the text to something like 255 characters, so the returned JSON text is probably getting clipped.

Re: Survey send database error, possibly due to pulldata@layer

mshanaghan — Tue, 28 Mar 2023 14:01:53 GMT

That was exactly the problem. Thank you so much!

-Maegan