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,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.
ThanksYes, 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
>

No comments:

Post a Comment