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:
- Find the user who is missing the email directory entry
- the direct SQL query below may help
- add an email directory entry for this user
- 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%'