Article: KB-11441
How to:
Reseeding the Identity Value for the MessagesContainerStatus Table
Skill required to complete this article: Controls and level is Novice.


 How to fix no diverts on all Shoe Sorters at a ICW customer site


SQL Database



Reference Incident: TS-00411380, specifically an Amazon site example

If site calls in with nothing diverting in the sorter, no D99 lane status being captured, successful barcode scan by the scanner but no S01 messages reported, and the trace files show the following error:

To confirm this is the issue, please run the following in a new query on the project DB: 

Select ident_current('MessagesContainerStatus')

If the above query returns a value over two billion then it is safe to run the DBCC command described and shown below:

Reseeding the UID value for the MessageContainerStatus table in the DB to 0 using the following query and again make sure you have the project DB selected as shown in the screenshot above:

DBCC CHECKIDENT(MessagesContainerStatus, reseed, 0)

Related items


Internal Notes


[Section is meant for information only available for internal use. This includes references to internal records, such as Jira tickets, bug numbers, etc.]

***If there is information in this section prior to migration to SalesForce, then it may NOT be published. This information will be fully visible along with all information above.***


Reason for confidentiality


 Related Articles
No Related Articles Available.
 Help us improve this article...
What did you think of this article?
poor   excellent
Your Email:
Tell us why you rated the content this way. (optional)
RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
RadEditor's components - toolbar, content area, modes and modules
Toolbar's wrapper 
Content area wrapper
RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
Editor Mode buttonsStatistics moduleEditor resizer
RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.

No user comments available for this article.
Published on 12/3/2022.
Last Modified on 12/3/2022.
Last Modified by Vincent Haenni.
Article has been viewed 328 times.
Rated out 0 of 10 based on 0 votes.
Print Article Print Article
Print Article Email Article