Monday, February 20, 2012

Microsoft SQL Server Health and History Tool

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,Ca ption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
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,Ca ption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
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
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,Ca ption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
> 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,Ca ption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
> 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
>

No comments:

Post a Comment