Odk Collect Upload Results Invalid Sheet Id

Guide: Troubleshooting common error messages

Error when uploading XLSForms

1. "Class with this id or SMS-keyword already exists" – Uploading a form to a project that has some other form with aforementioned form-ID. Ensure the form-ids in your project are unique.
2. "The survey canvass must accept on the start row name and type columns" – Misspelling a cavalcade header in the survey sheets or not including the required column headings. Ensure the cavalcade headers are correctly named (i.e. "name" not "Name", "NAME") as XLSForms are example-sensitive, and all required columns are included (i.eastward. type, name, and label for the survey sheet and list_name, name, and label for the choices sheet).
3. "You must have a sheet named (case-sensitive): survey" – Sail names should be appropriately named (i.due east. "survey" not Sheet one, "Survey" or "surveys").
4. "The name 'practice _survey' is an invalid xml tag " – File names must brainstorm with a letter, colon, or underscore. Subsequent characters tin can include numbers, dashes, and periods.
5. "There are ii survey elements named e.one thousand 'q1_name' in the section named 'practice_survey'" – Field names are not unique. Ensure the field names in the survey sail are unique.
6. "The survey chemical element named 'q1_name' has no label" – A field name within the survey sail is missing a label. All field names should have a label.
7. "In that location is no survey element with this name" – Referencing a field proper name that is missing in the survey worksheet.
8. "Row:8 List name non in choices canvass: yes_no" – List proper name and reply choices for select_one or select_multiple question types are missing in the choices worksheet.
9. "No https status error when uploading a form" – This error can be due to having a large number of choices in the choices worksheet. The workaround is to include a CSV file with the choices and pull the choices from this document using the search function or using an external select . Please notation these only work for ODK Collect.
10. "invalid title value; value shouldn't friction match a URL" – The form has a title that contains URL characters such as . or: or/. Remove the characters from the form_title column nether settings sheet and upload the form again.

Enketo mistake letters

1. "Data server did not accept information . Contact the survey administrator please. (400) " – Error returned when editing submissions of a form that was replaced. Return to the form'southward Table view, select the tape to edit, and retry editing. If the mistake continues contact our support team.
2. "NotFoundError: DOM IDBDatabase Exception 8" – This fault occurs when trying to access Enketo webforms in Version 9.X of Safari. Please try endmost all Enketo tabs in the browser, and so open the grade again.

Server error messages

1. "404 Not Found" – This fault is displayed when a submission is non found in our servers.
2. "403 Forbidden " – You do not take the correct permissions to submit data. Make sure the project is shared by the owner, and the user is assigned 'Tin submit' or higher permission level .

ODK Briefcase error messages

1. "202" – This fault occurs when indistinguishable submissions have been pushed to the server.
2. "No peer certificate" –  Please make sure the device has the correct appointment and time. Fourth dimension differences betwixt servers and devices can cause this mistake. On your device, g o to Settings -> Engagement & time -> then choose Automatic date & and Automated time zone .
3. Fault getting batches of instance IDs: Non Establish In that location is no submissions to download – This error occurs when you attempt to pull a grade without whatever data submission.

ODK Collect mistake messages

1. "Sorry! The application ODK Collect process org.odk.collect.android has stopped unexpectedly." – Please close the ODK application and restart it.
2. "Coffee.net.UnknownHostException" Unable to resolve host "odk.ona.io". No accost associated with hostname: Network Connection Failed.This could be caused by several factors such as:
   • Connectivity – The error could be due to slow network connectivity. Ensure that you are able to connect to https://odk.ona.io/formList or whatever other website using your device'south browser. If you cannot, ensure that yous can connect to the internet through a computer that uses the same admission point.
   • Date and Time – The device may not take the right date and time. Bank check whether the engagement and time are prepare correctly on the device. Go to Settings -> Date & time -> and then choose Automatic date & and Automatic time zone.
   • Incorrect Configured URL -The device should point to the correct server https://odk.ona.io as explained in this guide. The formlist error can besides be remedied past changing the URL from https://odk.ona.io to http://odk.ona.io. Please note this method will pause encryption and should not be done if submitting sensitive information.
