Error Logging

The Windows Service creates a folder in the “C:\windows\system32\logging” for logging errors. Each “part” of the service creates a file which is time stamped to the hour.

Issue 1 - Not sending

1. Is there a record in the USERS table?
   a. Is the “Active” field = 1 (true)?
   b. Is the current time (hour) greater than the SendStartHour and less than or equal to SendEndHour?
   c. Is the ProcessQueueInterval greater than 0 (field is based on seconds to poll the QUEUE table)?
   d. Is the LastProcessQueue field changing its time?
2. Is there data in the QUEUE table?
3. Check the logging folder

The sending process selects from the QUEUE table, then increases the RetryCount field in the QUEUE table by 1 to show an attempt.

On success, the item is:

1. First deleted from the SENT table (precautionary measure, 0 rows should be affected)
2. Inserted into the SENT table from the QUEUE table, with status “SUBMITTED”
3. Deleted from the QUEUE table

On failure the item is:

1. First deleted from the SENT table (precautionary measure, 0 rows should be affected)
2. Inserted into the SENT table from the QUEUE table with a status description (“NUM invalid”)
3. Deleted from the QUEUE table. If the item is attempted 3 times it will be moved by a background thread, with status “RETRY EXCEEDED”.

Issue 2 - Not receiving status updates or replies:

1. If there is a record in the USERS table?
   a. Is the GetDRInterval positive (value is minute based)?
   b. Is the GetRepliesInterval positive (value is minute based)?
   c. Are the LastProcessReplies and LastProcessDR timestamps changing?