MS Dynamics CRM Customization and programming tricks by Ronny Van der Snickt

MS CRM 4.0 workflow assembly in a MS CRM 2011 solution

Just got this error when uploading a crm 4.0 workflow assembly in a CRM 2011.
Could not load file or assembly ‘Microsoft.Crm.Sdk, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35′ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0×80131040)
Found the solution at Rick Wilson blog link
Just add this after the configSections section in the web.config of the CRM 2011 website.
<runtime>
<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>
<dependentAssembly>
<assemblyIdentity name=”Microsoft.Crm.Sdk” culture=”neutral” publicKeyToken=”31bf3856ad364e35″ />
<bindingRedirect oldVersion=”4.0.0.0″ newVersion=”5.0.0.0″ />
</dependentAssembly>
</assemblyBinding>
</runtime>

Ghost project in TFS: Project site folder already exists

When I was working with Team Foundation Server and tried to delete and recreate a TFS project I got the following error.

Error
TF30004: The New Team Project Wizard encountered an unexpected error while initializing the Microsoft.ProjectCreationWizard.Portal plug-in.
 Explanation
TF30171: The Microsoft.ProjectCreationWizard.Portal plug-in used to create the new team project could not be initialized and returned the following error: TF30270: Project site folder “ProjectName” already exists.User Action
Contact your Team Foundation Server administrator.

 

—begin Exception entry—
Time: 2010-06-17 10:40:17Z
Module: Initializer
Event Description: TF30207: Initialization for plugin “Microsoft.ProjectCreationWizard.Portal” failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: TF30270: Project site folder “ProjectName” already exists
Stack Trace:
at Microsoft.VisualStudio.TeamFoundation.WssSiteCreator.Initialize(ProjectCreationContext context)
at Microsoft.VisualStudio.TeamFoundation.EngineStarter.InitializePlugins(MsfTemplate template, PcwPluginCollection pluginCollection)
— end Exception entry —

MS CRM 4.0 Setup error: ASP.NET is not installed

Today I got an error when installing MS CRM 4.0. Internet Information Services (IIS) => ASP.NET is not installed. (The screenshot is in Dutch but I tried the English installation too with the same results).

Screenshot setup ms crm 4.0

The log file didn’t helped much either Read more »

Show the number of records and space for each database table.

I created a nice SQL query today to show the number of records in each table in a database and the space it takes in the database in megabytes.

Very handy to see why some MS CRM databases are so big.

My biggest SQL transaction ever.

I just performed my biggest SQL transaction ever.

I had to delete 100 million DuplicateRecordBase records in de CRM database (More info)

 select count(*) from DuplicateRecordBase

 

I used the following SQL because using the delete statement filled up the hard disk and would have taken ages.

truncate table DuplicateRecordBase

Show subordinate records after merging accounts

First create an IFrame on your form, this will contain the associated view. In my case I’m using the account entity.
Read more »

Host headers issue with WSS 3.0, MOSS 2007 and Search Server 2008

When installing WSS 3.0, MOSS 2007 or Windows Search Server 2008 I always encounter the same issue when using Host Headers. So I thought it was time to blog this. When I try to access a page which is configured with a host header I get prompt to enter my credentials 3 times. After the third time I get an empty page. This only happens when you access the page from the same machine as the installation. When accessing the page from another PC it works immediately. Read more »

E-mail Router service failes to start after rollup 5

After installing Microsoft CRM Rollup 5 (incl. reboot) the email router service failed to start. In the event log the following error appeared: The E-mail Router service could not run the service main background thread.
Read more »

Office 2010… A Movie?

Can you make office 2010 look cool?

Maybe it’s the nerd in me speaking but I just loved the new promo movie for the new office release.

Go backstage With Office 2010: http://www.office2010themovie.com

Speed up development with external JavaScript files

When creating complicated JavaScript for MS CRM it can be easier to place your code in an external JavaScript file while developing. This content of this file will be loaded and executed in the onload event of the form.
Read more »