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
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.
Scenario: The Microsoft CRM 4.0 Email Router Service won’t start and throws an error message stating "The Microsoft CRM Email Router service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service." The Application Event log also logs indicates an error like this: ______________________________ Event Type: Error Event Source: MSCRMEmail Event Category: None Event ID: 0 Date: Time: User: Computer: Description: #16192 – The E-mail Router service could not run the service main background thread. The E-mail Router service cannot continue and will now shut down. System.Configuration.ConfigurationErrorsException: The E-mail router service cannot access system state file Microsoft.Crm.Tools.EmailAgent.SystemState.xml. The file may be missing or may not be accessible. The E-mail Router service cannot continue and will now shut down. —> System.Xml.XmlException: Root element is missing. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res) at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlTextReaderImpl.Read()… Read More »Microsoft CRM 4.0 Email Router Service Will Not Start
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 email@example.com 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.