locked
Error While creating SQLServer data center dashboard | Please call ManagementGroup.Reconnect() to reestablish the connection. RRS feed

  • Question

  • Hello SCOM Experts

    After providing details while creating, at the end it loads for around 5 to 10 mins and throws up error as below.

    An error occurred executing the command: [Microsoft.SQLServer.Visualization.Library.DataProviders!DatacenterDashboardDataProvider/GetDatacenterDashboardData] in provider: [Microsoft.SQLServer.Visualization.Library.DataProviders.DatacenterDashboardDataProvider, Microsoft.SQLServer.Visualization.Library.DataProviders, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3ds32d364111]. : 
    The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.
       at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)
       at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.ExecuteScalarInternal[TResult](DataCommand command)
       at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.<ExecuteScalarAsync>b__2[TResult](<>f__AnonymousType0`1 data)

    Verified the tables permissions for OpsMgrReader and Write it has Insert, delete, grant permissions.

    Any thoughts on the error please?

    Thanks,

    Rajesh

    Thursday, June 28, 2018 2:27 PM

All replies

  • Hey.

    What version of SCOM are you using? UR level?

    Cheers


    Sam (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" wherever applicable. Thanks!) Blog:AnalyticOps Insights Twitter:Sameer Mhaisekar

    Thursday, June 28, 2018 3:00 PM
  • Hi Sameer,

    SCOM 2012 R2 and UR13.

    Thanks,

    Rajesh

    Thursday, June 28, 2018 4:57 PM
  • Hi All,

    It seems to be working after enabling the aggregation rule in SCOM.

    Thanks,

    Rajesh

    Sunday, September 16, 2018 4:12 PM