Cannot submit survey results because of a "Code 1000" error

Question

I am trying to create a survey to replace paper data sheets. While testing, complete a survey, but when I submit the results to see what the database looks like, I get a Code 1000 error; "string of binary data would be truncated". I understand this happens when my answers combined are too long. I have checked "Show Data Values" and "Validate Input" but cannot see where I am making a mistake. I have attached a copy of the Excel file.

Ant help you can provide is greatly appreciated.

Chris Anderson

Research Associate, Cartographer, Graphic Designer

Florida Fish and Wildlife Conservation Commission

FDM GRFS Interview.xlsx

NEERAJNASWA_0-1654248967440.png

GaryBowles1 · Answer

Also check NO_HARV_CATCH_TABLE

--gary

GaryBowles1 · Answer

Change the select_one y_n to select_one yes_no for field ALL_ANG_4_DISCARDS. The y_n values are 1 character long and that is what the schema for that field is set to. You can change the select_one to the y_n or make the value in the bind::esri:fieldLength 3.

--gary