SQL MP Summary Dashboard Error RRS feed

  • Question

  • We're getting the following error when opening the "Summary" dashboard:

    An error occurred executing the command: [Microsoft.SQLServer.Visualization.Library.DataProviders!ResolveGUIDsDataProvider/GetResolvedGUIDsData] in provider: [Microsoft.SQLServer.Visualization.Library.DataProviders.ResolveGUIDsDataProvider, Microsoft.SQLServer.Visualization.Library.DataProviders, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

       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)

    Monday, September 12, 2016 1:18 PM

All replies

  • Hi Hope you need to patch the SCOM , this issue has been fixed in SCOM 2012 SP1 UR4 https://blogs.technet.microsoft.com/scom_atlas/2013/10/22/scom-2012-sp1-ur4-is-out/ 
    Friday, November 11, 2016 3:56 PM