A couple of days ago I was setting up the email router for a customer running CRM Online. I must say that I really look forward to the day when Microsoft retire this very strange product that in no way fits the cloud story of CRM Online and Office 365. On what server is it to be deployed?
However, this customer is running CRM Online (at the time of this article, Polaris) and Exchange 2007 On-premise. They had been trying to get the email router to work for several days and had been advised by Microsoft Support to use the WebDAV protocol to connect to the Exchange server. This has worked fine at the beginning but after a while, one of the two queues stopped receiving emails for no apparent reason.
After a lot of trying and look at logs, I removed all settings and recreated everything based on the Exchange protocol from WebDAV to Exchange Webservices, which after some finetuning of the URL:s actually started to work. During this time I discussed this issue with some of my MVP friends, especially Joel Lindstrom, David Jennaway and Donna Edwards who were very helpful and they pointed me in the right direction of what was probably the root cause of the error, not that I have actually have had it confirmed but it seems very plausible.
What seems to be the error, that they mentioned, is that some of the emails contain some “special” characters which caused the WebDAV to crash for one of the two queues, while the other one did not contain any emails with any “special” characters. When I changed to the Exchange webservices protocol, which does not have this bug, the mail got imported to CRM as it should.
This is a very tricky error as it is very hard to find and also rather hard to confirm. I still do not not if this is a fact, it is just a hunch, but it fits the symptoms.
My general recommendation based on this is hence the following:
1. Do not use WebDAV when connecting the CRM Email router to Exchange. It is buggy and does not support special characters, some searching the net show these to be characters like !#$%^&. It might work at first but after a while, you might receive an email that contains a special character and it will break down without saying why.
2. Microsoft Support are very good to have when things to not work but do not put your life completely in their hands, sometimes you need to trust your own judgment and try stuff yourself.
3. Isolate errors as far as you can. It helps when trying to find the root cause.
4. Listen to your friends, they are the best!
And let’s all together ask Microsoft to can the email router and build it into the CRM application, especially CRM Online.
MVP, CEO and owner at CRM-konsulterna AB