Enterworks - ETT 115 - How to Reset the Auto-Sequence for a Repository After Data Reload

If a repository includes an auto-sequenced attribute and its data is reloaded with values for that attribute, the sequence must be reset to ensure subsequent records do not collide with the pre-loaded records. If the auto-sequenced attribute is the primary key, a collision will fail to create each record due to a duplicate record error. The sequence can be manually reset through the UI by identifying the next available sequence, then editing the Sequence assigned to the Repository and entering the new value. The update of the sequence can be automated by using the stored procedure ResetRepositorySequence. This stored procedure identifies the auto-sequenced attribute for the designated repository and finds the highest value, then sets the sequence to the next value. This session covers how to reset the sequence for a repository.

Prerequisites - EBA 208