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

Question/Problem

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

Environment

SQL Database

 

Answer/Solution

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

 N/A

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

 N/A 

 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.
   
 

 Comments...
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 274 times.
Rated out 0 of 10 based on 0 votes.
Print Article Print Article
Print Article Email Article