Tips for a successful upgrade

The following issues, if applicable to your current Microsoft Dynamics CRM 4.0 deployment, should be resolved before you start the upgrade.

Maximum number of attributes exceeded

If you have more than 1023 attributes defined for an entity, you must delete the additional attributes before you run the upgrade. The upgrade will fail with the following message if you have more than 1023 attributes.

CREATE VIEW failed because column 'column_name' in view 'view_name' exceeds the maximum of 1024 columns.

Remove custom database objects

We suggest that, if you have added custom database objects such as triggers, statistics, stored procedures, and certain indexes, that you remove from the configuration and organization databases. In many cases, Microsoft Dynamics CRM Server Setup displays a warning when these objects are detected.

Remove the ignorechecks registry subkey

If you have manually added the ignorechecks registry subkey on the Microsoft Dynamics CRM Server 2011 remove it before you start the upgrade. For more information, see You cannot deploy Microsoft Dynamics CRM 4.0 by using an account that does not have local administrator permissions on Microsoft SQL Server.

Plug-in registration verification

Before upgrading from Microsoft Dynamics CRM 4.0, you must verify that the same plug-in assembly has not been registered multiple times with the same or different metadata fields (AssemblyName, MajorVersion#, MinorVersion#, PublicKeyToken, Culture).

You can use the Plug-in Registration Tool for Microsoft Dynamics CRM 2011 to verify plug-in assembly registration information. The Plug-in Registration tool is provided as a source code sample in the Tools folder of the Microsoft Dynamics CRM Software Development Kit download. Review the instructions provided in the Tools/PluginRegistration/Readme.docx file for more information about the tool and how to build it.

For more information about the Plug-in Registration Tool for Microsoft Dynamics CRM 2011, view the following Microsoft MSDN article:

Using the Plug-in Registration Tool for Microsoft Dynamics CRM 2011

You can also query PluginAssembly, PluginTypes in the organization database and perform Reflection on the PluginAssembly to determine plug-in assembly registration information. For more information about verifying plug-in registration, please contact Microsoft Support.