Question/Problem

 

How to reprocess a Main wave for Walmart ASAP system using the Mainwave Reprocessor script.

 

Environment

 

ASAP

 

Answer/Solution

1. Navigate to the support/cferguson/Mainwaverepro directory.

 2. To find the Main wave id to reprocess use the MainwaveVerifier.csh tool.

To run the MainwaveVerifier.csh tool pass in the wave number (001 or 002) and a date range as the trailing arguments as shown below:

The date range looks for files sent to the save dir after 11:00 pm from the first date and before 5:00 am the following day from the last date.

3. Once found, use the wave Id as the trailing argument in the mainwavereprocessor script shown below:

Note: Switched to the support server instead of Prod server.

4. The program will check to see if the wave is in ready status (status 59). If not it will display the message below and the program will exit.

5. The program will make a directory (Year,Month,Day,Timestamp) in the sql/dbsave directory and create a database unload. If the the directory is not properly defined and a unload cannot be created, it will display a message and the program will exit. 

6.The program will verify that each file exists and proceed with reprocessing the files.

if the files does not exist or is not a file the program will display the below message:

7.The S file will be moved back to the Data dir as an .rts file. After 10 secs the D file contents will be counted to display the total picks for the wave then will be to the Data dir as an .rts file.

8. After 10 secs the C file will be moved back to the Data.dir as .rts file and the main wave reprocessed message will display.

9.Lastly the orderl and wave table will be checked for accuracy.

Files:

orderl_sql_query - Created and overwritten each time the program runs - Is the query that is created to show verify the wave in the database and its pick count.

wave_check_query - Created and overwritten each time the program runs - Is the query the is used to check the wave status in the wave table.

 

Related items

 

[This section is for attachments and/or links to other items. Attached documents shall be up-to-date, correct and using Honeywell standard templates.]

 

Internal Notes

 

[Section is meant for information only available for internal use. This includes references to internal records, such as Jira tickets, bug numbers, etc.]

***If there is information in this section prior to migration to SalesForce, then it may NOT be published. This information will be fully visible along with all information above.***

 

Reason for confidentiality

 

#NotValidated

[Section is meant for a brief reason for any data recorded in Internal Notes above, or any reason that the general article cannot be released to the public. Can be updated to (hashtag)Validated once reused and agreed by KCS Contributor]

***If there is information in this section prior to migration to SalesForce, then it may NOT be published. This information will be fully visible along with all information above.***

 

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.

 

Template updated 2024-11-27 kwk