Advanced Retail (UK) Ltd
Company Wiki

Having logged onto the server via RDP (TV is flakey) and fired up the printer queue, I retried the prints and they all cleared.

IP = 192.168.20.230, usr = pets.com\ARTSoftware. /w in customer logons v2

I also confirmed that the Print Utility is running the intray and that there are no outstanding errors. [traxs_Engineer_LabelPrinting_QueueTop30]

SELECT TOP 100 * FROM vw_LabelPrinter_Queue Q WHERE printer_name LIKE '%PRN00-20.53%' ORDER BY Q.row_id DESC https://docs.google.com/document/d/1ZLE3AgHZ80XkAS3u9gMBAPbrRA6iA8VWWSPS1QoNgoI/edit

The systray app runs from the desktop of the “NDSHCPCTRAXS01” server at Handcross.

The server must be logged on under the ARTSoftware account to run. It currently needs starting manually after a server reboot.

Support Notes
 
Check (in order):

Switch printer on and off again

Are there any prints backed up in the Printer Spooler queue - if so retry or clear

Check that the LabelPrinting systray app is running

Use sproc [traxs_Engineer_LabelPrinting_QueueTop30] to view any labels that have failed to print
  
Use sproc [traxs_Engineer_LabelPrinting_Retry] @row_id = ? to reset the print queue status and get the label to print again

Is the printer showing as online - use PortScanning app on desktop

On the app itself (on the tablet) check that a printer is selected - see the “About” dialog

ALSO:

To view the last 10 prints from PRN001 do:

SELECT TOP 10 * FROM vw_LabelPrinter_Queue Q 
WHERE printer_name LIKE '%PRN001%'
ORDER BY Q.row_id DESC

Using the saved_id from the above query you can look at the actual printer commands:

SELECT * FROM label_print_saved_hdr WHERE row_id = ?
  
SELECT TOP 121 hdr_id, customer, DATEADD(DAY, 1, packed_date_time), packed_user_no, packed_users_id 
FROM vw_SalesOrder_Hdr where packed_date_time > '2020-05-29'

Example ticket https://advancedretail.freshdesk.com/a/tickets/156680