Problems with the creation of Accession Number Sequences
Question
We added a large number of Accession Numbers Sequences and saved them, but the Sequences have been replaced by the value -1 after some time. Why?
Answer
When you're creating an Accession Number Sequence, this sequence needs to be saved in a specific table in the database to enable the process behind:
Every time you're assigning a new Accession Number, the system needs to check the last assigned number and create a new sequence, based on the configuration details like library, location, method, and prefix.
Creating a large number of accession number sequences one after the other might cause the above problem: the sequence has not been saved correctly in the database, but the "error" value -1 has been added to identify the problem.
To resolve this issue, the sequence needs to be removed and recreated.
- Article last edited: 21-Jan-2021