locked
Exchange 2013 Summary views error - System.InvalidOperationException: Sequence contains no matching element RRS feed

  • Question

  • Hello Everyone,

    Environment:

    SCOM 2012 R2 UR8

    Management packs:

    Microsoft Exchange Server 2013 Monitoring 15.0.668.20

    Microsoft Exchange Server 2013 Reports 15.0.668.20

    Microsoft Exchange Server 2013 Visualization Library 1.1.124.91

    Description:

    When selecting either the Organization Summary or the Server Summary view as a standard SCOM operator user role the view shows the following error:

    Complete Error:

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

    Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderException: An error occurred executing the command: [Microsoft.Exchange.15.Visualization.Components.DataProviders!GridDataProvider/GetServerGridData] in provider: [Microsoft.Exchange15.Visualization.Components.DataProviders.GridDataProvider, Microsoft.Exchange.15.Visualization.Components.DataProviders, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : Sequence contains no matching element ---> System.InvalidOperationException: Sequence contains no matching element
       at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)
       at Microsoft.Exchange15.Visualization.Components.DataProviders.GridDataProvider.GetServerGridData(IDataObject organization, DateTime startTime, DateTime endTime, String connectionTicket)
       --- End of inner exception stack trace ---
       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)

    Additional info:

    • When checking the view with an account that has SCOM administrator privileges there is no error and the data is displayed.
    • Tracing on the SQL side revealed that there are 2 stored procedures responsible for getting the information: Microsoft_Exchange_15_Visualization_Components_GetOrganizationGridData
      Microsoft_Exchange_15_Visualization_Components_GetServerGridData
    • Both procedures execute successfully and return objects in roughly 4 seconds, independently of the user account used (queries are executed using the data access account). Seems that the data returned is mapped and displayed by the application layer but somehow for a standard user it fails.

    Any help or suggestion is welcomed! Thanks!


    http://mariusene.wordpress.com/

    Thursday, August 11, 2016 2:21 PM

Answers

  • I guess I was in a hurry to post this issue on the forums. This behavior is generated because the user role uses some specific group scoping. Its a matter of identifying the objects (groups) where to apply the permissions.

    http://mariusene.wordpress.com/

    • Proposed as answer by Elton_Ji Saturday, August 13, 2016 11:14 AM
    • Marked as answer by Elton_Ji Sunday, August 14, 2016 2:52 PM
    Thursday, August 11, 2016 4:00 PM

All replies

  • I guess I was in a hurry to post this issue on the forums. This behavior is generated because the user role uses some specific group scoping. Its a matter of identifying the objects (groups) where to apply the permissions.

    http://mariusene.wordpress.com/

    • Proposed as answer by Elton_Ji Saturday, August 13, 2016 11:14 AM
    • Marked as answer by Elton_Ji Sunday, August 14, 2016 2:52 PM
    Thursday, August 11, 2016 4:00 PM
  • Hi Marius

    Off topic abit here, can you confirm in the current version you are running "15.0.668.20" the issue where the Mailbox Database Copy state was Not Monitored is now resolved? along with the issue on the Exchange 2013 Service Components also being Not Monitored (Availability, Configuration, Performance and Security).

    Thanks

    Tuesday, October 4, 2016 10:18 AM