PermID suffix reset

General
1

Hello,

As I can tell, the permid is generated from the current date and a consecutive number as a suffix. After just one year of using Openbis, we are already at a count of 9000. Is there a possibility to reset this count? Will it reset by itself? The definiteness could be guaranteed when the change happens during a server shutdown.

Thank you, Cedric

2

Hello, Cedric

I think what you can do is to run the following SQL on the openbis_prod database.
ALTER SEQUENCE perm_id_seq RESTART WITH 1
This should reset the counter for PermIDs.

Viktor