Slow Performance or Large Database File in MS CRM AsyncOperationBase

  There is a lot of information online about the MS CRM performance issues and very large database file sizes. Without going into MS CRM (you can Google that) it is by design. Can you believe that! CRM is set to record everything that is going on, and for most people, most of the transaction logging in the AsyncOperationBase table is just junk. Now you would expect that there is a little in application sort of… clean up your junk… feature in CRM, but alas we are dreaming of some Apple product. For this reason, the database has to be manually cleared, or an auto process set to do this manually. So the situation before me now is a massive database of 20GB with almost 17 million transactions listed. This server I am looking at is Windows 2008, and the SQL server is also Windows 2008. These are the steps… Read More »Slow Performance or Large Database File in MS CRM AsyncOperationBase

Data capture in DotNetNuke Tell My Friend Module

Today we have released a new version of Tell My Friends, the dotnetnuke module that allows you to send a message from a website to a friend advising them that you like the site. This new feature works like this: In the settings are of the module you simply enable the “Enable Data Capture” feature: Then from the menu inside the module configuration, you will find a new menu item called “Messages” This is the area that displays the data capture area of the messages sent. You can search of an email address: Or export the data to an excel spreadsheet: This will allow the data to be used with the Bulk Emailer module for DotNetNuke, using the excel sheet to import a custom list and email people who have been sent a message from your site.

MS CRM The length of the 'messageid' attribute of the 'email' entity exceeded the maximum allowed length of '100'.

I had noticed that this error was logging in the Application log of our CRM server very often. #9628 – An error occurred while delivering the e-mail message with subject "FW: Undeliverable: Read: " in mailbox for delivery to http://localhost/CRM. System.Web.Services.Protocols.SoapException: Server was unable to process request.    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)    at Microsoft.Crm.Sdk.Proxy.CrmService.Execute(Request Request)    at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.DeliverMessageInternal(EmailMessage emailMessage)    at Microsoft.Crm.Tools.Email.Providers.ExchangePollingMailboxProvider.DeliverMessageInternal(EmailMessage emailMessage)    at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.DeliverMessage(EmailMessage emailMessage)    at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.Run()rn   0x80044331   A validation error occurred.  The length of the ‘messageid’ attribute of the ’email’ entity exceeded the maximum allowed length of ‘100’.   Platform The solution was to customize the Email Entity. The Email Entity Attributes: messageID Change the Message Maximum Length to 250 Save and Close Then Publish Although this fix will not track all messages of any length, it will help.