Microsoft KB Archive/925874

= An update for the 2007 daylight saving time changes is available for Microsoft Dynamics CRM 3.0 and for the Microsoft Dynamics CRM 3.0 client for Outlook =

Article ID: 925874

Article Last Modified on 12/7/2007

-

APPLIES TO

 Microsoft Dynamics CRM 3.0 Microsoft CRM client for Microsoft Office Outlook, when used with:  Microsoft Dynamics CRM 3.0

 Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers  Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers

-

<div class="notice_section">

Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows XP and Windows Vista

Note For more information about specific updates for computers that are affected by daylight saving time changes in New Zealand, click the following article number to view the article in the Microsoft Knowledge Base:

937667 An update is available for the New Zealand 2007 daylight saving time changes in Microsoft Dynamics CRM 3.0 and in the Microsoft Dynamics CRM 3.0 client for Outlook

<div class="symptoms_section">

SYMPTOMS
In 2007, the start dates and the end dates for daylight saving time (DST) in the United States will change to comply with the Energy Policy Act of 2005. The dates will change as follows.

After daylight saving time goes into effect on March 11, 2007, you may experience the following problems in Microsoft Dynamics CRM:
 * When you view appointments or tasks in the Microsoft Dynamics CRM Web client or in the Microsoft Dynamics CRM client for Microsoft Office Outlook, the appointments and the tasks may be scheduled one hour ahead of the actual event time or one hour behind the actual event time.
 * Some activities and some resources in the service calendar in Microsoft Dynamics CRM may be scheduled one hour ahead of the actual event time or one hour behind the actual event time.

The DST changes affect many time zones that are stored in Microsoft Dynamics CRM. These time zones may affect all Microsoft Dynamics CRM users. This includes users who are outside the United States. For a list of the affected time zones, see the “More information” section.

<div class="resolution_section">

Update information
A supported update is now available from Microsoft for computers that are running the following:
 * Microsoft Dynamics CRM 3.0
 * Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
 * The Chinese version and the Japanese version of Microsoft Dynamics CRM 3.0
 * Microsoft Dynamics CRM 3.0 client for Outlook

Note The update for the Microsoft Dynamics CRM 3.0 client for Outlook includes the Microsoft Dynamics CRM 3.0 client for Microsoft Office Outlook Compatibility Release. This release makes the Microsoft Dynamics CRM 3.0 client for Outlook compatible with Windows Vista and with 2007 Microsoft Office programs.

The following files are available for download from the Microsoft Download Center.

Microsoft Dynamics CRM 3.0
 * Download this file if you are using the Microsoft Dynamics CRM 3.0 client for Outlook or if you are using the Microsoft Dynamics CRM 3.0 client for Outlook Compatibility Release.

Download the CRM3.0-KB925874-Client-&lt;ENU&gt;.exe package now.
 * Download this file if you are using the Microsoft Dynamics CRM 3.0 server software.

Download the CRM3.0-KB925874-Server-&lt;ENU&gt;.exe package now.

Microsoft Dynamics CRM 3.0 Update Rollup 2

The update for the 2007 daylight saving time changes is included in Microsoft Dynamics CRM 3.0 Update Rollup 2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

927751 Update Rollup 2 is available for Microsoft Dynamics CRM 3.0

Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
 * Download this file if you are using the Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers server.

Download the CRM3.0PE-KB925874-Server-&amp;lt;ENU&amp;gt;.exe package now.
 * Download this file if you are using the Microsoft Dynamics CRM 3.0 client for Outlook together with Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers.

Download the CRM3.0PE-KB925874-Client-&amp;lt;ENU&amp;gt;.exe package now.

The Chinese version and the Japanese version of Microsoft Dynamics CRM 3.0  Download this file if you are using the Chinese version and the Japanese version of Microsoft Dynamics CRM 3.0:

http://www.microsoft.com/downloads/details.aspx?displaylang=ja&FamilyID=8a7319e6-5b86-4e7a-9be1-763f2072be21

</li></ul>

Release Date: March 2, 2007

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Note In the file names, the  placeholder in the file names is a placeholder for the abbreviation of the language version that you install.

What the update includes
This update includes the following:
 * The new 2007 DST start dates and end dates for several time-zone definitions in Microsoft Dynamics CRM. For example, all United States time zones will be changed to reflect the new DST start dates and the new DST end dates.
 * Several new stored procedures and tables that are used by the Update Time Zone Wizard. This wizard uses these stored procedures and tables to determine the Microsoft Dynamics CRM records that may have to be updated to reflect the DST changes.

