Problem
Is there a way to confirm that my emails are being sent from RecTrac 3.1?
Solution
Not exactly, becasue RecTrac doesn't send the email. RecTrac queues emails to your email server, and they are then sent from there. Your email server should be able to provide a report of which emails were sent and which were returned. However, we here are two (2) good methods to test whether the emails were queued from RecTrac to your email server.
- Use DB Inquiry to check the 'recordstatus' of your emails. This will tell you whether an email was sent from RecTrac to your Email Server or whether the 'send' process to your Email Server failed.
- View the socketmail.log file on your RecTrac server. If there are any problems connecting to your email server then they will be listed within this log file.
Solution 1: Using DB Inquiry to check the 'recordstatus' of emails.
- Search for and go to the DB Inquiry program. In the standard RecTrac VSI Design, this is Management Ribbon System Management Misc Management Group DB Inquiry.
- In the Select Table to View field, enter 'SAEmailQ.'
-
In the Query field, enter a string that includes 'datesent' If you are searching for emails from a particular user, then be sure to include 'username' in the query as well. Click View when ready.
- If you are looking for the status of emails sent 'today,' then you query would look like this: datesent = 'today'
- If you are looking to for the status of emails sent on a certain date (for example: 07/01/2017) by a certain user (for example: Admin), then your query would look like this: datesent ='07/01/2017' and username = 'Admin'
-
The DataGrid will display the records that match your query. Refer to the RecordStatus column.
- Record Status 'Sent' means the email left RecTrac and was sent to your email server. Whether delivery was has to be ascertained from your email server.
- Record Status 'Failed' means the email never left RecTrac, which means it did not get sent. There are a number of reasons for a 'Failed' status, such as your Event AppServer not running, a SMTP User/Password mismatch, etc. Contact VSI Support. One of our professionals will be happy to troubleshoot this with you.
- Exit back to the main menu when done.
Solution 2: View the socketmail.log
- On your RecTrac Server, navigate to:
\VSI3\Progress\DLC11_wrk\vsi\rectrac - Open your most recent socketemail_MM-DD-YYYY.log file.
- Look for any connection errors within this log file.