Applies To
	Product(s):	Exor Network Manager
	Version(s):	04.05.00.00
	Environment:	N/A
	Area:	Other
	Subarea:	N/A
	Original Author:	Bentley Technical Support Group

 

Error or Warning Message

When attempting to send a mail, you receive the following error: ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line ...

 

Any application action that uses alert manager to send an email will cause this issue. For example in PEM if there is an alert setup which sends an email when the responsibility of a PEM is changed.

How to Avoid

Please check all of the items below:

1. Product options beginning with SMTP - check with the IT department that these are set correctly.

 

2. Try a ping command to the server in SMTPSERVER product option - if the database server cannot ping the mail server that might be the issue.

3. Have you configured your Access Control List (ACL)? You can check this by running scripts below. First script selects all ACL created on your DB and second brings up a list of users and privileges assigned to ACL.

 SELECT host, lower_port, upper_port, acl FROM   dba_network_acls order by acl;

SELECT acl,  principal,   privilege,   is_grant,  TO_CHAR(start_date, 'DD-MON-YYYY') AS start_date,  TO_CHAR(end_date, 'DD-MON-YYYY') AS end_date
FROM   dba_network_acl_privileges;

 If you didn't set ACL, you can do it with the code below. (please before running it replace 'USER' with Highways owner user and provide value for 'host')

 BEGIN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
  acl => 'UTL_SMTP.xml',
 description => 'Granting privs to required users for UTL_SMTP.xml',
  principal => 'USER',
  is_grant => TRUE,
  privilege => 'connect');

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
   acl => 'UTL_SMTP.xml',
  host => ' ');

END;

Without an ACL, you will also receive the following error: “ORA-24247: network access denied by access control list (ACL)“.

In addition to the above, another possible root cause is that 'Alert Manager' has not been submitted as a process.  Ensure this process appears in the list of process within the Process Monitor form.