Wednesday, August 28, 2013

Fix Incoming Emails Not Working Issue in SharePoint Migration

Problem:
After a Database attach method of SharePoint migration from SharePoint 2007 to SharePoint 2010, all incoming E-mail enabled libraries stopped working! They no longer receive E-mails!!  Here is the root cause and fix for SharePoint incoming email stopped working issue.

Root Cause:
This is because, SharePoint stores incoming E-mail configurations on its Farm Configuration Database (usually SharePoint_Config) and during database attachment method of migration, We didn't (and we can't) migrate the configuration database. So, incoming email settings on SharePoint 2010 not working.

Solution:
One quick solution is simply Flip the value of  "Allow this list to receive e-mail?"

  1. Just go to List Settings
  2. Under Communication, click on "Incoming e-mail settings" link
  3. Select "Allow this list to receive e-mail?" to "No" and click on "Save"
  4. Now, go back to the Incoming e-mail settings again and choose ""Allow this list to receive e-mail?" to "Yes" and then save your changes.
    sharepoint document library incoming email not working
 We can also automate the above activities with PowerShell.

Wait, There is an elegant solution yet:
However there is an another efficient way by: Calling RefreshEmailEnabledObjects() method of SPSite object to refresh all Incoming Email settings! (or use: stsadm -o refreshdms command). Here is the PowerShell script:
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
 
#Get All Site Collections of the given web application
$SiteCollections = Get-SPWebApplication "http://sharepoint.crescent.com" | Get-SPSite -Limit All 
 
 #Iterate through Each site collection
 foreach ($site in $SiteCollections)
 {
  #Refresh Incoming Email settings
  $site.RefreshEmailEnabledObjects()
  #Write Ouput message
  Write-Host "Processed: $($site.rootweb.url)"
  #Dispose the Site object
    $site.Dispose() 
    }
Make sure you enabled incoming email settings in SharePoint central admin, before running this script



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

2 comments :

  1. Been searching for a solution to this problem for 2 days now.... thanks!

    ReplyDelete
  2. Very Helpful, 15,000 webs, 790 Site Collections all refreshed within an hour after upgrading from 2010 to 2013.

    ReplyDelete

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...