locked
Exception reading objects RRS feed

  • Question

  • Got this error on Exchange database state dashboard. The error text is below. Can anyone advise?
    • Moved by Daniele Muscetta Tuesday, November 4, 2014 6:00 AM not an APM question
    Monday, November 3, 2014 12:29 PM

Answers

All replies

  • 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.InvalidCriteriaException: The criteria used for the query has a character or keyword that is not valid. The following parse error was returned: Parse error before , ---> Microsoft.EnterpriseManagement.Common.QueryGrammarException: Parse error before ,
       at Microsoft.EnterpriseManagement.Mom.QueryGrammar.QueryGrammarYaccClass.error(Int32 q_state, SSLexLexeme q_look)
       at Microsoft.EnterpriseManagement.Mom.QueryGrammar.SSVParseLib.SSYacc.parse()
       at Microsoft.EnterpriseManagement.Mom.QueryGrammar.QueryGrammarParser.GetCriteriaXml(String query)
       at Microsoft.EnterpriseManagement.Common.QueryCriteriaHelper.GetParseTree(String criteria)
       --- End of inner exception stack trace ---
       at Microsoft.EnterpriseManagement.Common.QueryCriteriaHelper.GetParseTree(String criteria)
       at Microsoft.EnterpriseManagement.Common.QueryCriteria`1.ParseCriteria(ManagementPackClass monitoringClass, Boolean validateProperties)
       at Microsoft.EnterpriseManagement.Management.DataProviders.ManagedEntityProvider.GetMonitoringObjectsFromListAndCriteria(IDataObjectCollection targetEntities, String criteriaString, List`1 valueDefinitions, List`1 sortValueDefinitions)
       at Microsoft.EnterpriseManagement.Management.DataProviders.ManagedEntityProvider.GetContainedManagedEntities(IDataObjectCollection targetEntities, ICollection`1 recursionTypeNames, ICollection`1 baseTypeNames, String criteriaString, List`1 valueDefinitions, List`1 sortValueDefinitions, 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)

    Monday, November 3, 2014 12:29 PM
  • Hi,

    Here is a similar thread, the resolution in it is to uncheck all the checkbox in the Specify the criteria section of the state widget. Please try it.

    https://social.technet.microsoft.com/Forums/systemcenter/en-US/08f6c63a-e8ce-4aee-ba9a-eeca162b92fa/scom-2012-exception-the-criteria-used-for-the-query-has-a-character-or-keyword-that-is-not-valid?forum=operationsmanagergeneral

    Regards,

    Yan Li


    Regards, Yan Li

    • Marked as answer by Yan Li_ Wednesday, November 12, 2014 8:58 AM
    Tuesday, November 4, 2014 8:22 AM
  • Try to update SCOM for UR4 which fix this issue.

    http://blogs.technet.com/b/scom_atlas/archive/2013/10/22/scom-2012-sp1-ur4-is-out.aspx


    Please remember, if you see a post that helped you please click "Vote As Helpful" and if it answered your question, please click "Mark As Answer" Mai Ali | My blog: Technical | Twitter: Mai Ali

    • Marked as answer by Yan Li_ Wednesday, November 12, 2014 8:58 AM
    Tuesday, November 4, 2014 11:10 AM