| Product(s): | Exor Public Enquiry Manager (ENQ) | |
| Version(s): | 4.3.0.0 | |
| Environment: | N/A | |
| Area: | Public Enquiries | |
| Subarea: | N/A | |
Problem
PEM emails stopped sending.
Solution
There can be a number of reasons for this. Things to check are:
- Product options beginning with SMTP - check with the user's IT department that these are set correctly.
- Try a ping command to the server in SMTPSERVER product option - if the database server cannot ping the mail server that might be the problem.
- Check whether it's an alert being used, or a trigger (bespoke or otherwise) on the DOCS table. If an alert, go to the Alert Log (hig1525)to see whether there are any error messages to give a clue why they're not sending. Check that the alert process is running through the process monitor form.
- If a trigger, go to Mail Message Administration (hig1903) and check the status of recent jobs which may give a clue as to the cause of the problem. In a recent case, this was because the new mailserver had more error checking and objected to the domain of the dummy email address assigned to the Highways owner user which is seen as the sender. Changed the address from a@a.com to a@user_normal_domain and it sent OK.
- If it's a trigger, check that the dbms job is not broken. If it is broken, execute the mail sending process manually through SQL to see what errors occur, i.e. exec nm3mail.send_stored_mail;
- Once the dbms job is OK and the mail set up is OK, you can resend any errored messages by setting the nm_mail_message.nmm_status to null on the errored messages (Please contact TSG for a script if you need to do this) and then executing the nm3mail.send_stored_mail procedure as above.
See Also
Product TechNotes and FAQs
External Links
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Comments or Corrections?
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!
| Original Author: | Elisabeth Pry | |