Survey send database error, possibly due to pulldata@layer

Question

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.

jcarlson · Accepted Answer

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.