1.            Summary / Overview / Purpose

 

We can use this tool to do a vast amount of internal messaging but for this informational guide we are going to go over how to cancel oLPN's that have been bridged over from Manhattan.

 

In an issue we saw previously, Manhattan sent over a 'wave' but cancelled the wave before it fully was sent over to WES. This was due to the fact that the wave was 'hung'/frozen during it's label generation stage (on Manhattan).

 

WES still thought these orders were still 'live' and was bridging these orders to packsize with blank labels.

See here for more info: TS-00388547

 

2.            Requirements

N/A

3.            Procedure / Body 

 

• SocketMsgSender.jar is located here: H:\SocketMsgSender on the DCWIJB015823 Jump box.

 

 

• Using the cmd file, double click it…

 

• When it opens type in r then hit tab and the 'runSendSocket.bat' will appear (or the user may type that in, whichever they prefer):

 

 

• Press enter and then we will need to enter the host and Port number

 

HOST: dckslb02.dc5823.homedepot.com

PORT: 7564

 

 

 

• Next we can enter the message we want to use..

 

• For the oLPN cancelling we can enter a message of this type:

 

12345678|CNCLOLPN|C0001442807

 

Where the oLPN is the C…. Number

 

• After entering in the desired message/messages, please hit enter and these will be relayed to the system.

4.            Recovery or Back out procedure

  N/A

5.            Supporting external documentation

  N/A

6.            Additional publication information

 

• For a cancel oLPN incident we may need to retrieve oLPN's from the DB if we need to create a message that will cancel all of them..

 

select count(*) as 'count' ,s.SHORT_DESCRIPTION from [order]..ORD_ORDER_HEADER h

join [order]..ORD_ORDER_STATUS s on h.STATUS = s.STATUS_ID

where WAVE_ID = '202110060018'

group by s.SHORT_DESCRIPTION

select s.SHORT_DESCRIPTION,* from [order]..ORD_ORDER_HEADER h

join [order]..ORD_ORDER_STATUS s on h.STATUS = s.STATUS_ID

where WAVE_ID = '202110060018'

 

The Query above will give us all the oLPN's in a specific wave (wave # is highlighted red)

 

Adjust the above Wave_Ids and we can find all of the oLPN's for a specific wave.

 

DISCLAIMER:

Information in this document is subject to change without notice and does not represent a commitment on the part of Intelligrated. This information is typical of the questions and general advice given; however, your particular case and circumstances may produce different results or require different recommendations. Therefore, use of this information is not a suitable replacement for contacting Intelligrated Technical Service engineering for specific recommendations and solutions to your application.

 

No part of this article may be reproduced or transmitted in any form or by any means including recording, or information storage and retrieval systems, for any purpose without the express written permission of Intelligrated. All information contained within the article is private and confidential and the sole property of Intelligrated.

 

In no event, shall Intelligrated be liable for any damages whatsoever including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss, even if Intelligrated has been advised of the possibility of such damages. Because some states do not allow the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you.