Getting "HTTP Status 400 - Bad Request" on uploading xml sheet on ODK Aggregate

Support
,
1

1. What is the issue? Please be detailed.
I'm building a form with xlsx/Excel and for a set of questions, and I have added a choices tab having the choices for the multiple choice and multiselect answer questions.
It was an existing form that is functional on ODK aggregate, but I had to make some changes and add questions to it. So I uploaded it on kobotoolbox and made the changes and was able to visualize it on Kobo. Then I downloaded the excel format of the form from Kobotoolbox.

I am able to convert the excel to xlm format using an online tool (Link mentioned in section below). But when I go to https ://getodk.org/xlsform/ and try to upload the form to visualize and check the form I'm getting " Error: 'Choices' "

When I upload the form to aggregate I get the error "HTTP Status 400 - Problem with JavaRosa Parsing Form: org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData: Javarosa failed to construct a FormDef. Is this an XForm definition?" (PFA the ss)

I have gone through the choices tab multiple times to check for any inconsistencies or syntax errors but unable to find it.

I'm building the form on google sheets, downloading in .xlsx format on windows 11, converting to xml format using an online xlsx to xml converter and trying to upload on ODK Aggregate v2.0.5.

2. What steps can we take to reproduce this issue?
Follow the steps to reproduce:

  1. Convert the .xlsx file attached below into .xml format using- https: //cloudconvert.com/xlsx-to-xls
    Elementary Mentoring Form - Sept 2023.xlsx (84.6 KB)

  2. Upload the .xml file on ODK Aggregate

3. What have you tried to fix the issue?
I have tried checking the syntax in choices tab and changing the form ID.
I also came across the solution to this, same issue that someone had raised in 2019. Topic: choice-filter-cascading-select-resulting-in-http-status-400-error-on-odk-aggregate, issue no. 23712
But for them updating their aggregate server to v2.0.5 had done the trick, but ours is already v2.0.5. And none of the links in the solution to that issue ticket work. Is there a different latest version?

4. Upload any forms or screenshots you can share publicly below.

odkerror1
odkerror11149×551 171 KB

Any help will be greatly appreciated!

2

Welcome to the ODK forum, @omkar1! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a picture as your avatar because it helps build community!

I'm sorry to hear you are having this issue. Please note that Aggregate has reached end-of-life and is no longer being updated or supported. Consider switching to Central because it's actively developed.