Error while accessing or saving values to the database on ODK Survey

I am trying to work out a household survey (on ODK Survey) but I keep
running into this error:

"Error while accessing or saving values to the database".

It occurs when I add more questions to the form. Apparently the forms work
well when there are only very few questions.

attached is the xls form and the corresponding JSON file.

Please help me understand what the problem could be.

formDef.json (21.9 KB)

test3.xlsx (10.5 KB)

If you are working on an android device, you will need to delete the
metadata directory under the opendatakit/survey/metadata directory.
If you are working on a Chrome browser, you will need to clear your
browsing data. When you modify a form that has previously been
opened, the database used to store the information from that form has
been created. When you modify a form, the database needs to be
recreated with the new information. Deleting the metadata directories
ensures that the correct database structures will be created. Please
note that deleting the metadata directory or clearing the browser data
will delete any previously saved data. However, if you are working on
form development, this shouldn't be a problem.

Clarice

··· On Sun, Jun 8, 2014 at 10:59 PM, Wycliffe Odongo wrote: > I am trying to work out a household survey (on ODK Survey) but I keep > running into this error: > > "Error while accessing or saving values to the database". > > It occurs when I add more questions to the form. Apparently the forms work > well when there are only very few questions. > > attached is the xls form and the corresponding JSON file. > > Please help me understand what the problem could be. > > -- > You received this message because you are subscribed to the Google Groups > "ODK Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit-developers+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.

And if you are using the Application Designer, you will need to "Purge
Database" to remove the old table definition so that the new one, with the
additional fields, can be created.

··· On Mon, Jun 9, 2014 at 10:40 AM, clarice larson wrote:

If you are working on an android device, you will need to delete the
metadata directory under the opendatakit/survey/metadata directory.
If you are working on a Chrome browser, you will need to clear your
browsing data. When you modify a form that has previously been
opened, the database used to store the information from that form has
been created. When you modify a form, the database needs to be
recreated with the new information. Deleting the metadata directories
ensures that the correct database structures will be created. Please
note that deleting the metadata directory or clearing the browser data
will delete any previously saved data. However, if you are working on
form development, this shouldn't be a problem.

Clarice

On Sun, Jun 8, 2014 at 10:59 PM, Wycliffe Odongo odongow@gmail.com wrote:

I am trying to work out a household survey (on ODK Survey) but I keep
running into this error:

"Error while accessing or saving values to the database".

It occurs when I add more questions to the form. Apparently the forms
work
well when there are only very few questions.

attached is the xls form and the corresponding JSON file.

Please help me understand what the problem could be.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com