topic Re: String Binary data will be truncated error when using a Summary table in ArcGIS Survey123 Questions

String Binary data will be truncated error when using a Summary table

DiegoBrenes1 — Mon, 30 Jan 2023 16:16:36 GMT

Hello, I've seen some posts related to this topic, but didn't find one with a specific issue related to a summary table:

- I have an existing published survey and I created a summary table using HTML tags, for the users to be able to see a summary of what they have entered.

For this, I used a solution posted elsewhere in this forum, as shown here:

I get the String Binary data will be truncated error when I enter more than 2 items on the repeat question (sometimes the users need to enter many items in this repeat). I am guessing that it is the length of the summary table content what is creating the issue.

I tried changing the bind::esri:fieldLength in the note field, but I get the following error when republishing the survey (this is a an existing surver):

Any ideas for what is causing this problem and how to solve it?

Thanks,

Diego

Re: String Binary data will be truncated error when using a Summary table

DougBrowning — Mon, 30 Jan 2023 16:29:16 GMT

If you do not need the field in the final data service you can set the bind esri field type to null and it will not send it up.

If you need it up then it is going to need to wipe the service to make that change. Just the way schema changes are.

Hope that helps

Re: String Binary data will be truncated error when using a Summary table

DiegoBrenes1 — Mon, 30 Jan 2023 17:04:37 GMT

Thank you Doug. That worked! I added null to bind:esri:fieldType on the note and the two calculate fields and that solved the issue.

Regards, Diego