Everest Pull Sheet Processing Delays and Failures Due to Performance Issues

Issue Description:

Users experience extended delays, up to two hours, when running the pull sheet process in Everest. In many cases, the process fails to complete, requiring users to restart the pull sheet operation from the beginning.

Common Symptoms:

• Pull sheet process takes significantly longer than expected (up to 2 hours).
• Pull sheet process fails to complete without specific error messages.
• System freezes or crashes during pull sheet generation.

Root Cause

Several factors could contribute to these performance issues, including:

1. Inefficient queries within the Everest system database.
2. Lack of necessary indexes on critical tables.
3. System resource limitations (CPU, memory, or disk usage).
4. Network latency or connectivity issues.
5. Application-level customizations or misconfigurations.

Resolution:

1. Adding an Index to the Pick Ticket Details Table:

To improve the speed of running pull sheets, adding an index to the X_PICK_TICKET table is a recommended solution. Follow these steps:

• Open SQL Server Management Studio on the server system.
• In the Object Explorer window, navigate to your company database.
• Right-click on the database name and select "New Query."
• Execute the following query:

For detailed instructions, please refer to this article Everest freezing and restarts printing Pick Tickets and Pull Sheets from the beginning

2. Changing Printing Preferences:

If the system freezes while printing large numbers of Pick Tickets or Pull Sheets, printing them to PDF first can help avoid crashes. Follow these steps:

• Navigate to Inventory > Pull Sheets.
• Open the Pull Sheet containing the Pick Tickets to be printed.
• Go to Options > Print Pick Tickets.
• In the Printing Preferences dialog, select "Microsoft Print to PDF" or "Export to PDF."
• If using the Pull Sheet Wizard, change the printer driver name to "Microsoft Print to PDF" in the Print dialog.

For more information on this process, please visit this Processing an Increased Number of Documents Resulting in Pull Sheets not Coming off the Report.

Contact Support

If none of the above steps resolve the issue, please contact the Everest Support Team for further assistance. You can submit a ticket via the Support Portal or email us at support@everest.com.