User gets a failed job in the mail queue with error "Could not resolve the email address"


 

Product 

  
 Applies To 
  
 Product(s):Assetwise ALIM
 Version(s):16.8.xx
 Environment: N/A
 Area: eB System Management Console
 Subarea: Queue
 Original Author:Dennis Chan, Bentley Product Advantage Team

Problem Description:

User gets a failed job in the mail queue with the following error message:

  • Could not resolve the email address for all the recipients. Make sure the system default Directory Entry for Email is specified and that all subscribers have valid e-mail addresses.

Cause:

A user is missing an email address in his/her Directory Entries.

Solution:

  1. Find the user who is missing the email directory entry
  2. the direct SQL query below may help
  3. add an email directory entry for this user
  4. resubmit the failed queue job

Workaround:

select distinct p.person_code
from persons p
join mail_message_recipients mmr on mmr.object_type = 4 and mmr.object_id = p.person_id
join queue_jobs qj on qj.job_id = mmr.message_id and qj.error_text like 'could not resolve%'