Operation Rolled Back separate repeat tables

[ChristopherDawe]

I am having a frustrating issue on a newly created survey where when submitting a survey instance with data in all possible tables and repeats, i get an operation rolled back notice, but don't if i submit separately. the survey design is as follows

Master survey (geopoint)

- repeat 1 - (geotrace)

- repeat 2 - (geopoint)

The repeats are not nested, so both have the master survey as their "parent". I can submit to the parent survey on its own without issue, i can submit to parent plus repeat 1 no issue, parent plus repeat 2 no issue, but when trying to submit to parent plus both repeats it  fails and says operation rolled back.

Its a fairly straightforward survey by all accounts, nothing really complex happening but i cant figure out whats causing it to fail

Has anyone encountered this issue before?

@JamesTedrick @IsmaelChivite 

[ChristopherDawe · Accepted solution]

I think i found the issue, i tried submitting through the web app rather than android app and i got the followig message

• [{"id":0,"addResults":[{"objectId":18,"uniqueId":18,"globalId":"{62006722-CB2D-4F9B-811F-A9B0F2FA3C91}","success":false,"error":{"code":1003,"description":"Operation rolled back."}}]},{"id":1,"addResults":[{"objectId":-1,"uniqueId":-1,"globalId":"{C04E7A87-5069-46C5-81A5-2603C8E84E12}"," success":false,"error":{"code":1000,"description":"String or binary data would be truncated.\r\nThe statement has been terminated."}}]},{"id":2}]

I checked the field lengths of a couple of questions and increased and it allows me to submit now, just odd that it worked individually but not together!