The wave did not load from the vision system into the easypick system because of some special characters that was in the files loaded in the vision system. To solve this issue, you will need to undo the wave.
1) You will first need to log into the Vision Cluster SQL IP RDP
2) You will need to log into the Visual studio App
3) Because of the updates you will need to perform back up the database
4) After backing up the Database perform the follow SQL.
These select statements are to make sure the items are in the Vision system.
select * from wmptsl
where exists (select * from wmptsh where tshwfc in (select whfwfc from wmpwhf
where whfwrg like '902J0007642') and tshst=tslst and tshsc#=tslsc#)
select * from wmpoii
where exists (select * from wmptsh where tshwfc in (select whfwfc from wmpwhf
where whfwrg like '902J0007642') and tshst=oiist and tshsc#=oiisc#)
select * from wmptse
where exists (select * from wmptsh where tshwfc in (select whfwfc from wmpwhf
where whfwrg like '902J0007642') and tshst=tsest and tshsc#=tsesc#)
select * from wmptsi
where exists (select * from wmptsh where tshwfc in (select whfwfc from wmpwhf
where whfwrg like '902J0007642') and tshst=tsist and tshsc#=tsisc#)
select * from wmpsew
where sewfc in (select whfwfc from wmpwhf where whfwrg like '902J0007642')
select * from wepoop
where oopopc in (select tshsr# from wmptsh where tshst='S' and tshwfc in
(select whfwfc from wmpwhf where whfwrg like '902J0007642'));
select * from wmpwhf
where whfwrg in (select whfwfc from wmpwhf where whfwrg like '902J0007642')
select * from wmpwfd
where wfdopc in (select tshsr# from wmptsh where tshst='S' and tshwfc in
(select whfwfc from wmpwhf where whfwrg like '902J0007642'));
select * from wmpwfh
where wfhopc in (select tshsr# from wmptsh where tshst='S' and tshwfc in
(select whfwfc from wmpwhf where whfwrg like '902J0007642'));
select * from wmptsh
where tshwfc in (select whfwfc from wmpwhf where whfwrg like '902J0007642')
These states are to delete the wave so the wave can be sent again.
delete from wmptsl
where exists (select * from wmptsh where tshwfc in (select whfwfc from wmpwhf
where whfwrg like '902J0007642') and tshst=tslst and tshsc#=tslsc#)
delete from wmpoii
where exists (select * from wmptsh where tshwfc in (select whfwfc from wmpwhf
where whfwrg like '902J0007642') and tshst=oiist and tshsc#=oiisc#)
delete from wmptse
where exists (select * from wmptsh where tshwfc in (select whfwfc from wmpwhf
where whfwrg like '902J0007642') and tshst=tsest and tshsc#=tsesc#)
delete from wmptsi
where exists (select * from wmptsh where tshwfc in (select whfwfc from wmpwhf
where whfwrg like '902J0007642') and tshst=tsist and tshsc#=tsisc#)
delete from wmpsew
where sewfc in (select whfwfc from wmpwhf where whfwrg like '902J0007642')
delete from wepoop
where oopopc in (select tshsr# from wmptsh where tshst='S' and tshwfc in
(select whfwfc from wmpwhf where whfwrg like '902J0007642'));
update wmpwhf set
whfsta='C' where whfwrg in (select whfwfc from wmpwhf where whfwrg like
'902J0007642')
update wmpwfd set
wfdpf= ' ' where wfdopc in (select tshsr# from wmptsh where tshst='S' and
tshwfc in (select whfwfc from wmpwhf where whfwrg like '902J0007642'));
update wmpwfh set
wfhpf= ' ' where wfhopc in (select tshsr# from wmptsh where tshst='S' and
tshwfc in (select whfwfc from wmpwhf where whfwrg like '902J0007642'));
delete from wmptsh
where tshwfc in (select whfwfc from wmpwhf where whfwrg like '902J0007642')
Note: Please make sure to perform the delete statements one at a time