RE: Microsoft SQL Server Health and History Tool

From: Umut Nazlica (UmutNazlica_at_discussions.microsoft.com)
Date: 09/22/04


Date: Tue, 21 Sep 2004 23:13:03 -0700

Yes, i also have problems too.

And i think there is a problem with our collation settings. (Which is
Turkish_CI_AS).

Also reports are not working because of that i think. Hate this localization
problems.

I will try on English Locale server and see if it works..

"anonymous@discussions.microsoft.com" wrote:

> Hi All
>
> I am reciving the following error when running the
> Microsoft SQL Server Health and History Tool:
>
> 22/09/2004 1:48:56 PM INFO: version: 8.00.760
> 22/09/2004 1:48:56 PM Status: RUN
> 22/09/2004 1:48:56 PM Status: Initializing
> collector: WMI
> 22/09/2004 1:48:56 PM Status: Running WMI collector
> 22/09/2004 1:48:56 PM Status: Opening Unit 1
> (OS/CS)
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_OperatingSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_ComputerSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_Processor
> 22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
> syntax near 'c09'.
> 22/09/2004 1:48:58 PM Status: Closing Unit 1
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM WARNING: WMI Collector
> encountered critical error. Abandoning Collector.
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM ERROR: test01: Collection
> failed; Error:104; Provider Error: 170
> 22/09/2004 1:48:58 PM ERROR: Critical Repository
> Failure
> 22/09/2004 1:48:58 PM SQLH2 is shutting down
> 22/09/2004 1:48:58 PM Closing Log
>
>
> Has anyone come acrosss this error and can advise.
>
> Thanks
>