1b.app
Link copied -

Lost ID numbers in contacts

Here https://univer.1b.app/app/contact/
https://take.ms/xfOUm ID jumped up a lot. There are not so many remote contacts that the ID person would jump like that.
Why did this happen and is it possible to correct and continue the list?
Original question is available on version: ru

Answers:


Tretyak Artur
OneBox Insiders wrote:
Here https://univer.1b.app/app/contact/
https://take.ms/xfOUm ID jumped up a lot. There are not so many remote contacts that the ID person would jump like that.
Why did this happen and is it possible to correct and continue the list?

Esteem about an autoincrement in tables and that happens at rollback of transaction with it.
06.01.2023, 22:50
Original comment available on version: ru


bu
OneBox production wrote:

Tretyak Artur
OneBox Insiders wrote:
Here https://univer.1b.app/app/contact/
https://take.ms/xfOUm ID jumped up a lot. There are not so many remote contacts that the ID person would jump like that.
Why did this happen and is it possible to correct and continue the list?

Esteem about an autoincrement in tables and that happens at rollback of transaction with it.

Nice, I appreciate it. It turns out the database tables are shakalim?)))))
Well, as I understand it, everything is ok and there are no troubles. Thank you.
10.01.2023, 14:40
Original comment available on version: ru


Tretyak Artur
OneBox Insiders wrote:
jackalim

I don't know what you put into this word))
in short, you create contacts and then, due to some kind of error, you roll back the created contacts. This may be due to automating a contact or when creating an order, when a client was created, but when switching to the status, some action threw an error and the contact was rolled back. If the jumps are not frequent and not for long periods, you don’t have to worry, there are enough IDs for everyone. If a couple of lyams at a time and often, it’s worth looking for who and where rolls back the creation of a contact, otherwise the IDs will end and you will need to do something about it.
10.01.2023, 15:01
Original comment available on version: ru


bu
OneBox production wrote:

Tretyak Artur
OneBox Insiders wrote:
jackalim

I don't know what you put into this word))
in short, you create contacts and then, due to some kind of error, you roll back the created contacts. This may be due to automating a contact or when creating an order, when a client was created, but when switching to the status, some action threw an error and the contact was rolled back. If the jumps are not frequent and not for long periods, you don’t have to worry, there are enough IDs for everyone. If a couple of lyams at a time and often, it’s worth looking for who and where rolls back the creation of a contact, otherwise the IDs will end and you will need to do something about it.

It means that the bd is jacking)))
Thank you, we will look at what stage it jumps, because the 5th million has already gone)
10.01.2023, 20:16
Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment