Every Created Object Is One Hour Ahead Of or Behind Server Clock (322283)


The information in this article applies to:

  • Microsoft Content Management Server 2001 SP1
This article was previously published under Q322283

SYMPTOMS

The time for all objects such as pages, postings, and resources that are created in the Content Management Server (CMS) database by using either the Web Author Client or the Site Builder is exactly one hour ahead or behind. The time will be off based on the system clock under the computer that is running Microsoft SQL Server and the CMS database.

RESOLUTION

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Content Management Server 2001 service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The typical support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix has the file attributes (or later) 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 tool in Control Panel.
   Date         Time   Size  File name
   ------------------------------------------------------
   16-May-2002  09:26  1 KB  Hotfix106.sql
NOTE: Because of file dependencies, this update requires Content Management Server 2001 Service Pack 1.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Content Management Server 2001.

MORE INFORMATION

This fix is a SQL script. To install the fix, follow these steps:
  1. Make sure that no one is using the CMS server, and then stop the IIS Admin service with the command-line command Net Stop IISAdmin.
  2. Back up the CMS database.
  3. Run the SQL script for this fix by using Query Analyzer for SQL Server against the CMS database and confirm that no errors are returned.
  4. Start the IIS Admin Service and associated services, such as W3SVC and FTP.
  5. Verify that the everything is working.
NOTE: If you find any problems, restore the backup database. Otherwise, this fix solves the problem.

Steps to Reproduce the Behavior

  1. Install CMS with SQL Server 7.0 (the service pack is irrelevant) as the database platform.
  2. Upgrade the SQL Server platform to SQL Server 2000 (again, the service pack is irrelevant). Make no changes to the CMS database. The problem at this point is latent. The problem starts when daylight savings time starts. If the time moves one hour back, all CMS objects that are created from this point on look as if they were created one hour ahead, and vice versa (that is, if the time moves forward, objects appear to be delayed by one hour). This only affects objects that are created from this point on and does not affect objects that already exist.
Modification Type:MinorLast Reviewed:10/10/2005
Keywords:kbHotfixServer kbQFE kbbug kbContentMgtServ2001preSP2fix kbfix KB322283
©2004 Microsoft Corporation. All rights reserved.