3. " Connexion timeout error" – A connexion timeout usually indicates that the client is waiting as well long for a response from the server. It is probable that it took a long fourth dimension for the upload and ODK Collect disconnected before the server could respond. Check whether the submissions are using WiFi or the phone'southward network data. Does each submission include images/videos? What is the boilerplate size of these files? Are there multiple images/videos per submission? If the answer to nigh of these questions is yep, the best selection would be to employ WiFi, which might be more stable when making submissions.
4. "403 error" – You do not have the correct permissions to submit data. Ensure that the project is shared with the user and they are assigned a "Can submit" or higher permission level to submit information.
5. " 404 error" – Course version on the devices is different from the online version. Re-download the form again to ensure that you lot have the electric current version of the form.
   If the grade was updated and you have many records on the device, you tin upload these records to your form using ODK briefcase. Come across this guide on how to pull records from ODK binder.
6. " Gateway timeout" – Device is configured with the incorrect URL. Please confirm yous have the right URL < https://odk.ona.io >.
7. " Disk I/O error: COMMIT" – The device storage is total. Bank check the device's storage and ensure that it is not total. This means you should exist adding additional storage with an external SD card, deleting all unnecessary images/videos, and/or uninstalling applications that are not used or needed for data collection to continue data collection and submitting data.
8. " Peer certificate mistake" – The device doesn't have the right date and fourth dimension. Go to Settings -> Date & time -> and then choose Automatic date & and Automated time zone .
9. " Formlist error " – This could be caused by several factors such equally:
   • Connectivity – Ensure that you are able to connect to https://odk.ona.io/formList or any other website using your device's browser. If y'all cannot, ensure that yous can connect to the net through a computer that uses the same access point. If neither the device nor the computer can connect, effort either resetting the router of the connection or finding a different wireless access indicate.
   • Appointment and Time – This error can occur if the time and date are set incorrectly on the mobile device. Please starting time ensure that the engagement and time are fix correctly. Go to Settings -> Date & time -> and so choose Automated date & and Automatic time zone.
   • Incorrect Configured URL – This fault can exist remedied by irresolute the URL from <https://odk.ona.io> to <http://odk.ona.io>. Please note this method will break encryption and should not be done if submitting sensitive data.
10. " Indexed-echo mistake" – In full general, yous cannot use ${ fieldname } to reference any field within a repeat group. E.grand. ${ segment_name } does non work and gets an indexed-repeat error.  This is confusing because if you create a class with just one iteration of the echo group, everything is fine. The problem occurs when you add the second iteration of the repeat group. The ${segment_name} expands into a vector of values from the outset and 2d repeat. east.g.[value_from_first_repeat,  value_from_second_repeat], but all your formulas are expecting a value and not a vector. The solution is to use relative references ("../segment_name") and call back about XPath expressions.  Encounter this link for more than information.
11. " Method Not Allowed (405)" – This error appears when you submit data to a form that is inactive. Change the status of the form to Active, under the Settings selection as shown in the screenshot below and try to re-submit to Ona.

Platform Errors

1. "Data export error" – This fault pops up when trying to export information in whatever format. Written report this to our support squad to bank check on the effect once information technology occurs.
2. "502 Gateway timeout error/ 500 Internal server mistake" – The fault is usually returned when the server receives an invalid response from another server. Please try any of the beneath steps to admission the site:
   • Reload the web page. You can do that by clicking the refresh/reload button, pressing F5, or trying the URL again from the address bar.
   • Start a new browser session by closing all open browser windows and then opening a new one.
   • Clear your browser'south cache
   • Delete your browser'due south cookies
3. "Oops something went wrong" – This bulletin ways you received a 500 response error. You lot could have experienced this issue due to high traffic around the time you received this message. Delight try and reload the page, and if you are however experiencing this fault, please contact the back up team.
4. SAV information export failure – The SAV exports tin neglect because there are invalid characters on the name column of the survey or choices worksheet of the XLSForm. Kindly ostend whether the following rules have been applied:

   Delight take a expect at this guide for more than information on valid SPSS characters. Sometimes the organization could exist failing on sav exports. If there are no special characters, then one tin raise the issue with the support team.

Related Articles

smithprefor.blogspot.com

Source: https://help.ona.io/knowledge-base/guide-troubleshooting-common-error-messages/

Share this post