locked
Event ID 11081 SQL 2008 Mirroring Monitor generated from SQL MP 6.3.173.1 - Error: 0x80070057, The parameter is incorrect RRS feed

  • Question

  • Hi,

    SQl Mirroring monitor error, any ideas? What Parameter is incorrect?

    Error initializing discovery data mapper module from config

     Configuration = 
     <Configuration><DiscoverySourceType>0</DiscoverySourceType><DiscoverySourceObjectId>{724C9FC3-B2CF-30EE-D080-1FB24CC06FB4}</DiscoverySourceObjectId><DiscoverySourceManagedEntityId>{F12B6457-215F-76BD-F905-9DCFFC8226A1}</DiscoverySourceManagedEntityId><InstanceType>1</InstanceType><InstanceTypeId>{806F3531-E8CC-9DA8-F0FC-B05E18BD27CB}</InstanceTypeId><SourceRoleSettings><Settings><Setting><Name>{5C324096-D928-76DB-E9E7-E629DCC261B1}</Name><Value>primarysql01.com.au</Value></Setting><Setting><Name>{0F700489-D513-FC14-2FE1-B514BC789F42}</Name><Value>MSSQLSERVER</Value></Setting><Setting><Name>{C815DA4F-5C36-40EE-E39A-DE3532CCDF3E}</Name><Value>MIRRORDBNAMEHERE</Value></Setting></Settings></SourceRoleSettings><TargetRoleSettings><Settings><Setting><Name>{5C324096-D928-76DB-E9E7-E629DCC261B1}</Name><Value>primarysql02.com.au</Value></Setting><Setting><Name>{0F700489-D513-FC14-2FE1-B514BC789F42}</Name><Value>MSSQLSERVER</Value></Setting><Setting><Name>{C815DA4F-5C36-40EE-E39A-DE3532CCDF3E}</Name><Value>MIRRORDBNAMEHERE</Value></Setting></Settings></TargetRoleSettings></Configuration>
     
    Error: 0x80070057 
    Details: The parameter is incorrect.

    Friday, October 12, 2012 6:23 AM

