topic Re: Connot create a row of size X which is greater than the allowable maximum row size of 8060 in ArcGIS Survey123 Questions

Connot create a row of size X which is greater than the allowable maximum row size of 8060

amcnicol — Mon, 04 Mar 2024 18:16:16 GMT

We've encountered an issue in 2 of our surveys, where no errors were found in Survey123 Connect, and after recent [Publish], surveys won't send from the Field App.

The error message says the following:

Send Error
This survey could not be sent due to the following error:

Cannot create a row of size 10196 which is greater than the allowable maximum row size of 8060. The statement has been terminated.

This has not been an issue before, with only minor changes being pushed in the last [Publish]. We've checked the limits of all fields, and the package which is sent, and both are nowhere near the 8060 limit. The stated number (10196) gets bigger after every [Publish], as if it's accumulative, rather than replacing the previous error.

We're aware this is a SQL error, and wonder if any changes have taken place from the ESRI side which could have resulted in these errors occurring.

For reference, our surveys are very big - up to 750 rows on the Excel sheet, but haven't encountered this issue until the past 2 weeks, where 2 of our surveys have fallen over. Each time, we've been able to create a new Project, copy/paste the files, and it seems to work perfectly.

We're almost at the stage of going live with this project, and fear the loss of data if these surveys fall over if we publish an update once LIVE.

Re: Connot create a row of size X which is greater than the allowable maximum row size of 8060

Reuben — Tue, 05 Mar 2024 04:51:57 GMT

hi,

We recently, had experienced the same issue. It happen when we conducted our survey on field apps.

We previous, do the same survey online via web application with no such issue showing up.

We're also waiting for further response from ESRI

Re: Connot create a row of size X which is greater than the allowable maximum row size of 8060

PaulSweeney3 — Wed, 06 Mar 2024 12:04:14 GMT

I had this issue also i was able to resolve by setting the majority of my calculation fields to null types ( I had a large number of pulldata(@layer) calcs in my form ). if you have the option of doing this also consider using integers where possible to reduce the size of the row count.

Re: Connot create a row of size X which is greater than the allowable maximum row size of 8060

amcnicol — Fri, 08 Mar 2024 09:24:14 GMT

Hi @PaulSweeney3

Thanks for your comment. We do have a lot of fields, pulldata calls, and calculations on our forms, but these are all required for functionality.

The strange thing for us, is that saving the survey as a new project (all rows intact) somehow works flawlessly. This suggests the SQL database is corrupting somehow, rather than it being any limitation on the form itself.

Re: Connot create a row of size X which is greater than the allowable maximum row size of 8060

Stalin — Thu, 11 Apr 2024 16:27:33 GMT

Greetings.
Have you managed to find a solution to this problem?

Re: Connot create a row of size X which is greater than the allowable maximum row size of 8060

amcnicol — Fri, 12 Apr 2024 08:20:15 GMT

Hi @Stalin

ESRI Support are still looking into this case, but can't offer any explanation yet.

Re: Connot create a row of size X which is greater than the allowable maximum row size of 8060

amcnicol — Thu, 27 Mar 2025 09:15:50 GMT

In the end, I had to copy/paste my survey as a new project. There was no explanation for the issue, other than 'something had corrupted'. New project works without issue.