File information
The English version of this update 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.

Installation information for the update
Install this update on computers that are running the Microsoft Dynamics CRM 3.0 server software, the Microsoft CRM 3.0 client for Outlook, or Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers.

Synchronize offline data from computers that are running the Microsoft Dynamics CRM laptop client for Outlook
We recommend that you synchronize all the offline data from all the computers that are running the Microsoft Dynamics CRM laptop client for Outlook to the Microsoft CRM server before you install this update. The list of candidates that are eligible for the DST changes is created during the installation of this update. This list cannot be re-created. The candidate table is used by the Update Time Zones Wizard. This wizard lets the administrator make data corrections that reflect the DST changes. The wizard updates the candidate table with information about the records that have been updated for the DST changes.

If you do not synchronize the offline data from all the computers that are running the Microsoft Dynamics CRM laptop client for Outlook before you install the Microsoft CRM server-side hotfix, the following sequence of events causes data to appear incorrectly in Microsoft CRM.
 * You install the Microsoft CRM server-side update that creates the list of candidates.
 * A computer that is running the Microsoft Dynamics CRM laptop client for Outlook synchronizes data to the Microsoft CRM server.
 * The data that was synchronized is not added to the candidate table. Therefore, that data may appear incorrectly in Microsoft Dynamics CRM.

Note The Microsoft CRM client for Outlook includes both the Microsoft CRM laptop client for Outlook and the Microsoft Dynamics CRM desktop client for Outlook.

Install the client-side update on computers that are running the Microsoft CRM client for Outlook
We recommend that you install the client-side update on computers that are running the Microsoft CRM laptop client for Outlook and on computers that are running the Microsoft Dynamics CRM desktop client for Outlook. The DST issues in the Microsoft Dynamics CRM desktop client for Outlook are resolved in the Microsoft Dynamics CRM server-side update. However, this update also includes other hotfix file information. The Microsoft Dynamics CRM client-side update must be installed on computers that are running the Microsoft Dynamics CRM desktop client for Outlook to maintain file consistency. This file consistency is required because of other hotfix dependencies.

Install the server-side update on all the Microsoft Dynamics CRM servers
If you have multiple Microsoft Dynamics CRM servers, you must install the server-side update on all the Microsoft Dynamics CRM servers. However, do not install this update on each Microsoft Dynamics CRM server at the same time. Install this update on each Microsoft Dynamics CRM server separately to prevent deadlocks in Microsoft SQL Server.

Install the server-side update in new installations of Microsoft Dynamics CRM 3.0
If you install Microsoft Dynamics CRM after the new start date and the new end date for DST go into effect, you must still apply this update. This update adds the new time zone definitions. You should install this update before users enter any data in Microsoft Dynamics CRM.

Recommended installation order
We recommend a specific installation order when you install DST updates for other products that are used by Microsoft Dynamics CRM. We also recommend a specific installation order when you install the server-side update and the client-side update. We also recommend that you run the Update Time Zones Wizard at a specific point in the installation process. For more information, see the “Recommended sequence of update actions for the Microsoft CRM system” section of the Microsoft Dynamics CRM 3.0 Remediation Instructions for 2007 Daylight Saving Time Changes document. This document is available for download from the Microsoft Download Center.

The following file is available for download from the Microsoft Download Center:

Download the CRM_DST_Remediation_Details_Rev1.1.exe package now.

Release Date: March 2, 2007

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Required user rights
You must be a member of the Microsoft Dynamics CRM PrivUserGroup in Active Directory to install this update.

If many records are affected by the DST changes
You must increase the OLEDB time-out registry value if many records are affected by the DST changes. You must do this to prevent a possible Microsoft SQL Server time-out when you install this update.

Note If this registry subkey already exists, note the current value. After you complete the DST changes for Microsoft Dynamics CRM, set the value of this registry subkey back to the original value. Or, delete the registry subkey if it did not exist previously. The default OLEDB time-out value is 30 seconds. To increase the OLEDB time-out registry value, follow these steps: <ol> Click Start, click Run, type regedit, and then click OK.</li> Locate the following registry subkey:

</li> Right-click MSCRM, point to New, and then click DWORD Value.</li> Rename the DWORD value as &quot;OLEDBTimeout.&quot;</li> Right-click the DWORD value, and then click Modify.</li> Under Base, click Decimal. Then, type 3600 in the Value data box, and then click OK.

Note A decimal value of 3,600 equals 60 minutes.</li></ol>

Prerequisites
You must have Microsoft Dynamics CRM 3.0 installed to apply this hotfix.

Restart requirement
If you are prompted, restart the computer after you install the update.

Removal information
You cannot remove this hotfix.

Issue 1
If you have installed a third-party program that registers the Microsoft.Crm.MetadataService.dll file to the global cache assembly (GCA), you may experience a problem saving or updating an entity or attribute in Microsoft Dynamics CRM after you install this update.

For more information about how to resolve this issue, click the following article number to view the article in the Microsoft Knowledge Base:

934690 Error message when you save or update an entity or an attribute in Microsoft Dynamics CRM 3.0: &quot;An error has occurred. For more information, contact your system administrator&quot;

Issue 2
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

When you install update 925874, you receive the following error message:

Application has generated an exception that could not be handled. Process id 0x4f4 (1268), Thread Id=0xe7c (3708).

You may receive this error message for one of the following reasons:
 * A registry key is missing. This registry key is required by the TimeZoneUpdatePatch.exe file. The TimeZoneUpdatePatch.exe file runs as a subprocess of the update 925874 installation. See Resolution 1 in this section.
 * An unknown registry key is queried by the TimeZoneUpdatePatch.exe file. The TimeZoneUpdatePatch.exe file runs as a subprocess of the update 925874 installation. See Resolution 2 in this section.

Note Time zones are stored in the registry in the following location:

Resolution 1
<ol> Copy the time zone registry key values to a text file. To do this, type the following command at the command prompt:

REG QUERY &quot;HKLM\Software\Microsoft\Windows NT\CurrentVersion\Time Zones&quot; /s | findstr /I &quot;index software Dlt Std Display TZI&quot; >TimeZoneRegInfo.txt

</li> Use the same command on another Microsoft Dynamics CRM server on which update 925874 was successfully installed.</li> Download the Windiff.exe file. To do this, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=49ae8576-9bb9-4126-9761-ba8011fabf38&displaylang=en

</li> Run the Windiff.exe file to compare the TimeZoneRegInfo.txt files. Compare the TimeZoneRegInfo.txt files to determine which time zones are missing an index entry for a specific time zone. Time zones that are missing an index entry have a value of DWORD.</li> Update the registry value that is missing an index entry for a specific time zone. To open the registry, click Start, click Run, type regedit, and then click OK.</li></ol>

Resolution 2
<ol> Copy the time zone registry key values to a text file. To do this, type the following command at the command prompt:

REG QUERY &quot;HKLM\Software\Microsoft\Windows NT\CurrentVersion\Time Zones&quot; /s | findstr /I &quot;index software Dlt Std Display TZI&quot; >TimeZoneRegInfo.txt

</li> Use the same command on another Microsoft Dynamics CRM server on which update 925874 was successfully installed.</li> Download the Windiff.exe file. To do this, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=49ae8576-9bb9-4126-9761-ba8011fabf38&displaylang=en

</li> <li>Run the Windiff.exe file to compare the TimeZoneRegInfo.txt files.</li> <li>In the TimeZoneRegInfo.txt file for the Microsoft Dynamics CRM server on which update 925874 was successfully installed, look for time zones that are unknown. For example, the following registry key prevents update 925874 from being installed successfully:

</li> <li>Export the unknown time zone registry key to create a backup. To do this, select the registry key, click File, and then click Export. Save the registry key as an .reg file.</li> <li>Start the installation of update 925874 again.</li> <li>After update 925874 is successfully installed, reenter the unknown time zone registry key in the registry. To do this, double-click the file that you created in step 6.</li></ol>

Issue 3
When you install update 925874, you receive the following error message:

Setup failed to update the database. The installation of this update has stopped. Contact Customer Support Services.

Additionally, the following error message is logged in the KB925874_err.log file:

(Diagnostic) Failed to execute CrmDbHfExecute for KB923057 (Error) CHfHarness Update failed with return value = 80040e31 Function: CCrmDbHf::Update File: c:\bt\234\src\crmse\installer\mscrmcustom\crmdbhf.cpp Line: 160 (Information) ConfirmInstallation failed.

Notes
 * The KB925874_err.log file is located in the :\windows directory on the Microsoft Dynamics CRM server.
 * Update 925874 includes other Microsoft Dynamics CRM hotfixes. This issue is typically because of many contacts that must be updated by hotfix KB923057.

To resolve this issue, add or increase the  registry value. To do this, follow these steps.

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk. <ol> <li>On the Microsoft Dynamics CRM server, click Start, click Run, type regedit, and then click OK.</li> <li>Locate and then click the following registry subkey:

