How to check TDF tracking

This is used to check if we have received tracking data files for Royal Mail. Often raised by specific customers like Temu, Narvar, Success Winner Trading

1. Check the status of the tracking number.
   1. If it is not manifested then it will not have produced a pre-advice file
   2. If it is a ghost shipment, check the tracking range is available against the customer account
   3. If it has been manifested then check a pre-advice file has been generated 
2. Log into the App server 10.251.7.4 and open file explorer. 
3. Go to the location: D:\INTERSOFT\Services\TrackingHarvester\data\Error\rmg 
4. Check and see if there are any recent errored files
5. If there are recent errored files, open SQL, connect to SQL01 and run the following query:
   1. SELECT TOP 100 * 
      FROM NLog 
      WHERE Level = 'Error'
      ORDER BY 1 DESC
6. The exception column will tell you specifically what is wrong but if it does not say enough please raise to Baldip
7. If needs be you can reprocess the failed file by placing it back into the directory: D:\INTERSOFT\Services\TrackingHarvester\data\in\rmg