Hello Everyone,
We have been facing an issue with the API end point to generate and reserve values as follows:
api/trackedEntityAttributes/CxSxifEaRzd/generateAndReserve?numberToReserve=2
which brings the error:
The error seems to be caused by the limit of the integer data type on the database as follows:
I was not sure if this should be a bug or a feature request but it seems to be an issue that sooner or later will be faced by anyone with a database with too much data. As highlighted in the post at https://community.dhis2.org/t/big-problem-with-sequential-number-counter-on-large-database-implementations/46891 owing to the dangers of the workaround, this could be needed sooner rather that later. Your help is desperately needed.
Cheers,