Unable to add a performance widget to a dashboard in SCOM 2012

When trying to select a group or object when attempting to configure a new performance widget within a SCOM 2012 dashboard, I get the following error. Anybody any ideas what is causing this issue in my instance of SCOM 2012?

This is part of a custom built Management Pack and a Distributed Application linking just three computers together.

Any help would be welcomed.


Please provide the following information to the support engineer if you have to contact Microsoft Help and Support :

Microsoft.EnterpriseManagement.Presentation.DataAccess.DataAccessDataNotFoundException: Exception reading objects ---> Microsoft.EnterpriseManagement.Common.UnknownDatabaseException: 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.Common.Internal.ServiceProxy.HandleFault(String methodName, Message message)
   at Microsoft.EnterpriseManagement.Common.Internal.EntityObjectsServiceProxy.GetManagedEntitiesByManagedEntityTypesAndCriteriaWithInstanceQueryOptions(IList`1 managedEntityTypeIds, IList`1 managedEntityBaseTypeIds, IList`1 criterias, String languageCode, InstanceQueryOptions instanceQueryOptions)
   at Microsoft.EnterpriseManagement.InstancesManagement.GetObjectsReaderInternal[T](ICollection`1 criteriaCollection, ObjectQueryOptions queryOptions)
   at Microsoft.EnterpriseManagement.Management.DataProviders.ManagedEntityProvider.GetManagedEntitiesByClass(ICollection`1 baseTypeNames, String criteriaString, List`1 valueDefinitions, List`1 sortValueDefinitions, Int32 maxEntities, String typePropertyName, String typeWithIconPropertyName, Boolean propertyCollectionRequested)
   --- End of inner exception stack trace ---
   at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethodInvoker.Invoke()
   at Microsoft.EnterpriseManagement.Monitoring.DataProviders.RetryCommandExecutionStrategy.Invoke(IDataProviderCommandMethodInvoker invoker)
   at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)
   at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.ExecuteInternal[TResult](DataCommand command)
   at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.<ExecuteAsync>b__0[TResult](<>f__AnonymousType0`1 data)

April 20th, 2015 11:10am

Hi,

What kind of SCOM version you use? SP* UR*

Please see if there is performance issue on the database server and check the Event Log on both the management server and the database server. If there is any related error.

Free Windows Admin Tool Kit Click here and download it now
April 21st, 2015 10:36pm

What is your SCOM version and patch level?
For SCOM 2012 SP1, there is known issue that:
When you select objects on the dashboard, you receive the following error message:

 

Microsoft.EnterpriseManagement.Presentation.DataAccess.DataAccessDataNotFoundException: Exception reading objects ---> Microsoft.EnterpriseManagement.Common.UnknownDatabaseException: 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.

This can be resolved by apply UR4
https://support.microsoft.com/en-us/kb/2879276/

Roger

 

April 21st, 2015 11:28pm

Thanks for the reply. We're running SCOM 2012 SP1 with no update rollups applied.
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 3:39am

As per previous reply, pls. update to UR4 which can solve this issue.

Rogfer

April 22nd, 2015 4:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics