How to resolve common problems that may occur when you upgrade from Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0

Applies to: Dynamics CRM 4.0

INTRODUCTION


This article describes common problems that may occur when you upgrade from Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0. This article describes how to resolve these common problems.

More Information


Problems that are related to the Workflow tool

After you upgrade to Microsoft Dynamics CRM 4.0, the "Check activities" workflow condition does not work

In Microsoft Dynamics CRM 3.0, the "Check activities" workflow condition let you evaluate all activities or only those activities that were created by the workflow. In Microsoft Dynamics CRM 4.0, the "Check activities" workflow condition no longer exists. New conditions in Microsoft Dynamics CRM 4.0 include the following conditions:
  • Activity Count
  • Activity Count including Workflow
To work around this problem after you upgrade to Microsoft Dynamics CRM 4.0, delete the "Check activities" condition in the workflow. Then, include either the Activity Count condition or the "Activity Count including Workflow" condition.

The owner of a workflow that is not activated changes to the user who is performing the upgrade

Consider the following scenario. User 1 is the owner of a workflow that has not been activated in Microsoft Dynamics CRM 3.0. For example, the workflow has not been activated because it is in a draft state. You log on to Microsoft Dynamics CRM 3.0 as user 2 so that you can upgrade to Microsoft Dynamics CRM 4.0. In this scenario, the owner of the workflow is updated to user 2. To work around this problem, use one of the following methods:
  • Activate the workflow before you upgrade to Microsoft Dynamics CRM 4.0.
  • Run the upgrade as a user who is a member of the System Administrator role in Microsoft Dynamics CRM.
  • Log on as the correct user in Microsoft Dynamics CRM 4.0, and then create a new workflow.

Error message when you open an upgraded workflow

When you open an upgraded workflow in Microsoft Dynamics CRM 4.0, you receive the following error message:
Specified argument was out of the range of valid values.
This problem may occur if the workflow contains a date/time value that is set to a year that is earlier than 1900.

To resolve this problem, change the date/time value in the workflow to a value that is equal to or later than the year 1900.

For example, assume that the workflow contains the following date/time value.
On Quote Create
If
Quote.EffectiveFrom > 1753
Then
Create task
End if
To resolve this problem, change the workflow date/time value as follows.
On Quote Create
If
Quote.EffectiveFrom > 1900
Then
Create task
Note The year 1753 is the earliest year value that was allowed in Microsoft Dynamics CRM 3.0.

Error message when you upgrade a workflow process instance

When you upgrade a workflow process instance, you receive the following error message:
Unable to cast object of type 'System.DBNull' to type 'System.String'.
This problem may occur when the workflow includes a regarding object that does not have the primary attribute field for the entity populated. For example the primary attribute field for the account entity is Name. The primary attribute field must be populated if the object is created by using Microsoft Dynamics CRM. However, the primary attribute field does not have to be populated if the object is created by using the Microsoft Dynamics CRM Software Development Kit (SDK) or by using the bulk import feature.

To resolve this problem, re-create the workflow in Microsoft Dynamics CRM 4.0. If you want to find any records that include a regarding object that does not have the primary attribute field for the entity populated before you upgrade to Microsoft Dynamics CRM 4.0, contact Microsoft CRM support. For information about technical support for Microsoft CRM, visit the following Microsoft Web site:

Problems that occur when you have multiple Microsoft Dynamics CRM Web servers

Upgrade sequence

If you have multiple Microsoft Dynamics CRM Web servers, upgrade only one Web server at a time. When you upgrade the first server, the Web site on this server will be upgraded. And, the Microsoft Dynamics CRM databases will be upgraded. After you complete the upgrade on the first server, you can upgrade the next Microsoft Dynamics CRM Web server.

When you upgrade to Microsoft Dynamics CRM 4.0, the Workflow service stops

The Microsoft Dynamics CRM 4.0 upgrade stops the Workflow service on the local computer. You must stop the Workflow service manually on each additional Microsoft Dynamics CRM Web server if you have multiple Microsoft Dynamics CRM Web servers in the same deployment. You must do this so that any data that is being processed by the Workflow service will be updated in the Microsoft Dynamics CRM database. Each Workflow service will read up to a maximum of 200 events in memory and then process the events. If the Workflow service is not stopped on each Microsoft Dynamics CRM Web server, the Workflow service will fail when the database is upgraded.

Error message when you upgrade a Microsoft Dynamics CRM Web server: "The remote server returned an error: (500) Internal Server Error"

Consider the following scenario. You upgrade the first Microsoft Dynamics CRM Web server to Microsoft Dynamics CRM 4.0. During the upgrade of the first Microsoft Dynamics CRM Web server, the Microsoft Dynamics CRM databases are upgraded. Then, you upgrade additional Microsoft Dynamics CRM Web servers in the same environment. When you run the Environmental Diagnostic Wizard, you receive an error message in the CRM40Setup.log file. This error message resembles the following error message:
[SqlException]: Cannot open database Organization_name_METABASE; requested by the login. The login failed.


Login failed for user 'user'.
Note The CRM40Setup.log file is located in the following folder:
C:\Documents and Settings\Administrator\Application Data\Microsoft\MSCRM\Logs
This problem occurs because the Microsoft Dynamics CRM Web server is trying to connect to the Metabase database. The Metabase database no longer exists for Microsoft Dynamics CRM 4.0 because the Microsoft Dynamics CRM databases were upgraded when you upgraded the first Web server.

