Analysis Imports No Data and Import History Manager Reports First Request Date as 1/1/2035 (221752)

SYMPTOMS

When you use Usage Import to import your Internet Information Server (IIS) log files, a message similar to the following may occur:

Import complete
0 requests imported
0 Bytes is the log size imported
It took 4 seconds

The Import History Manager may also display the Action for this import as Aborted or the First Request as having either no date or the date 1/1/2035.

CAUSE

The date string in your log file is in a format that Analysis cannot import correctly. This can be caused by the language specified in the regional settings of your Microsoft Windows NT Server computer.

RESOLUTION

To resolve this issue, change your regional settings to English (United States) using the following steps:

Click Start, point to Settings, click Control Panel, and double- click Regional Settings.
In the drop-down list, change the language setting to English (United States).
Click the "Set as system default locale" check box to enable it.
Click OK, and then restart your computer.

Note: The above steps are required for IIS to change the date string format in its log files. This will not work if you are using the Microsoft IIS Log File Format. If you must use the Microsoft IIS Log File Format, the only workaround is as follows.

WORKAROUND

To work around this issue, pre-process the log files using the following steps:

Open the log file using a text editor, such as Notepad.
Search and replace all the date strings with the following format:

MM/DD/YY

For example, replace all 99-02-01 with 02/01/99.
Save the new log file and import it using Usage Import.

MORE INFORMATION

This issue can occur when your Microsoft Windows NT Server computer is configured to use the French (Canadian) language for its Regional Settings. Microsoft Site Server Analysis is designed to recognize the MM/DD/YY format for date strings as the most common format.