Error message while uploading form

Good morning,

I have repeatedly tried uploading an xml form onto our (recently updated)
ODK Aggregate server but I get the following error message. This form is
identical to 3 other forms that I have uploaded in the last few days,
except for Form ID and one variable, which is NOT the one listed in the
error message.

HTTP Status 500 - StatementCallback; uncategorized SQLException for SQL
[SHOW CREATE TABLE
odk_prod.EL20015_DISCLOSURE_LEVEL_DISCLURE_SCHOOL_TEACHER_PRINCPAL_7_26];
SQL state [HY000]; error code [1033]; Incorrect information in file:
'.\odk_prod\el20015_disclosure_level_disclure_school_teacher_princpal_7_26.frm';
nested exception is java.sql.SQLException: Incorrect information in file:
'.\odk_prod\el20015_disclosure_level_disclure_school_teacher_princpal_7_26.frm'

··· ------------------------------ Even though I get this message, the form appears in the forms list in the server. I am able to download the form onto a device, but I cannot have the form accept submissions, the error message is: Error: Form Definition incomplete or missing.

What can I do to address this error? I have already redone the form and
checked for errors with the .xls--.xml converter.

Thank you very much in advance for your advice,
Elona

The quick solution is to shorten your field names.

If you are willing to share the form definition with me, please send it
directly to me ( mitchellsundt@gmail.com ).

This is caused because all your field names must be compressed into a
63-character-or-less length string. Since field names can be repeated
within the form (you can have a /data/patient/name and a /data/doctor/name
and a /data/facility/name all in the same form), what actually needs to fit
in the 63-character-or-less string is a compression of that fully qualified
list of group names and field names.

If you have a lot of field names that start
'disclosure_school_teacher_...' then all of these need to be shortened but
kept distinct from one another.

While it would be easy to just store these as field001, field002, we
instead try to preserve your field names and group names so that if you do
ever need to directly examine the database, you stand some chance of
understanding and decoding the structure of the tables from the compressed
column names.

In your case, it is likely that the addition of the new fields somehow
caused this algorithm to fail (which is why I would like to see your full
form definition). By simply changing your field names to be more distinct
and/or shorter, you can slightly change the resulting set of shortened
column names, and get around this failure of the algorithm.

But, again, I would be very much interested in seeing your form definition.

Mitch

··· On Thu, Mar 12, 2015 at 5:26 AM, Elona Toska wrote:

Good morning,

I have repeatedly tried uploading an xml form onto our (recently updated)
ODK Aggregate server but I get the following error message. This form is
identical to 3 other forms that I have uploaded in the last few days,
except for Form ID and one variable, which is NOT the one listed in the
error message.

HTTP Status 500 - StatementCallback; uncategorized SQLException for SQL
[SHOW CREATE TABLE
odk_prod.EL20015_DISCLOSURE_LEVEL_DISCLURE_SCHOOL_TEACHER_PRINCPAL_7_26];
SQL state [HY000]; error code [1033]; Incorrect information in file:
'.\odk_prod\el20015_disclosure_level_disclure_school_teacher_princpal_7_26.frm';
nested exception is java.sql.SQLException: Incorrect information in file:
'.\odk_prod\el20015_disclosure_level_disclure_school_teacher_princpal_7_26.frm'

Even though I get this message, the form appears in the forms list in the
server. I am able to download the form onto a device, but I cannot have the
form accept submissions, the error message is:
Error: Form Definition incomplete or missing.

What can I do to address this error? I have already redone the form and
checked for errors with the .xls--.xml converter.

Thank you very much in advance for your advice,
Elona

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


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

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