To resolve this problem, ignore the error message. Then, continue to upgrade the additional Microsoft Dynamics CRM Web servers.

The upgraded workflow rules fail when the rules are run on a new Microsoft Dynamics CRM 4.0 Web server

Consider the following scenario. You have workflow rules in Microsoft Dynamics CRM 3.0 that use the default Microsoft .NET assemblies. You upgrade the first Microsoft Dynamics CRM Web server to Microsoft Dynamics CRM 4.0. Then, you upgrade additional Microsoft Dynamics CRM Web servers to Microsoft Dynamics CRM 4.0. If the workflow rules are run on the first Web server that was upgraded, the workflow rules run as expected. However, in this scenario, the workflow rules on the additional Web servers fail.

This problem occurs because the Microsoft .NET assemblies are not present on the additional Microsoft Dynamics CRM Web servers.

To resolve this problem, copy and then register the Microsoft .NET assemblies on the additional Microsoft Dynamics CRM 4.0 Web servers.

Problems that are related to Service in Microsoft Dynamics CRM

The Update Contract States SQL job has changed

In Microsoft Dynamics CRM 3.0, the status of a contract is evaluated by the Update Contract States SQL job. This job runs one time per day at midnight. This job sets the expired contracts to a state of Expired.

In Microsoft Dynamics CRM 4.0, the status of a contract is evaluated as a recurring asynchronous system job. The time that the job is run is recorded as the time when the asynchronous service was started.

To resolve this problem, start the asynchronous service at an appropriate time for your organization.

Problems that are related to custom entities

Some foreign key constraints on custom entity tables are missing after you upgrade to Microsoft Dynamics CRM 4.0

Consider the following scenario. You have a custom entity table, and the custom entity table has a primary key constraint and a foreign key constraint on the same column. When you upgrade to Microsoft Dynamics CRM 4.0, the foreign key constraint is removed during the upgrade process.

For example, assume that you have a custom entity table that is called AuditTrailExtensionBase. The following foreign key is added.
ALTER TABLE [dbo].[<databasename>_AuditTrailExtensionBase] 
ADD CONSTRAINT [FK_<databasename>_AuditTrailExtensionBase_<Databasename>_AuditTrailBase]
FOREIGN KEY ([<databasename>_AuditTrailId])
REFERENCES [dbo].[<databasename>_AuditTrailBase] ([<databasename>_AuditTrailId])
After the upgrade process is complete, this foreign key is no longer present.

To resolve this problem, add the missing foreign key constraint to the custom entity table.

Problems with the Microsoft Dynamics CRM 3.0 Web site

Error message when you run the Environmental Diagnostic Wizard

When you run the Environmental Diagnostic Wizard, you receive the following error message:
time| Error| Check ExportXmlValidator : Failure: The request failed with HTTP status 403: Forbidden.
Note The time placeholder is a placeholder for the time at which the error occurred.

This problem occurs when the Microsoft Dynamics CRM 3.0 Web site requires Secure Sockets Layer (SSL). To resolve this problem, click to clear the Require secure channel (SSL) check box, and then run the Microsoft Dynamics CRM 4.0 upgrade again. To do this, follow these steps:
  1. Log on to the server that is running the server components of Microsoft Dynamics CRM 4.0.
  2. Right-click My Computer, and then click Manage.
  3. Expand Services and Applications.
  4. Expand Internet Information Services (IIS) Manager.
  5. Expand Web Sites.
  6. Right-click Microsoft Dynamics CRM 3.0, and then click Properties.
  7. On the Directory Security tab, click Edit under Secure Communications.
  8. Click to clear the Require secure channel (SSL) check box, and then click OK two times.
  9. Reset IIS. To do this, click Start, click Run, type iisreset in the Open box, and then click OK.
  10. Run the Microsoft Dynamics CRM 4.0 upgrade again.

References


For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
 
946542 Error message when you upgrade Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0: "Microsoft Dynamics CRM 3.0 database export failed"
 
946543 Error message when you upgrade Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0: "Unable to resolve related entity for report upgrade"
 
946544 Microsoft CRM 3.0 hotfixes remain in Add or Remove Programs
 
946545 Error message after you upgrade Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0: "Microsoft.Crm.Tools.FaxConnectorService.FaxSinkServiceException"
 
946597 Error message when you upgrade to Microsoft Dynamics CRM 4.0: "Exception has been thrown by the target of an invocation"
 
946619 Error message when you upgrade from Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0 in certain languages: "One or more version 3.0 reports were not upgraded"
 
For more information, see the "Microsoft Dynamics CRM Server Installation Instructions" section of the Microsoft Dynamics CRM 4.0 Implementation Guide. To obtain this guide, visit the following Microsoft Web site:Also, see the Readme file for the server components of Microsoft Dynamics CRM 4.0. To obtain this Readme file, visit the following Microsoft Web site:The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

References


For more information about the updates that are included in the setup update for Microsoft Dynamics CRM 4.0, click the following article number to view the article in the Microsoft Knowledge Base:

948917 How to obtain the setup updates for Microsoft Dynamics CRM 4.0