none
DPM unable to execute the WQL query RRS feed

  • Question

  • Backup for a SQL server have been failing in DPM recently, while looking at the host agent logs I found the following:

    0544    1F40    12/08    18:16:12.684    31    vsssnapshotrequestor.cpp(624)    [0000000002542D50]        NORMAL    CVssSnapshotRequestor::StartPrepareForBackup [0000000002542D50] m_snapshotInfo.snapshotContext 8388608

    0544    1F40    12/08    18:16:12.737    22    hypervutil.cpp(493)            NORMAL    VMId: 1EBA87CA-470E-4BDD-A909-E236A15932D7, ConfigFileName: 0544    1F40    12/08    18:16:12.738    03    wmiqueryhelper.cpp(145)    [000000000476ED48]        WARNING    Failed: Hr: = [0x80041017] : unable to execute the WQL query: Select ConfigurationDataRoot, ConfigurationFile From Msvm_VirtualSystemSettingData Where ConfigurationID='1EBA87CA-470E-4BDD-A909-E236A15932D7'

    0544    1F40    12/08    18:16:12.738    22    hypervutil.cpp(480)            WARNING    Failed: Hr: = [0x80041017] : Encountered Failure: : lVal : wmiQueryHelper.ExecuteWQLQuery(ssWQLQuery)

    0544    1F40    12/08    18:16:12.738    31    hypervwriterhelperplugin.cpp(882)    [000000000262CA50]        WARNING    Failed: Hr: = [0x80041017] : Encountered Failure: : lVal : HyperVUtil::GetConfigurationFilePath(ssVMId, m_ssFilePathForFileOpenCheck)

    Can someone please tell me what this would affect and what the cause of it might be?


    Edit:

    I used wbemtest.exe as suggested here http://jeffgraves.me/2013/10/22/resolving-error-0x8007007e-cannot-cannect-to-wmi-provider/ and got the following:

    Namespace: \\DPMserver\root\cimv2
    Query...
    Select ConfigurationDataRoot, ConfigurationFile From Msvm_VirtualSystemSettingData Where ConfigurationID='1EBA87CA-470E-4BDD-A909-E236A15932D7'

    Number: 0x80041010
    Facility: WMI
    Description: Invalid class

    • Edited by SystemInsider Tuesday, December 9, 2014 10:24 AM added mroe info
    Tuesday, December 9, 2014 10:05 AM

All replies

  • Hi,

    I don't believe the above is related - that query deals with Hyper-V.  What are the details of the failed SQL recovery point job ?


    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. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, December 9, 2014 7:44 PM
    Moderator
  • I have a DPM agent installed in the VM for the SQL databases and these are backing up OK but not the VM itself. It's the only VM on the server that's been failing so I don't think it's VSS related. I can try and attach log details but it's difficult to see what VM it's working on and where it starts and ends.
    Wednesday, December 10, 2014 9:55 AM
  • Hi,

    Ok - so what are the details of the failed Hyper-v host level backup for that guest ?  Is this a Hyper-v cluster, if so, does it still fail if you move the guest to another host ?  What is the Windows Hyper-V host version and DPM version ?


    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. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, December 10, 2014 3:59 PM
    Moderator
  • It's on a single host which is running on Server 2008 R2 x64. I'm using DPM 2012 R2 and agent version 4.2.1273.0
    Wednesday, December 10, 2014 5:29 PM
  • Hi,

    Thanks for that.  Can you provide the job details from a failed consistency check job for that data source. 


    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. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, December 10, 2014 6:07 PM
    Moderator