I use SEQUENTIAL with 4digits for attribute value.
we use a while, it is working fine from android device. but now we got “There are no more reserved values. Contact your system administrator.” highlight around attribute value that use SEQUENTIAL. when i re-check the the value seem not yet use all number yet.
as technical, what should we do?
Generally speaking, gaps in sequential values are possible; some android devices can reserve values, but not use them, but the sequential value counter in the database is increased. Is this issue happening consistently, or do you see it in offline mode, like in the Jira ticket Gassim shared above? If the issue is consistent and blocking all TEI syncs, one solution could be to increase the capacity of your SEQUENTIAL value attribute, for example, go from 4 digits to 5. Would that be possible in your case?
the android app reserves 100 values per by default in the initial synchronization. These values are stored in the device and removed once they are used. From the server perspective, these values are reserved and cannot be assigned to any TEI, it does not matter if they are used or not. So, if the device does not use them, there will be gaps in the sequence.
As Gintare said, you can increase the the capacity of the sequence if the synchronization is blocked.
The reason to reserve 100 values is to minimize the risk of running out of values when offline, but this parameter can be customized. If you are sure that the uses won’t consume so many offline values (there are not so many registrations when the device is offline), you can decrease the number of reserved values. When the device is online, it will automatically refill them.
You can modify this value in two places:
Per device: in the left-side menu, go to Settings → Reserved Values and change the default value. This must be changed on every device.
Per server: you can change the default value for all the devices by using the Android Settings app → General → Reserved values downloaded per TEI attribute.
I am not sure about your implementation but a SEQUENTIAL of 4 digits means 10000 values (from 0 to 9999) and this can be very low in most of the implementations. As per what was explained by @vgarciabnz (and linked in the docs) if you would have 100 devices this means that after the initial synchronization of your devices you would have exhausted all the values!
Over a year later and this one saved my bacon, thanks @jaime.bosque
At a training and we ran out of record IDs and I discovered the system was configured to assign a max of 999 IDs per record per facility per day. With 15 mobile devices each reserving 100 IDs, we had none available for data entry. I added a fourth digit to the number which resolved the issue.