Ever since they were introduced, it seems that developers new to Exchange programming have misunderstood named properties. This can go unnoticed for a long time, but there are a couple of specific common issues that can block mailbox migrations (particularly from on-premises environments to Office 365).
The two issues are these:
- The developer uses a single name for the named property (more specifically, the first ten characters are the same), but a different Guid each time they create the property on an item.
- The developer uses a single Guid to identify their named properties (which in itself is recommended), but creates too many properties under this Guid (the hard limit that will prevent migration is 2000, but I would suggest that any application that is creating more than ten properties should seriously reconsider the architecture e.g. just use a single property to store all your application data in a blob).
Note that there are other ways to create too many named properties that may not match the patterns described above, but the scripts described here are likely to be of limited (if any) help in those cases.
The problem is that named properties have their own table (so that they can be searched easily). Too many named properties can exhaust this table, as the table contains all named properties that have been defined in that mailbox.
Ever since named properties were introduced, we’ve intermittently had issues of the named property table being exhausted (due to misbehaving applications), and have published the following advice to clean the mailbox:
- List all the named properties in the mailbox (using a tool such as MFCMapi).
- Go through the mailbox (manually) deleting the items or properties from the items until the named property count is within reasonable limits (usually this involves deleting all named properties that were created by a particular application).
- Purge retention (as otherwise the deleted items, with the offending properties, will still be in the mailbox).
- Move the mailbox to another database using the -DoNotPreserveMailboxSignature parameter (this moves the mailbox but does not copy the named property table, which is instead rebuilt).
The process above works, but it can be incredibly time consuming to do the first two steps.
Automatically repairing the mailbox
We’ve had several cases recently where customers have been in the process of migrating to Office 365 and the named properties issue has blocked them. Given that there have been many mailboxes affected, and hundreds of named properties per mailbox, the manual process to clear the properties was simply not feasible. It is finally time for the process to be automated.
It is the first two steps that are the tricky ones, but so long as you know the name or Guid of the named properties that need to be deleted, then the process to remove them can be scripted.
I wrote two scripts to do this. The first script is run against the mailbox (or mailbox database, or whole organisation if you like) and it will search for the offending named properties and create a list of items that contain them (including which properties are on those items). The second script runs against the mailbox to remove the named properties (no need to delete the items anymore, the script targets the properties specifically and leaves the rest of the item alone).
Example repair of a single mailbox
To repair a single mailbox, the process is as follows:
- Download and install the EWS Managed API on the machine being used to run the scripts (which don’t need to be run on Exchange, any client machine with PowerShell available will do). The current version of the EWS API is available from Github: //github.com/officedev/ews-managed-api
- From your Exchange server (this is assuming that the mailbox you are repairing is on-premises – you can’t do this step for an EXO mailbox), copy the ManagedStoreDiagnosticFunctions.ps1 script into your scripts folder (which should also contain Check-NamedProps.ps1 and Delete-ByEntryId.ps1). I’ll assume that all scripts are found in the folder c:\scripts.
- Create a folder for storing the log files of Check-NamedProps (the script dumps the named properties found, and the EntryIds of objects containing them). In my examples, I am using the folder c:\MbxPropsDump for this.
- Load Check-NamedProps.ps1 to make the Check-NamedProps function available (the script needs to be dot dot loaded).
- Call Check-NamedProps against the mailbox you want to fix (note that this can take a long time to run). Depending upon the properties you are searching for, you may need to use some of the other parameters available. The script supports wild card name searches, so if you want to find all named properties that start with “badproperty”, you can search for “badproperty*”.
- Check the output folder to see the filename for the list of EntryIds that the above creates (the script uses the mailbox Guid for the dump files, and each EntryId file will have the SMTP address of the mailbox as the first line). The next step is to use Delete-ByEntryId.ps1 to delete the EntryIds (this can also take a long time):
- After the properties have been deleted, they will still be in the named properties table of the mailbox, so the final step is to move the mailbox to another database without preserving that table (which means it is rebuilt, and therefore won’t contain the now deleted named properties). Do this using New-MoveRequest and ensure that -DoNotPreserveMailboxSignature is specified.
- Once the mailbox move is complete, the named properties should be gone. You can confirm this by running Check-NamedProps against it again (it should return 0 named properties after the move).