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.
Solved! Go to Solution.
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.
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.
That was exactly the problem. Thank you so much!
-Maegan