none
Health Service Warnings

    Question

  • Hi,

     

    On the SCE 2007 server I'm constantly getting the following two warnings in the Operations Manager event log:

     

    Object enumeration failed

    Query: 'SELECT * FROM SqlService WHERE ServiceName="SQLAgent$SCE"'
     
    Error: 0x80041010
    Details: 

    One or more workflows were affected by this. 
    Workflow name: Microsoft.SQLServer.2005.AgentDiscovery
    Instance name: SCE
    Instance ID: {1DE9688B-F92C-0EE3-8975-7BE8D6E06669}
    Management group: xxx-xxx-xxx

     

    ------------------------------

     

    Object enumeration failed

    Query: 'SELECT * FROM SQLServiceAdvancedProperty WHERE ServiceName = 'MSSQL$SCE' AND PropertyName = 'SPLEVEL''
     
    Error: 0x80041010
    Details: 

    One or more workflows were affected by this. 
    Workflow name: Microsoft.SQLServer.2005.DBEngine.Configuration.ServicePackLevel
    Instance name: SCE
    Instance ID: {1DE9688B-F92C-0EE3-8975-7BE8D6E06669}
    Management group: xxx-xxx-xxx

     

    I suspect it is some issue with the WMI. Can someone help me with this?

     

    Thanks in advance,

    Lubo.

    Thursday, August 30, 2007 11:18 AM

Answers

  • Hi Lubo,

     

    I can't get much out of the error message except the error code 0x80041010 which means class not registered. So I assume there is a problem with the WMI installation on your system.

     

    Following is the normally fixes of this type of error:

    (please PERFORM A COMPLETE SYSTEM BACKUP first)


    1.  Mofcomp.exe %windir%\system32\wbem\cimwin32.mof
    2.  Regsvr32 wbemupgd.dll
    3.  Regsvr32 wbemsvc.dll
    4.  Wmiprvse /regserver

     

    You might also want to reinstall WMI, following those steps:

     

    1. Click Start, Run and type CMD
    2. Type this command and press Enter:  net stop winmgmt
    3. Using Windows Explorer, navigate to %systemroot%\system32\wbem directory and delete the Repository directory. By default, the repository folder is located in
    the C:\Windows\system32\wbem directory.
    4. Switch to Command Prompt window, and type:  net start winmgmt
    5. Re-registering the WMI components:

    The .DLL and .EXE files used by WMI are located in %windir%\system32\wbem. You might need to re-register all the .DLL and .EXE files in this directory.

    If you are running a 64-bit system you might also need to check for .DLLs and .EXE files in %windir%\sysWOW64\wbem.To re-register the WMI components, run the following commands at the command prompt:

    1. cd /d %windir%\system32\wbem
    2. for %i in (*.dll) do RegSvr32 -s %i
    3. for %i in (*.exe) do %i /RegServer

     

    Test in System Information populates after this.

    Proceed with the next steps if System Information not showing.

     

    Note that none of the above two methods restore the missing files related to Windows Management Instrumentation (WMI). So, below is a comprehensive repair procedure that restores all the missing WMI modules. In case of missing WMI modules, you may use the following method.

     

    Comprehensive rebuild method

    1. Insert your Windows XP CD into the drive.

    Important note: If you've installed Service Pack 1 or 2, you need to insert your Windows CD (with Service Pack integration, called as the Slipstreamed
    Windows CD). If you don't have one, you may point to the %Windir%\ServicePackFiles\i386 folder for the updated DLLs required during WMI repair. Or, you may create a Slipstreamed CD, and insert it when prompted.
    2. Click Start, Run and type the following command, and press enter: rundll32.exe setupapi,InstallHinfSection WBEM 132 %windir%\inf\wbemoc.inf
    3. Repair process should take few minutes to complete. Then, restart Windows for the changes to take effect.

     

    Also, if the problem still persists, please check your event viewer for related information, then post them back here or save the Operations Manager section to *.evt files and send to scedata@microsoft.com .

     

    Note:

    Please include the following three lines in the email body:

     

    Health Service Warnings
    http://forums.microsoft.com/TechNet/ShowPost.aspx?postid=2075397&siteid=17
    Guozhen Wang - MSFT

     

    Regarding more information about how to send email to SCEDATA@microsoft.com, please refer to:

     

    How to send files to the Microsoft SCE team for review
    http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1680389&SiteID=17

     

    Post a quick note in the current thread after sending the email.

    Thanks!

     

    -----------------------------
    Sincerely,
    Guozhen Wang
    Microsoft Online Community Support

    Friday, August 31, 2007 8:14 AM