[ODK2] too many sql variables with ODK survey


For a big form, I have a “too many sql variables” error with ODK survey. Is there a limit somewhere ?




The limit is 999 variables but the number of fields you could have will be much lower than that. Some fields take up more than 1 variable, for example geopoint takes up 4 variables and attachments take up 2 variables. We also need to pass metadata variables, which takes up about 10 variables.

I would recommend you to stay much lower than the limit, your survey will perform much better. You could try breaking things up into multiple screens.