Donnerstag (Thursday) Does Not Appear in German Version of Weekly Reports

• Microsoft Site Server version 3.0

SYMPTOMS

When you use the German version of ReportWriter, all Chart types with the weekdays on the (x) axis do not show "Donnerstag" (Thursday).

CAUSE

In MSUsage.mdb the Weekday field is defined as char(9), which does not contain enough room for "Donnerstag."

RESOLUTION

To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, please see the following article in the Microsoft Knowledge Base:

Q219292 How to Obtain the Latest Site Server 3.0 Service Pack

WORKAROUND

To work around this problem, change the MSUsage.mdb database to have char(10) for the Weekday field. Databases created from now on will work correctly.

German users can run the following SQL Server script to upgrade existing SQL Server databases:

CREATE TABLE tblRefWeekday(WeekdayID Int IDENTITY, WeekdayName char (10) NULL)

Set Identity_Insert tblRefWeekday ON

INSERT INTO tblRefWeekday(WeekdayID, WeekdayName)
SELECT WeekdayID, WeekdayName FROM tblReferenceWeekday

Set Identity_Insert tblRefWeekday OFF

Update tblRefWeekday SET WeekdayName = 'Donnerstag' WHERE WeekdayName = 'Donnersta'

DROP TABLE tblReferenceWeekday

EXECUTE sp_rename tblRefWeekday, tblReferenceWeekday

ALTER TABLE tblReferenceWeekday Add CONSTRAINT xWeekdayID PRIMARY KEY CLUSTERED (WeekdayID) 

STATUS

This problem was first corrected in Site Server 3.0 Service Pack 3.

Additional query words: hotfix hot fix qfe quick engineering patch

Keywords : SS3SP3Fix
Version : winnt:3.0
Platform : winnt
Issue type : kbbug