Hi Esri World,
I created a survey using Survey123 Connect and sent it out. Some users report that they get an error message that says: "String or binary data would be truncated. r/n the statement has been terminated" when attempting to answer a multi-line text question. I changed the character limit for this question from the default to 1000, but that doesn't seem to be helping. Any ideas?
Caitlin
Hi Caitlin,
Unfortunately, modifying the length of text field storage is not capable within ArcGIS Online, so Survey123 cannot support it.
Thanks James. What about the bind::esri:fieldType column in Survey123 Connect? This is where I changed the number to 1000 to override the default value of 250.
That will set the size on initial publishing only- it can't update the size due to the limitation with ArcGIS Online.
Hi James,
Couple of questions:
This would allow more flexibility for anyone who has to create surveys for clients/managers who have had a 'change of heart' in the direction they are taking after giving initial instruction (like that never happens LOL). Or is there a workaround by adding a new multiline text field in the XLSForm with the required increased character length specified in the bind::esri:fieldLength column? Or any other 'workaround'? Thanks.
In addition to Timna's points, from what I got, we cannot update the field lengths once the survey is publisher, correct?
BUT, here are a few questions:
Tks!
Hi Diego, Timna,
On Timna's questions:
1) On the maximum length- the max length for a file GDB's field is 2.147 million (see File geodatabase size and name limits—Help | ArcGIS Desktop ); I would presume that AGO could support that as well.
2) On changing field properties while the feature class is empty - this is possible in the ArcGIS Desktop environment using Alter Field—Data Management toolbox | ArcGIS Desktop . Currently, this is not available in the ArcGIS Online environment.
On Diego's questions:
1) The web browser and field app forms observe the same limitation
2) The field length cannot be directly changed in Survey123 Connect; you would need to delete the field and then recreate it with the new length.
Thanks James,
Would there be any other cause for the error message? ("String or binary data would be truncated. The statement has been terminated.")
Hi Diego,
There are other potential causes, but most are related the size of a string field. For example, Survey123 Connect used to publish a select_one question's field with a length long enough to hold the values listed at the time of publishing; if a longer entry was added, that would result in this error as well.
Hello,
I have the same error message that is related to a uuid() calculation that is being done. Within Survey 123, I have the ESRI Field type set to "esriFieldTypeString" and my character limit to 10 which matches the size of the text field that it is feeding in AGOL Feature Service. If I take the uuid() calculation off, everything works. Any ideas on how to overcome this issue? Perhaps a different calculation to populate a unique ID for a column, or change of field/limit settings?
Thanks,
Will
James,
additional note: if I click on this field that is being populated with the uuid() in the survey on the mobile app, then go to the next field without doing anything to the random value calculated, the form submits fine...So if I don't change any values, just select the field, then go to the next and it works. If I do nothing to this field> fill out the rest of the survey, then it will not submit giving me the error described above. Seems like a bug. Any idea how to overcome this? This field is not set to "required" either.
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
