locked
OpsMgr 2007 R2 RC and Exchange 2007 Reports RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi
    I have an OpsMgr 2007 RC POC infrastructure setup with all components hosted
    on one server and all is functioning ok except for the Exchange 2007 reports.
    I have import the latest exchange management pack and the reports however
    only two reports render in the Exchange folder in the reporting tab. However
    when I go to the same folder in the SRS view i.e. http://server/reports I can
    see the reports but only when I select detailed view in the SRS view. The
    two reports that render in the OpsMgr console have corresponding rpdl files
    the ones that are missing do not. I suspect this is causing the problem but
    have no idea how to resolve. All other management packs reports are fine and
    render correctly in SRS and the OpsMgr console.

    I'm getting the following on a server restart or after deleting the Exchange Reports folder and importing the management pack again.

    Data Warehouse failed to deploy reports for a management pack to SQL
    Reporting Services Server. Failed to deploy reporting component to the SQL
    Server Reporting Services server. The operation will be retried. Exception
    'SoapException': System.Web.Services.Protocols.SoapException: The Label
    expression for the grouping ‘chart8_CategoryGroup1’ refers to the field
    ‘LocalDate’. Report item expressions can only refer to fields within the
    current dataset scope or, if inside an aggregate, the specified dataset
    scope. at
    Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String
    Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[]
    Properties, Warning[]& Warnings) at
    Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String
    Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[]
    Properties, Warning[]& Warnings) One or more workflows were affected by this.
    Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report
    Instance name: SCOM01.ad2.com Instance ID:
    {4D9EA686-E14B-EEF7-A71C-44B92E4B2D77} Management group: COM-SCOM

    Ideas ?

    --
    Shay
    shay
    Tuesday, May 26, 2009 1:09 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Are you using the Converted Exchange 2007 MP, 6461 and SQL 2008? 
    There is an issue where one of the Exchange 2007 Reports will not load into SQL 2008, this currently under investigation. 
    Unfortunately you will not be able to deploy the Exchange 2007 Reports to your Reporting server until a fix is avialable.
    • Proposed as answer by S. Halsey Wednesday, May 27, 2009 4:14 PM
    Tuesday, May 26, 2009 7:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Are you using the Converted Exchange 2007 MP, 6461 and SQL 2008? 
    There is an issue where one of the Exchange 2007 Reports will not load into SQL 2008, this currently under investigation. 
    Unfortunately you will not be able to deploy the Exchange 2007 Reports to your Reporting server until a fix is avialable.

    Seriously... So the original Exchange 2007 report don't work with RC of R2 .. The Beta release of the Exchange Management Pack for R2 doesn't work with RC release.  What are clients to do about reporting for exchange environments ??.  Is there an eta on a Hotfix.
    shay
    • Proposed as answer by S. Halsey Wednesday, May 27, 2009 4:20 PM
    Wednesday, May 27, 2009 1:55 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    It is an issue between the Exchange 2007 Reports and SQL 2008, if SQL 2005 is used as the reporting server then the reports will deploy with no issues.  There currently is no hotfix available and no ETA on when the issue will be resolved.

    Check out http://blogs.technet.com/momteam/archive/2008/10/23/creating-exchange-2007-availability-reports-using-the-service-level-dashboard-solution-accelerator-and-the-exchange-2007-management-pack.aspx  for an alternative method to create availability reports for the Exchange 2007 Converted MP.

    Please note Operations Manager R2 has a built-in Service Level Objects under Authoring->Management Pack Objects->Service Level Agreements.  You should use these to setup your availability reports for R2 instead of installing the Solution.
    • Proposed as answer by S. Halsey Wednesday, May 27, 2009 4:36 PM
    • Marked as answer by Shay Byrne Wednesday, May 27, 2009 5:37 PM
    Wednesday, May 27, 2009 4:36 PM