Article: KB-11654
How to:
Wave did not load from Vision system into EasyPick to be loaded into the Putwall system.
Skill required to complete this article: Software ~ WCS and level is Novice.

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 

 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 4/17/2023.
Last Modified on 4/17/2023.
Last Modified by Jimi Gbadamosi.
Article has been viewed 136 times.
Rated out 0 of 10 based on 0 votes.
Print Article Print Article