Show "Duplicate Key Error" when manual create SO and import SO by template - After clear Redis cache
Affected Environment:
PROD
Affected warehouse:
R-MYY,R-SBW,R-SHM,WH-HQ....
Screenshots of error messages:
Time when issue occurred:
17/1/2022 around 5PM
Affected module:
Shipment Orders
Detailed description of issue:
When WMS users create SO manual and import SO template into WMS to create NEW ORDERS, "DUPLICATE KEY ERROR" pop up
First level investigation/troubleshooting taken:
Nothing setting changed at that movement.
Affected a few warehouses
Answer:
Regarding the issues happened to GDEX, due to running number duplicated which mainly because of Redis. The solution is changing the ID Sequence Rule format.
You can perform what user was performing to get the same error and see what is shown in debug log (Here will show what is ID sequence rule):
Then go to ID Sequence Rule format on the affected ID sequence:
- Allocation (TASKID)
- Shipment Order Closed (TRANSACTIONID)
- Shipment Order Creation (ORDERNO)
TASKID, & TRANSACTIONID can change prefix or length
ORDERNO can change length only (because I wants them to able to see date and started with SO
| Files | ||
|---|---|---|
|
|
DataImage55.png
30 KB
|
|
|
|
DataImage98.png
133 KB
|
|
|
|
DataImage60.png
212 KB
|
|
|
|
DataImage76.png
128 KB
|