Duplication on transactionid primary key

Creation date: 05/03/2022 21:38    Updated: 05/03/2022 21:38   #duplicatekey #primarykey
Question:

Company: CJ Express

Contact:Sarut Pornthawatchainan

Email:Sarut.po@cjexpress.co.th


Priority :P3

Impact   PND Putaway show error all trace , user Can't continue working pnd putaway now

Environment : WMP PRODUCTION (Warehouse D001)



Problem Information

                Now PND Putaway show error this error check pls

Problem Information


                can't update data from pick to light,in wave SW2203050029,SW2203050030




Answer:

Investigation:

The Sequence rule key for SP_TRANSACTIONID has max out. Suggested to customer to prefix YYMMDD

Files