Article ID: 969946 - View products that this article applies to.
This article describes a tool that is available for Microsoft Dynamics CRM 4.0. This tool is used to extract the tracking token from the e-mail subject and to update the tracking token column of the e-mail table for customers who have disabled Smart Matching. If you chose not to use the tracking token in conjunction with Smart Matching, the tool is ineffective. If the email subjects do not have a tracking token to begin with, then there is no way the tracking token column will be populated and the tool should not be used. After you disable Smart Matching, subsequent emails will not be mapped to existing emails in the system if the tracking token was formerly disabled. Only new or future emails will map based on the tracking token. If the tracking token is removed or altered in the email subject line, the link will be broken.
Note You must run this tool before you install the hotfix that Microsoft Knowledge Base article 958084 describes. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/958084/ )A hotfix to disable the Smart Matching feature in Microsoft Dynamics CRM 4.0 is available
Hotfix information for Microsoft Dynamics CRM 4.0A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.
If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.
Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
File informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
Collapse this tableExpand this table
PrerequisitesYou must have the Microsoft Dynamics CRM 4.0 installed to apply this hotfix.
Restart requirementIf you are prompted, restart the computer after you install the hotfix.
Removal informationTo remove this hotfix from a computer that is running Windows Server 2003, Windows XP, or Microsoft Windows 2000, use Add or Remove Programs in Control Panel.
You may receive the following error message when you run this tool:
For more information, visit one of the following Web sites, depending on the version of Microsoft SQL Server that you are using:
"Execution of user code in the .NET Framework is disabled. Enable \"clr enabled\" configuration option."
Microsoft SQL Server 2008:
http://msdn.microsoft.com/en-us/library/ms175193.aspxMicrosoft SQL Server 2005:
http://msdn.microsoft.com/en-us/library/ms175193(SQL.90).aspxWe recommend that you disable this functionality after the tool completes successfully.
The following error will occur if you use the 32-bit version of the tool on the 64-bit version of Microsoft SQL Server or the 64-bit version of the tool on the 32-bit version of Microsoft SQL Server:
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65549. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error: System.IO.FileLoadException: Could not load file or assembly 'microsoft.crm.se.emailtrackingtokenextractor, Version=220.127.116.11, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047) System.IO.FileLoadException: at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.Load(String assemblyString)
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684For more information about Microsoft Business Solutions CRM software hotfix and update package terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/LN/ )Description of the standard terminology that is used to describe Microsoft software updates
(http://support.microsoft.com/kb/887283/ )Microsoft Business Solutions CRM software hotfix and update package naming standards