You’re offline. This is a read only version of the page.
10
Hi everyone,
We are having a MS CRM 2015 on premise version. We are facing a random problem that some of the emails are getting failed.
The system tries to send the email for a "no of attempts = 10+" and then the email gets into "Failed" state.
Can anyone help me find out why this is happening?
Hello Allen,
I'm assuming you are using email router, in case not, please clarify.
Try to verify how many emails are pending to send
SQL for users
SELECT APa.PartyId AS Sender, Sb.FullName, Sb.DomainName, COUNT(*) AS #_Pending_Emails
FROM ActivityPointerBase APo, ActivityPartyBase APa (NOLOCK)
JOIN SystemUserBase SB ON Apa.PartyId = SB.SystemUserId
WHERE APo.StatusCode = '6' AND
APa.ParticipationTypeMask = '1' AND
APo.ActivityId = APa.ActivityId
GROUP BY APa.PartyId, Sb.FullName, Sb.DomainName
Order BY #_Pending_Emails desc
===============
SQL for Queues:
SELECT APa.PartyId AS Sender, QB.Name, QB.EmailAddress, COUNT(*) AS #_Pending_Emails
FROM ActivityPointerBase APo, ActivityPartyBase APa (NOLOCK)
JOIN QueueBase QB ON Apa.PartyId = QB.QueueId
WHERE APo.StatusCode = '6' AND
APa.ParticipationTypeMask = '1' AND
APo.ActivityId = APa.ActivityId
GROUP BY APa.PartyId, QB.Name, QB.EmailAddress
Order BY #_Pending_Emails desc
If you are having more than 100, probably you are having performance issue and you need to increase Email router capacity
Try the following suggestions
Check/adjust parameters on the config file Microsoft.Crm.Tools.EmailAgent.xml:
â—‹ MaxThreadExecution = 1200000 (20 minutes) or 1800000 (30 minutes)
â—‹ BatchSize = number of emails message collected per cycle (by default are 5, increase 50 or higher)
â—‹ RequestBatchSize = number of users/queues collected per cycle (try to increase)
Try to clean all emails with pending send status, some times you need to disable all of them and enable one by one to provide piority for one mailbox.
I hope this helps you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (