Here's the latest build numbers for Dynamic CRM.
RTM: 4.0.7333.3
Rollup 1: 4.0.7333.1213
Rollup 2: 4.0.7333.1316
To find out your current build number, you may run the following query against your [ORGANIZATION]_MSCRM database.
Select * FROM BuildVersion
If you need to do a redeployment and you are looking for the existing CRM 4.0 product key, you may find it in the MSCRM_CONFIG database. All you have to do is to run the following query against the MSCRM_CONFIG database.
SELECT LicenseKey FROM ConfigSettings
The client contacted me this morning telling me that they still seeing the same amount of messages in the forward mailbox. The number of messages didn’t reduce at all. That makes me wondering why this is happening. So I did a LiveMeeting session with them. We logged on to the mailbox via OWA, we saw the new messages in the inbox got processed, the reason that the Exchange admin console still showing the 44,000 messages because the messages got moved to the undeliverable folder. Ah… that’s why we didn’t see the number of messages reduce in the Exchange admin console. Once we move the messages from the undeliverable folder to inbox, the router starts to process the messages.
I checked the event view, I saw some errors and warnings like this one below:
Event Type: Error
Event Source: MSCRMEmail
Event Category: None
Event ID: 0
Date: Date
Time: Time
User: N/A
Computer: Computer Name
Description:
#9628 - An error occurred while delivering the e-mail message with subject "Subject" in mailbox E-mail Address for delivery to http://crm/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()\r\n
0x80044150
Generic SQL error.
Platform
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
This was a known error from Microsoft. After we upgraded CRM to RU #1 by installing the rollup on the server, clients and the email router, the issue is resolved.
OK, just in case you run into similar issue, I hope this will help you.
Have you ever dealt with Email Router issues before? In my opinion, the Email Router is one of the complicated components in CRM. There are two versions available, on-premise and online. To configure the router, you have three different ways to do it and it all depends on your own environment and your preference. If you want know how to configure the email router step by step, please refer to the MS CRM 4.0 Email Router Configuration Scenario.
Today I encountered another issue related to the email router. One of my clients upgraded to CRM 4.0 couple months ago, however they didn't upgrade their email router. So they are running CRM 4.0 and using the CRM 3.0 Email Router. Since CRM 3.0 used the forward mailbox option, all users had the forwarding rule deployed to their exchange profile to cc emails to the forward mailbox. Since CRM 3.0 not able to promote tracked emails to CRM 4.0, all of emails remained in the mailbox and the mailbox was full. Users were getting email error telling them the mailbox reached its size limit. I logon to the mail account via OWA and I saw more than 44,000 messages in the mailbox.
To resolve the issue, I had to uninstall the CRM 3.0 Email Router and then reinstall the CRM 4.0 Email Router. I also configured it to use the forward mailbox option after the install. I don't have to redeploy the forwarding rule because the old rule is compatible with CRM 4.0. If you would like to remove or redeploy forwarding rule, you may use the CRM 4.0 Rule Deployment Wizard (You can't use the CRM 3.0 Rule Deployment Wizard to configure the rule after you upgraded CRM to version 4.0, you need to use the CRM 4.0 Rule Deployment Wizard to do so). If you configure everything correctly, the email router will start processing all of the emails in the forward mailbox. It will not promote all of the messages in the forward mailbox all at once. It will process small amount of emails every 10 minutes to limit the resources it will consume in the environment. So to process 44,000 messages, it will take some time.
OK, I hope that this will help you just in case you encounter something similar to this.
Microsoft just released a white paper today on improving CRM performance and securing data with SQL 2008. The paper contains great information on how to leverage SQL Server 2008 features such as Compression, Filtered Indexes, Data Encryption, etc… to improve MS CRM Performance if implemented correctly.
Also this paper contains an overview of MS SQL Server 2008 features and some benchmark results and recommendations from Microsoft.
So download and read it as soon as you can. you may download this paper from Microsoft’s website by clicking on the link below. Enjoy reading this white paper. :)
Happy Chinese New Year of the Ox! Let this year be a BULL year for CRM around the world!
My company’s head quarter is located in Indianapolis, so I travel to Indiana a lot for work since most of my projects are around Indianapolis and South Bend. Since I work in Indiana so much, I want to find an “authentic, authentic” Chinese restaurant where all local Chinese eat at. I finally found one and I also believed it’s the only one Chinese restaurant people will go for dinner and dim sum.
The restaurant name is Great Garden, it’s located in Indianapolis (Not so safe area according to my co-workers). The address of the restaurant is 3623 Commercial Dr. Indianapolis, IN 46222 and the phone number is 317-290-2628.
I did a search online and I found a Chinese forum for international students listed all of the acceptable Chinese, Japanese and Korean restaurant around Indianapolis. I copied and pasted on my blog just in case you are looking for authentic Chinese, Japanese, and Korean food. I will try the all restaurants indicated below and let all of you know if it’s acceptable according to my standard. :) I am really picky on food.
Chinese
Great Garden
3623 Commercial Dr.
Indianapolis, IN 46222
Tel:317-290-2628
Shen Yang
3902 Georgetown Rd.
(317) 280-1978
The Journey
7155 E. 96th St.
Indianapolis IN, 46250
Japanese
Asaka Japanese Restaurant
6414 E 82ND St
Indianapolis, IN 46250-1584
(317) 576-0556
Sakura Japanese Restaurant
7201 N Keystone Ave
Indianapolis, IN 46240-3243
(317) 259-4171
Ocean World
1206 W 86th St
Indianapolis, IN 46260-2204
(317) 848-8901
Korean
Bando Restaurant
8015 Pendleton Pike
Phone: 897-8277
Dami
10989 Allisonville Road
Fishers, IN 46038
Mama's House Restaurant
8867 Pendleton Pike
Indianapolis, IN 46226-4111
Vietnamese
Saigon Restaurant
3103 Lafayette Rd.
Phone: 927-7270
Sizzling Wok
4351 Lafayette Road
Phone: 297-3441
King Wok
4150 Lafayette Rd
Indianapolis, IN 46254
(317) 295-8090
So enjoy!
Posts
All Comments
