WMI related errors in loading up SQL perf data
Hi I have enrolled on of my production server in SQL UCP. It created jobs to collect the perf details and upload to central database. One of those SQL job is failing with below error and SQL guys said its a WMI related errors. Exception : System.Management.ManagementException: Invalid class at System.Management.ManagementException.ThrowWithExt endedInfo(ManagementStatus errorCode) at System.Management.ManagementObjectCollection.Manag ementObjectEnumerator.MoveNext() at Microsoft.PowerShell.Commands.GetWmiObjectCommand. BeginProcessing() TargetObject : CategoryInfo : InvalidOperation: (:) [Get-WmiObject], ManagementExcepti on FullyQualifiedErrorId : GetWMIManagementException,Microsoft.PowerShell.Commands. GetWmiObjectCommand ErrorDetails : InvocationInfo : System.Management.Automation.InvocationInfo PipelineIterationInfo : {0, 0} WARNING : 1/19/2011 10:03:49 AM : MyCommand : Get-WmiObject BoundParameters : {[Filter, IDProcess = '1456'], [Class, Win32_PerfRawData_Perf Proc_Process]} UnboundArguments : {} ScriptLineNumber : 716 OffsetInLine : 21 HistoryId : -1 ScriptName : Line : (Get-WmiObject Win32_PerfRawData_PerfProc_Process -filt er "IDProcess = '$processId'") | PositionMessage : At line:716 char:21 + (Get-WmiObject <<<< Win32_PerfRawData_PerfProc_Proce ss -filter "IDProcess = '$processId'") | InvocationName : Get-WmiObject PipelineLength : 1 PipelinePosition : 1 ExpectingInput : False CommandOrigin : Internal WARNING : 1/19/2011 10:03:49 AM : 00000000000000000000000000000000000000000000000000000000000000000000000000000000 WARNING : 1/19/2011 10:03:49 AM : ErrorInformation : System.Management.ManagementBaseObject ErrorCode : InvalidClass Message : Invalid class Data : {} InnerException : TargetSite : Void ThrowWithExtendedInfo(System.Management.ManagementStatus ) StackTrace : at System.Management.ManagementException.ThrowWithExtended Info(ManagementStatus errorCode) at System.Management.ManagementObjectCollection.Management ObjectEnumerator.MoveNext() at Microsoft.PowerShell.Commands.GetWmiObjectCommand.Begin Processing() HelpLink : Source : System.Management ERROR : 1/19/2011 10:03:49 AM : Caught exception while collecting cpu properties. A WMI query might have failed.WARNING : 1/19/2011 10:03:49 AM : Error occurred during execution of script. WARNING : 1/19/2011 10:03:49 AM : Transaction will be rolled back. WARNING : 1/19/2011 10:03:49 AM : PSMessageDetails : Exception : Microsoft.PowerShell.Commands.WriteErrorException: 1/19/ 2011 10:03:49 AM : Caught exception while collecting cpu properties. A WMI query might have failed. TargetObject : CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write- ScriptError ErrorDetails : InvocationInfo : System.Management.Automation.InvocationInfo PipelineIterationInfo : {0, 0} WARNING : 1/19/2011 10:03:49 AM : MyCommand : Write-ScriptError BoundParameters : {[object, Caught exception while collecting cpu properties. A WMI query might have failed.]} UnboundArguments : {} ScriptLineNumber : 752 OffsetInLine : 24 HistoryId : -1 ScriptName : Line : Write-ScriptError "Caught exception while collecting cp u properties. A W... Process Exit Code -1. The step failed. Can some one help me in troubleshooting for this error OS: WINDOWS 2K8 R2 (64 bit) SQL: SQL 2K8 R2. Please let me know if you need more details. Jyothi
January 19th, 2011 2:55pm

Hi, According to the problem description, this is a SQL Server related issue. I would like to suggest you submit a new question to SQL Server forum which is the best resource SQL Server related issue. SQL Server http://social.technet.microsoft.com/Forums/en-us/category/sqlserver Regards,Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2011 12:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics