Question/Problem

 

How to complete a Batch/Batches for Michaels using the Batch Completion script

 

Environment

 

EZ Pick

 

Answer/Solution

1. Navigate to the support/home directory.

2. Go to cferguson/ directory.

3. Run the Batch_Checker script to view the current batch statuses:

4. Locate the Batch_Completion.csh script

5. Run the script with batch or batches as the trailing arguments:

6. The script will first check if the Batches exist:

If not the program will exit:

 7. After verifying the batches, the script will create a database backup up by running check_status:

8. Next the script will check for the current statuses of the batches passed.

9. The script will complete the batches sent:

10. The script validated the batches are in completed status. 

11.The script will launch the MSGTOOL to send the batch complete messages:

12.Type sn to send messages:

13. The Complete queue number and the batch complete number are displayed when the msgtool launches:

14. Enter the batch complete details as shown separately for each batch: 

Once all the messages have been sent type q to exit. 

15. Lastly the script will check if the batch beginning with the upload code '6' (batch) was recorded in the upload file:

If the batch message was not generated you will receive a message instructing you to launch the msgtool and try again:

16. Record the script output in the Dashboard ticket. 

Files:

batch_eporder.sql: Created and overwritten each time by Batch_checker.csh  - This is the eporder query that is used to show the batch statuses. 

complete_batch.sql: Created and overwritten each time by Batch_Completion.csh - This is the Database queries to complete the batches.

pre_check_sql: Created and overwritten each time by Batch_Completion.csh - This is the eporder query that is used to show the batch statuses.

batch_check_query.sql: Created and overwritten each time by Batch_Completion.csh - This is query that is used to get the unique batch numbers for database validation. 

 

Related items

 

 TS-00459494 - https://dashboard.intelligrated.com/dashboard/EditIncident.aspx?IncidentID=35481df7-37b9-4af5-a701-baadb3019c98&saleslead=638864885576644721#

 

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