"String or binary data would be truncated. The statement has been terminated" Error on survey123 iOS only.

710
1
04-01-2020 02:25 PM
SamLee__MES_
New Contributor

A survey I published in survey123 is recieving the following error "String or binary data would be truncated. The statement has been terminated". This error only occurs on iOS devices. Is this a know issue where the iOS version of survey123 adds additional characters to multi-answer questions.

Tags (2)
0 Kudos
1 Reply
by Anonymous User
Not applicable

Hi Sam,

This error means that there is data in one of the fields in the survey that has more characters than the fieldLength set for that field. So when you try and submit that record it will truncate the data in that field. Can you share your xlsx file so we can take a closer look?

Regards,

Phil.

0 Kudos