31 July 2010

CRM 4.0 Update Rollup 12

Latest CRM 4.0 rollup 12 released on 30/July/2010.
Rollup 12 can be uninstall on server
Rollup 12 is cumulative.
Rollup 1,2,3,4,5,6,7,8,9,10,11 are not prerequisites for server portion.
Update Rollup 7 is a prerequisite for Microsoft Dynamics CRM for Microsoft Office Outlook and Microsoft Dynamics CRM Data Migration Manager.

Special Considerations:
Update Rollup 12 will install the Microsoft Report Viewer 2008 Redistributable Package.
Update Rollup 12 will install the Microsoft Visual C++ 2008 Redistributable Package

KB: KB2028381

30 July 2010

Modify the recurring system jobs' interval in CRM 4

Default CRM4.0 come with 3 system jobs, "Update Contract States","Organization Full text Catalog index", and "SQM Data Collection". If you have duplicate detection rules published, then you will have more than 3 jobs.[Matchcode Update]

Default jobs run every 5 minutes, each time it run will create a record under the AsyncOperationBase table. This definately will make the tbale grow very fast if you have many duplicate detection rules. Simple math will be 12 records per minutes; 720 records per hour; 17280 records per day.

Of course there is service to help you remove old records, but for me the Matchcode Update seems no need to run so frequently if most of the time is use for browsing. For me update hourly or every 30 minutes is fair enough.

Example: run this query in MSCRM DB
<br /> SELECT name,RecurrencePattern FROM dbo.AsyncOperationBase<br /> WHERE RecurrencePattern is not null and name='Accounts' <br /> 

name is the duplicate detection job related entity.

You will see something like "FREQ=MINUTELY;INTERVAL=5;"
In this case i change to 7 minutes by using SQL update statement,
then restart service.

Reference http://msdn.microsoft.com/en-us/library/cc189846.aspx for all valid values.

*Information I post below is an unsupported customization, this might void your CRM warranty. Personnaly I have tried this in both my CRM development environment and is working like charm!

15 July 2010

CRM 2011 beta

Dynamics CRM 2011, the next version of Microsoft's customer relationship management software, will be released to beta in September and officially released by the end of this year, Microsoft announced today.

Microsoft is demoing the upcoming product at the annual Worldwide Partner Conference, which began Sunday and runs through Thursday in Washington, D.C. Along with Dynamics CRM comes its cloud-based counterpart, Dynamics CRM Online.

New to Dynamics CRM 2011 will be the Microsoft CRM Marketplace, where businesses can sell and buy CRM solutions, download them and then deploy them across their Dynamics CRM systems. Such solutions can include sets of configurations and document templates that help companies work with their customers...

Original Source : http://blog.seattlepi.com/microsoft/archives/214088.asp