Close Window

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.
 Article Info
 Article ID:  KB-11441
 Published on  12/3/2022
 Last Modified on  12/3/2022
 Last Modified by  Vincent Haenni
 Original URL:  https://dashboard.intelligrated.com//Knowledgebase/Article.aspx?article=cdbc7a28-ef41-43cb-bc27-f55bc4608ed3
Close Window