Wednesday, March 28, 2012

SP2010 Upgrade Incoming Email does not work

Scenario:
Configured Incoming email on new SP2010 farm as per technet. Database attach upgraded a SP2007 site collection. The host name has not changed in SP2010 but the incoming email server address changed.
Incoming emails are seen in the drop folder but do not get processed. ULS reports "missing alias" errors for the aliases which were working in SP2007.


Solution:
For the library where the incoming email feature is not working, navigate to list settings -> incoming email settings, disable incoming email and enable with same email address


To identify impact on environment using below SQL query against content database,



SELECT Webs.FullUrl, AllLists.tp_Title, AllLists.tp_EmailAlias
FROM AllLists
Inner join webs on AllLists.tp_WebID = Webs.Id
where AllLists.tp_EmailAlias is not null

No comments:

Post a Comment