1
Vote

Issue with SQLH2 collection

description

Doing the server collection got the following error with version 2.1.4.0:
 
9/12/2009 10:16:39 AM Status: Initializing Target: DBDBAQA201
9/12/2009 10:16:39 AM Status: registering Server
9/12/2009 10:16:39 AM INFO: srv_id = 289; signature = 5808f668-c0b8-4887-8de4-71ed80ceebb2
9/12/2009 10:16:39 AM Status: Scanning Registry on DBDBAQA201
9/12/2009 10:16:39 AM Status: registering instance DBDBAQA201
9/12/2009 10:16:39 AM INFO: inst_id = 1
9/12/2009 10:16:39 AM INFO: version: 9.00.4035.00
9/12/2009 10:16:39 AM Status: RUN
9/12/2009 10:16:39 AM Status: Initializing collector: WMI
9/12/2009 10:16:39 AM Status: Running WMI collector
9/12/2009 10:16:39 AM Status: Opening Unit 1 (OS/CS)
9/12/2009 10:16:39 AM Status: Collecting Win32_OperatingSystem
9/12/2009 10:16:39 AM Status: Collecting Win32_ComputerSystem
9/12/2009 10:16:39 AM Status: Collecting Win32_Processor
9/12/2009 10:16:55 AM Status: Closing Unit 1
9/12/2009 10:16:55 AM Status: Opening Unit 2 (NIC)
9/12/2009 10:16:55 AM Status: Collecting Win32_NetworkAdapter
9/12/2009 10:16:56 AM Status: Collecting Win32_NetworkAdapterConfiguration
9/12/2009 10:16:56 AM Status: Closing Unit 2
9/12/2009 10:16:56 AM Status: Opening Unit 3 (Disk)
9/12/2009 10:16:56 AM Status: Collecting Win32_DiskDrive
9/12/2009 10:16:56 AM Status: Closing Unit 3
9/12/2009 10:16:56 AM Status: Opening Unit 4 (Hotfixes)
9/12/2009 10:16:56 AM Status: Collecting Hotfix Registry
9/12/2009 10:16:56 AM Status: Closing Unit 4
9/12/2009 10:16:56 AM Status: Opening Unit 5 (EventLog files)
9/12/2009 10:16:56 AM Status: Collecting Win32_NTEventlogFile
9/12/2009 10:16:56 AM Status: Closing Unit 5
9/12/2009 10:16:56 AM Status: Opening Unit 6 (Processes)
9/12/2009 10:16:56 AM Status: Collecting Win32_Process
9/12/2009 10:16:57 AM Status: Closing Unit 6
9/12/2009 10:16:57 AM Status: Opening Unit 7 (Products)
9/12/2009 10:16:57 AM Status: Collecting Win32_Product
9/12/2009 10:16:57 AM INFO: SELECT * FROM Win32_Product
9/12/2009 10:16:57 AM ERROR: Invalid class
9/12/2009 10:16:57 AM ERROR: Unit 7 failed
9/12/2009 10:16:57 AM Status: Closing Unit 7
9/12/2009 10:16:57 AM Status: Opening Unit 8 (Services)
9/12/2009 10:16:57 AM Status: Collecting Win32_Service
9/12/2009 10:16:57 AM Status: Closing Unit 8
9/12/2009 10:16:57 AM Status: Initializing collector: EventLog
9/12/2009 10:16:57 AM Status: Initializing collector: SQL
9/12/2009 10:16:57 AM Status: Running SQL collector on DBDBAQA201
9/12/2009 10:16:57 AM Status: Opening Unit 5 (Server Properties)
9/12/2009 10:16:57 AM Status: Closing Unit 5
9/12/2009 10:16:57 AM Status: Opening Unit 1 (Databases)
9/12/2009 10:17:19 AM ERROR: Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
9/12/2009 10:17:19 AM ERROR: Insert dbo.c_database (run_id,srv_id,inst_id,dbid,name,
CompatibilityLevel,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize,SpaceAvailable,IsSystem,
txSize,txSpaceAvailable,txLastBackup,oRecoveryModel,oPageVerify,oUserAccess,
oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdateStat,
oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncateLogOnCheckpoint,
oPublished,oSubscribed,oMergePublished,oMergeSubscribed,
oFullTextEnabled,oDbChaining)
Values (@run_id,@srv_id,@inst_id,@dbid,@name,
@CompatibilityLevel,@CreateDate,@DataSpaceUsage,@IndexSpaceUsage,@dbSize,@SpaceAvailable,@IsSystem,
@txSize,@txSpaceAvailable,@txLastBackup,@oRecoveryModel,@oPageVerify,@oUserAccess,
@oAutoClose,@oAutoShrink,@oAutoCreateStat,@oAutoUpdateStat,
@oOffline,@oReadOnly,@oSelectIntoBulkCopy,@oTruncateLogOnCheckpoint,
@oPublished,@oSubscribed,@oMergePublished,@oMergeSubscribed,
@oFullTextEnabled,@oDbChaining)
9/12/2009 10:17:19 AM ERROR: Unit 1 failed
9/12/2009 10:17:19 AM Status: Closing Unit 1
9/12/2009 10:17:19 AM ERROR: Insert dbo.c_database (run_id,srv_id,inst_id,dbid,name,
CompatibilityLevel,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize,SpaceAvailable,IsSystem,
txSize,txSpaceAvailable,txLastBackup,oRecoveryModel,oPageVerify,oUserAccess,
oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdateStat,
oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncateLogOnCheckpoint,
oPublished,oSubscribed,oMergePublished,oMergeSubscribed,
oFullTextEnabled,oDbChaining)
Values (@run_id,@srv_id,@inst_id,@dbid,@name,
@CompatibilityLevel,@CreateDate,@DataSpaceUsage,@IndexSpaceUsage,@dbSize,@SpaceAvailable,@IsSystem,
@txSize,@txSpaceAvailable,@txLastBackup,@oRecoveryModel,@oPageVerify,@oUserAccess,
@oAutoClose,@oAutoShrink,@oAutoCreateStat,@oAutoUpdateStat,
@oOffline,@oReadOnly,@oSelectIntoBulkCopy,@oTruncateLogOnCheckpoint,
@oPublished,@oSubscribed,@oMergePublished,@oMergeSubscribed,
@oFullTextEnabled,@oDbChaining)
9/12/2009 10:17:19 AM ERROR: DBDBAQA201: Collection failed; Error:StorSyntaxErrorNonQuery; Provider Error: 8115
9/12/2009 10:17:19 AM ERROR: Critical Repository Failure
9/12/2009 10:17:19 AM SQLH2 is shutting down
9/12/2009 10:17:19 AM Closing Log

comments