nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

“String or binary data would be truncated. The statement has been terminated.”

Anonymous User

I created a Survey123 for a partner organization collecting data for us. They have collected the data but have the following error when trying to sync:

In my experience, this is because a an answer exceeds the character field length limit. Is the the only reason for this error? I don't have their tablets so I can't see what question is causing the issue. I looked at the XLS form, but don't seem to to catch the issue.

Wondering if there is another problem causing the error.

WYNDD Short Survey.xlsx

Najděte více příspěvků označených jako

Accepted answers

ZacharySutherby

Hello @Anonymous User,

In testing on my end one field that seems to be causing the error is the Project Name field. For the bind::esri:fieldLength it is set to 30 but the value that was submitted in my test survey is "MedBow Springs/ WYNDD Survey 2021" which is 33 characters.

Thank you,

Zach

All comments

Anonymous User

I did not know you could use this tool. I will keep it in mind for the future.

Anonymous User

Great! That worked and they were able to sync the surveys. Thank you.

DeonLengton

Hi @Anonymous User

If you still struggle then you could have the user enable diagnostics on the tablet and have them send you the log file - it should cast more light on the erroneous field causing the sync issue.

Regards

Deon

ZacharySutherby

Hello @Anonymous User,

Thank you,

Zach

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.