Purging Active Procedures (MACP)

Purpose: Use the Purge Active Procedures function to delete a user procedure that remains in an active status when the user is no longer in the application.

For example, if a terminal crashes when an operator is entering orders, the Active Procedures record for the user may not be deleted from the table. If a record exists in the Active Procedures table, the system thinks that the person is still using the application because the function was not exited properly.

If there are stranded Active Procedures records for any of the following functions, they must be deleted, otherwise the background ASYNC jobs cannot be ended:

• Order Entry/Maintenance

• Purchase Order Entry/Maintenance

• Receiving

• Confirmation

• PC Manifest or the Generic Pick In API (Shipments, Voids, and Backorders)

When the ASYNC jobs are ended, the system checks the Active Procedures table to see if there are any active records for these applications. A pop-up window indicates the User ID and application that is still active. You should ask that the user exit the application. If the user is not in the application, delete the record from the Active Procedures table.

Important: This function should not be used to delete Active Procedures records for users who are still using an application. If you delete Active Procedures records while a user is still in the application, the user job will not be ended; that user can still enter transactions in the application, but transaction records cannot be sent to the data queues for processing because the data queues are reorganized when the ASYNC jobs end. No back end table updates for that user's transactions will be posted, which will cause your data tables to be out of sync.

Scheduling the active procedure purge: You can schedule the active procedure purge for the functions listed above using the DLTACPR Delete Stranded Active Procedures periodic function. The system deletes all active procedures for interactive jobs that are older than the number of hours defined in the periodic function’s Parameter field. If the Parameter field is blank, the default number of hours is 24.

Interrupting confirmation email generation: You can delete the active procedure related to generation of shipment and return confirmations (Type = SC) in order to interrupt the generation process. The system keeps track of the last email generated so that you can restart the generation process at a later time. See Stopping and Restarting Shipment and Return Confirmation Emails for an overview.

To see active procedures for all users in your environment: Use the Purge Active Procedures Across Users (MACX) menu option to display active procedures for all users and to purge selected procedures as needed.

In this topic:

• Purge Active Procedures Screen (Selecting the User to Purge)

• Purge User’s Active Procedures (Deleting an Active Procedure)

For more information: See Purge Active Procedures Across Users (MACX). 

Purge Active Procedures Screen (Selecting the User to Purge)

Purpose: Use this screen to enter the User ID of the person whose record must be deleted from the Active Procedures table.

How to display this screen: Enter the Active Procedures Purge fast path name, MACP, in the Fast path field at the top of any menu.

Field	Description
User	The User ID of the person whose active procedure is being deleted. The User ID is validated against the User Profile table. Alphanumeric, 10 positions; required.

Purge User’s Active Procedures (Deleting an Active Procedure)

Purpose: This screen displays the system procedures that are currently active for the selected user.

Important: Be sure that the user has exited the application before you delete an Active Procedures record. When you a delete a record, the system no longer recognizes that the user is in the application. If the user is still active in the application, the user job will not be ended when the record is deleted.

How to display this screen: Enter a valid User ID at the Purge Active Procedures Screen (Selecting the User to Purge).

Field	Description
Workstation	The workstation ID where the active procedure was started. Alphanumeric, 10 positions; display-only.
Job #	The system job number assigned to the active procedure. Numeric, 6 positions; display-only.
Cmp	The company in which the procedure is active. Numeric, 3 positions; display-only.
Type	The type of procedure. See Active Procedure Types for a list. Display-only.
Program	The name of the program that is active. Alphanumeric, 10 positions; display-only.
Date	The date when the user started the procedure. Numeric, 6 positions; display-only.
Time	The time when the user started the procedure. Numeric, 6 positions; display-only.

Screen Option	Procedure
Delete an active procedure	Select Delete for the active procedure you want to delete.