Products
Webtrends Analytics 8.x
Webtrends Analytics 9.x
Issue
The following message displays in the status logs:
WARNING: Error populating WT_AnalysisTime tableUndefined error
Cause
This results when the language for the database service account is set to British English or some other language other than English. When this occurs the conversion of a char data type to a datetime data type results in an out-of-range datetime value.
Resolution
To resolve this issue, log into Microsoft Management Studio and perform the steps below:
1. Navigate to Security > Logins.
2. Right-click on the Webtrends service user account and select “Properties.”
3. Under General, ensure that the default language set to “English” then select OK to save the changes.
Further information:
How do I install the stand-alone version of SQL Server 2008 Management Studio?