Answers

  • Hi MDS Support,

    you are showing the output from the discovery

     

    <Configuration><DiscoverySourceType>0</DiscoverySourceType><DiscoverySourceObjectId>{724C9FC3-B2CF-30EE-D080-1FB24CC06FB4}</DiscoverySourceObjectId><DiscoverySourceManagedEntityId>{F12B6457-215F-76BD-F905-9DCFFC8226A1}</DiscoverySourceManagedEntityId><InstanceType>1</InstanceType><InstanceTypeId>{806F3531-E8CC-9DA8-F0FC-B05E18BD27CB}</InstanceTypeId><SourceRoleSettings><Settings><Setting><Name>{5C324096-D928-76DB-E9E7-E629DCC261B1}</Name><Value>primarysql01.com.au</Value></Setting><Setting><Name>{0F700489-D513-FC14-2FE1-B514BC789F42}</Name><Value>MSSQLSERVER</Value></Setting><Setting><Name>{C815DA4F-5C36-40EE-E39A-DE3532CCDF3E}</Name><Value>MIRRORDBNAMEHERE</Value></Setting></Settings></SourceRoleSettings><TargetRoleSettings><Settings><Setting><Name>{5C324096-D928-76DB-E9E7-E629DCC261B1}</Name><Value>primarysql02.com.au</Value></Setting><Setting><Name>{0F700489-D513-FC14-2FE1-B514BC789F42}</Name><Value>MSSQLSERVER</Value></Setting><Setting><Name>{C815DA4F-5C36-40EE-E39A-DE3532CCDF3E}</Name><Value>MIRRORDBNAMEHERE</Value></Setting></Settings></TargetRoleSettings></Configuration>

     

    First question: is this the correct data that you are expected to see? Is this data you are sharing related to mirroring? I understand you removed the values, but in your environment, is the right data showing up as expected?

    Also, the management pack guide (download link: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=10631) shows us the following (check section in bold)

    Objects the Management Pack Discovers

    You can use the SQL Server 2008 Mirroring Management Pack to monitor components SQL Server 2008 and SQL Server 2008 R2 Database Mirroring. You can use the Authoring pane of the Operations console to enable discovery of components that are not automatically discovered. For more information about enabling object discovery, see Object Discoveries in Operations Manager 2007 in Operations Manager Help.

      

    You can use the same procedure to override the settings for discovery of any object.

    The SQL Server 2008 Mirroring Management Pack discovers the object types described in the following table. Not all of the objects are automatically discovered. Use overrides to discover those that are not discovered automatically.

            
      

    Category

      
      

    Object type

      
      

    Discovered Automatically

      

    SQL Server Mirroring Component

    SQL Server 2008 Mirroring Database

    Yes

    SQL Server Mirroring Component

    SQL Server 2008 Mirroring Witness

    Yes

    SQL Server Mirroring Component

    SQL Server 2008 Witness Role

    Yes

    SQL Server Mirroring Component

    SQL Server 2008 Mirroring Service

    Yes

    SQL Server Mirroring Component

    SQL Server 2008 Mirroring Group

    Yes

    second question: did you check that the targets for the mirrored databases are showing the data that you are looking for? (that may be related to the info you are showing us, but I don't know your environment so I cannot confirm)

    so, before moving forward on this, we need to have a better idea of what's supposed to be discovered (if it is actually enabled its discovery).

    let's start with those 2 questions, then we'll take it from there.

    Please let me know if you have any question.

    Thanks

    Jose

    • Marked as answer by Yog Li Thursday, November 8, 2012 10:50 AM
    Monday, October 22, 2012 5:12 PM

All replies

  • Hello,

    It seems like a SQL issue. Are you using SCE 2010 to monitor the SQL 2008 Server? Hope the following article can help in this scenario:

    Database Mirroring Monitor Overview
    http://msdn.microsoft.com/en-us/library/ms365809(v=sql.105).aspx

    If you are using SCOM 2007 R2/SCE 2010 to monitor SQL Mirroring, you can try the following MP:

    SQL Server DB Mirroring Management Pack
    http://www.systemcentercentral.com/PackCatalog/PackCatalogDetails/tabid/145/IndexId/68237/Default.aspx

    Thanks,


    Yog Li

    TechNet Community Support

    Monday, October 15, 2012 10:40 AM
  • Hi,

    Using SCE 2007 SP1. SQL MP 6.3.173.1 has monitoring SQL 2008 databases built in and that is what's causing this problem. If I remove the SQL 2008 Mirroring MP the error stops. What's the problem with the MP?

    Are you suggesting I use the MP written by Raphael Burri instead of the Microsoft SQL MP?

    thanks

    Tuesday, October 16, 2012 2:02 AM
  • Hi MDS Support,

    you are showing the output from the discovery

     

    <Configuration><DiscoverySourceType>0</DiscoverySourceType><DiscoverySourceObjectId>{724C9FC3-B2CF-30EE-D080-1FB24CC06FB4}</DiscoverySourceObjectId><DiscoverySourceManagedEntityId>{F12B6457-215F-76BD-F905-9DCFFC8226A1}</DiscoverySourceManagedEntityId><InstanceType>1</InstanceType><InstanceTypeId>{806F3531-E8CC-9DA8-F0FC-B05E18BD27CB}</InstanceTypeId><SourceRoleSettings><Settings><Setting><Name>{5C324096-D928-76DB-E9E7-E629DCC261B1}</Name><Value>primarysql01.com.au</Value></Setting><Setting><Name>{0F700489-D513-FC14-2FE1-B514BC789F42}</Name><Value>MSSQLSERVER</Value></Setting><Setting><Name>{C815DA4F-5C36-40EE-E39A-DE3532CCDF3E}</Name><Value>MIRRORDBNAMEHERE</Value></Setting></Settings></SourceRoleSettings><TargetRoleSettings><Settings><Setting><Name>{5C324096-D928-76DB-E9E7-E629DCC261B1}</Name><Value>primarysql02.com.au</Value></Setting><Setting><Name>{0F700489-D513-FC14-2FE1-B514BC789F42}</Name><Value>MSSQLSERVER</Value></Setting><Setting><Name>{C815DA4F-5C36-40EE-E39A-DE3532CCDF3E}</Name><Value>MIRRORDBNAMEHERE</Value></Setting></Settings></TargetRoleSettings></Configuration>

     

    First question: is this the correct data that you are expected to see? Is this data you are sharing related to mirroring? I understand you removed the values, but in your environment, is the right data showing up as expected?

    Also, the management pack guide (download link: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=10631) shows us the following (check section in bold)

    Objects the Management Pack Discovers

    You can use the SQL Server 2008 Mirroring Management Pack to monitor components SQL Server 2008 and SQL Server 2008 R2 Database Mirroring. You can use the Authoring pane of the Operations console to enable discovery of components that are not automatically discovered. For more information about enabling object discovery, see Object Discoveries in Operations Manager 2007 in Operations Manager Help.

      

    You can use the same procedure to override the settings for discovery of any object.

    The SQL Server 2008 Mirroring Management Pack discovers the object types described in the following table. Not all of the objects are automatically discovered. Use overrides to discover those that are not discovered automatically.

            
      

    Category

      
      

    Object type

      
      

    Discovered Automatically

      

    SQL Server Mirroring Component

    SQL Server 2008 Mirroring Database

    Yes

    SQL Server Mirroring Component

    SQL Server 2008 Mirroring Witness

    Yes

    SQL Server Mirroring Component

    SQL Server 2008 Witness Role

    Yes

    SQL Server Mirroring Component

    SQL Server 2008 Mirroring Service

    Yes

    SQL Server Mirroring Component

    SQL Server 2008 Mirroring Group

    Yes

    second question: did you check that the targets for the mirrored databases are showing the data that you are looking for? (that may be related to the info you are showing us, but I don't know your environment so I cannot confirm)

    so, before moving forward on this, we need to have a better idea of what's supposed to be discovered (if it is actually enabled its discovery).

    let's start with those 2 questions, then we'll take it from there.

    Please let me know if you have any question.

    Thanks

    Jose

    • Marked as answer by Yog Li Thursday, November 8, 2012 10:50 AM
    Monday, October 22, 2012 5:12 PM