When i try to submit my form: integer out of range; nested exception is org.postgresql.util.PSQLException

Support
,
1

I have written a xlsx form which is a bit too long and complicated. actually 844 rows of excel, many calculations and concat. there are many multiple choice questions and much of them are filter through calculations from previous questions. if i try to select every choice that someone possibly can(which is not a realistic case), when i try to submit it says: The data server for your form or the Enketo server is down. Please try again later or contact info@kobotoolbox.org.
i contacted the IT support and he saw the system logs when i try to submit it and says: ERROR: integer out of range; nested exception is org.postgresql.util.PSQLException: ERROR: integer out of range
If you need more information realted to this case please ask and i will provide it to you.
what could possibly cause this. is it the form? if you want i can submit the xlsx form for any one here to take a look at it.

2

Sounds like you are using Kobotoolbox? Your best bet is to contact the Kobo team.

3

please dont mind "info@kobotoolbox.org." the company i work for uses odk aggregate. when i tested the form in another odk aggregate we use it says contact admin@hydra.al
hydra is the company name.

4

its just an old name that the old "IT supports" had written in the error messages many years ago. i dont even know what kobotoolbox is

5

I see, you are using Aggregate connected to Enketo and you're using an older Enketo install that defaults to the Kobo settings.

Aggregate has reached end-of-life and is no longer being updated or supported. Consider switching to Central because it's actively developed and has built-in support for Enketo.

6

Yes our IT is working on switching from aggregate to central. but right now we are facing a problem that we can't find solution. i can provide you with the xlsx if you want. we don't know how the the form produces such a large integer to cause this error: ERROR: integer out of range; nested exception is org.postgresql.util.PSQLException: ERROR: integer out of range.
okay the form is a bit too long and too mny calculations and concats. but this has never happend before.