Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | All TechTalks
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?
You can check this for troubleshooting: www.powerobjects.com/.../
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
JOIN QueueBase QB ON Apa.PartyId = QB.QueueId
GROUP BY APa.PartyId, QB.Name, QB.EmailAddress
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.
Business Applications communities