</li> <li>If the  key does not exist, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>On the Edit menu, point to New, and then click DWORD Value.</li> <li>Type HotfixDBTimeout, and then press ENTER.</li> <li>Right-click HotfixDBTimeout, and then click Modify.</li> <li>Under Base, click Decimal, type 65000 in the Value data box, and then click OK.

Note Microsoft Dynamics CRM hotfix installations only recognize  registry values between 0 and 65535. These values represent the number of seconds of a time-out. You can leave the default value after you install the hotfix.</li> <li>On the File menu, click Exit.</li></ol> </li></ol>

Note You may have to add or modify the  registry value. If this registry subkey already exists, note the current value. After you complete the DST changes for Microsoft Dynamics CRM, revert the value of this registry subkey to the previous value. Or, delete the registry subkey if it did not previously exist. The default OLEDB time-out value is 30 seconds.

To increase the OLEDB time-out registry value, follow these steps: <ol> <li>Click Start, click Run, type regedit, and then click OK.</li> <li>Locate the following registry subkey:

</li> <li>Right-click MSCRM, point to New, and then click DWORD Value.</li> <li>Rename the DWORD value as &quot;OLEDBTimeout.&quot;</li> <li>Right-click the DWORD value, and then click Modify.</li> <li>Under Base, click Decimal. Then, type 65000 in the Value data box, and then click OK.</li> <li>On the File menu, click Exit to exit Registry Editor.</li> <li>Install KB925874 again on the Microsoft CRM Server. After it has successfully installed, revert the  registry value back to the previous value. Or, delete the registry subkey if it did not exist previously.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

Stored procedures
The following Microsoft SQL Server stored procedures are installed in the  _MSCRM database when you install this update:
 * p_TimeZoneUserCandidates
 * p_TimeZoneNonUserCandidates
 * p_TimeZoneSecureUserCandidates
 * p_TimeZoneGenerateCandidates
 * p_TimeZoneGetTimeZonesInUse
 * p_TimeZoneGetEntitiesByTimeZone
 * p_TimeZoneGetEntitiesAllTimeZone
 * p_TimeZoneCandidateSummary
 * p_UpdateCalendarTimeZone
 * p_PopulateTimeZoneCodeLegacy
 * p_UpdateEntityTimeZoneCode
 * p_UpdateEntityTimeZone

The following Microsoft SQL Server tables are installed in the  _MSCRM database when you install this hotfix:
 * TimeZoneAdjustmentWindows
 * TimeZoneEntityAttribute
 * TimeZoneUserSetting
 * TimeZoneEntityCandidate
 * UpdateEntityTimeZoneInput

<div class="moreinformation_section">

Time zones that are affected by the DST changes for Microsoft Dynamics CRM 3.0
The following is a list of time zones that are affected by the DST changes for Microsoft Dynamics CRM 3.0.

For more information about the Microsoft Dynamics CRM 3.0 Update Time Zones Wizard, click the following article number to view the article in the Microsoft Knowledge Base:

932984 How to make the 2007 daylight saving time changes by using the Update Time Zones Wizard for Microsoft Dynamics CRM 3.0

For more information about Microsoft CRM and DST, click the following article number to view the article in the Microsoft Knowledge Base:

933453 How to update Microsoft Dynamics CRM 3.0 for daylight saving time in 2007

Microsoft Dynamics CRM 3.0 Update Rollup 1
The installation of this update is not dependent on the installation of Microsoft Dynamics CRM 3.0 Update Rollup 1. This update includes some of the fixes that are in Update Rollup 1. But this update does not include all the fixes that are in Update Rollup 1. You can install this update even if you have not installed Update Rollup 1. For more information about Update Rollup 1, click the following article number to view the article in the Microsoft Knowledge Base:

922815 Update Rollup 1 for Microsoft Dynamics CRM 3.0 is available

<div class="moreinformation_section">

Microsoft Dynamics CRM 3.0
This update for Microsoft Dynamics CRM 3.0 also resolves the problems that are described in the following Microsoft Knowledge Base articles.

Japanese or Chinese versions of Microsoft Dynamics CRM 3.0
This update for the Japanese or Chinese versions of Microsoft Dynamics CRM 3.0 also resolves the problems that are described in the following Microsoft Knowledge Base articles.

Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
This update for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers resolves the problems that are described in the following Microsoft Knowledge Base articles.

<div class="references_section">