Exchange Server Health gives the error against Exchange 2007 and 2010 mailbox servers:
<Status ServerAddress="127.0.0.1" ErrorMessage="Error code = 0
 Error message = Incorrect function.
 Error source = msxml6.dll
 Error description = Not enough storage is available to complete this operation.

" ManagedObjectId="148" StartDateTime="40365.2604976852"/>
Issue pulling Event ID 1029 from Application logs on an Exchange Server with Mailbox role
WORKAROUND:
Exclude Event ID 1029 from the Exchange Server Health test in question:
1. Open the Spotlight on Messaging Management Console
2. From the left-pane, right-click | edit the Exchange Server Health test that is displaying the error
3. On the left-pane, click the Exchange version with the problem
4. If Exchange 2007, scroll down to "Application\MSExchangeIS* (*)" or if Exchange 2010, scroll down to "Application\MSExchange* (*)"
5. Right-Click | Edit
6. In between (*) change it to (0-1028)
E.g. of what it will look like: "Application\MSExchange* (0-1028)
7. Press Enter.
8. Click <Add Event Log Entries...>
9. For Event Log, leave as Application
10. For Source, type: MSExchange*
11. For Event IDs: 1030-999999
12. Click OK.
13. Click Finish
14. Run the test, verify if the error still occurs.
STATUS
Waiting for fix in a future release of Spotlight on Messaging