none
SCOM 2012 R2 Report module empty RRS feed

  • General discussion

  • Hello SCOM admin,


    My report module has been empty since the DBA team downgraded SQL. I am not sure what is the exact problem, but I'll try to provide as much information as possible.


    Architecture :

    • SCOM 2012 R2
    • SSRS server with Reporting module installed on
    • SQL server contains the database

    Reporting server status : Scale-out Deployment server is joined

    My report server respond to http://reportserver/SCOMreports but it display no reports. I do see a folder called Microsoft.SystemCenter.DataWarehose.Report.Library, however it contains some RES. xxxx that I can't do anything with.

    Microsoft SQL LOGS

    processing!ReportServer_0-9!1b88!09/25/2015-12:08:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportPublishingException: , Microsoft.ReportingServices.ReportProcessing.ReportPublishingException: Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportPublishingException' was thrown.;
    library!ReportServer_0-9!1b88!09/25/2015-12:09:03:: i INFO: Call to ListChildrenAction(/, False).
    library!ReportServer_0-9!f28!09/25/2015-12:09:04:: i INFO: Call to ListChildrenAction(/Microsoft.Exchange.15.Reports, False).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:04:: i INFO: Call to ListChildrenAction(/Microsoft.SystemCenter.ClientMonitoring.Views.Internal, False).
    library!ReportServer_0-9!f28!09/25/2015-12:09:04:: i INFO: Call to ListChildrenAction(/Microsoft.SystemCenter.DataWarehouse.Report.Library, False).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:04:: i INFO: Call to ListChildrenAction(/Microsoft.SystemCenter.DataWarehouse.ServiceLevel.Report.Library, False).
    library!ReportServer_0-9!f28!09/25/2015-12:09:04:: i INFO: Call to ListChildrenAction(/Microsoft.Windows.BranchCache.Reports, False).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:04:: i INFO: Call to ListChildrenAction(/Microsoft.Windows.Server.LDS.Library, False).
    library!ReportServer_0-9!f28!09/25/2015-12:09:04:: i INFO: Call to ListChildrenAction(/Microsoft.Windows.Server.Reports, False).
    library!ReportServer_0-9!f28!09/25/2015-12:09:14:: i INFO: Call to ListChildrenAction(/, False).
    library!ReportServer_0-9!f28!09/25/2015-12:09:14:: i INFO: Call to ListChildrenAction(/Microsoft.Exchange.15.Reports, False).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.DWScript.GetPerformanceTop.DropScript, application/octet-stream).
    library!ReportServer_0-9!f28!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.MailboxStatistics.ReportDefinition, application/octet-stream).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.DWScript.GetPerformance.InstallUpdateScript, application/octet-stream).
    library!ReportServer_0-9!f28!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.DWScript.GetRelatedRules.InstallUpdateScript, application/octet-stream).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.DWScript.MailboxStatsTop.DropScript, application/octet-stream).
    library!ReportServer_0-9!f28!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.DWScript.GetPerformanceTop.InstallUpdateScript, application/octet-stream).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.DWScript.GetRelatedRules.DropScript, application/octet-stream).
    library!ReportServer_0-9!f28!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.DWScript.MailboxStatsTop.InstallUpdateScript, application/octet-stream).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.GenericPerformanceTop.ReportDefinition, application/octet-stream).
    library!ReportServer_0-9!f28!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.GenericPerformance.ReportDefinition, application/octet-stream).
    library!ReportServer_0-9!bd0!09/25/2015-12:09:14:: i INFO: Call to SetResourceContentsAction(/Microsoft.Exchange.15.Reports/Microsoft.Exchange.15.Reports.DWScript.GetPerformance.DropScript, application/octet-stream).
    library!ReportServer_0-9!f28!09/25/2015-12:09:15:: i INFO: Call to CreateReportAction(Microsoft.Exchange.15.Reports.GenericPerformanceTop.Report, /Microsoft.Exchange.15.Reports, True).
    processing!ReportServer_0-9!f28!09/25/2015-12:09:15:: e ERROR: Error while loading code module: ‘Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral’. Details: Could not load file or assembly 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)
    System.IO.FileLoadException: Could not load file or assembly 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)
    File name: 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ---> System.Security.Policy.PolicyException: Required permissions cannot be acquired.
       at System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission)
       at System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission)
       at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
       at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
       at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
       at System.Reflection.Assembly.Load(String assemblyString)
       at Microsoft.ReportingServices.Diagnostics.AssemblyLocationResolver.LoadAssemblyAndResolveLocation(String name)
       at Microsoft.ReportingServices.RdlExpressions.ExprHostCompiler.ResolveAssemblylocations(List`1 codeModules, CompilerParameters options, ErrorContext errorContext, AppDomain compilationTempAppDomain)


    Event Viewer log on SCOM server

    Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried.
    Exception 'DeploymentException': Failed to deploy reports for management pack with version dependent id '555d9e1-52d9-8bb7-b4f9-b2ccf1181a3e'. Failed to deploy report 'Microsoft.Windows.BranchCache.Report.IISBandwidthSavings'. Error while loading code module: ‘Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral’. Details: Could not load file or assembly 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417) 
    
    One or more workflows were affected by this.  
    
    Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report 
    Instance name: Data Warehouse Synchronization Service 
    Instance ID: {13A33971-7bbC-Dc17-7eE8-9460qwtr2557} 
    Management group: ABC Management group

    Thank you,

    PS* I am unable to post screenshot because I am unable to verify my account...






    • Edited by admnoobie Friday, September 25, 2015 8:52 PM
    Friday, September 25, 2015 6:10 PM

All replies

  • I believe I might have to create a new datasource for my SCOM server? But I am unable to find proper information regarding this and SCOM installation guide doesn't seem to treat this aspect.
    Friday, September 25, 2015 6:27 PM
  • This looks to be a permissions issue, make sure you SSRS service is running with the SCOM Data Reader account which was set up in SCOM, also check your SSRS configuration on the SQL server, the execution account to also be set to this account

    Faizan

    Sunday, September 27, 2015 8:53 AM
  • Just to be sure, I have 2 Run as Configuration Accounts

    1. Data Warehouse Action Account = Bobby

    2. Data Warehouse Report Deployment = Alice

    On my Reporting Server, I have 2 other accounts,

    3. Service account for SCOM Reporting services = Charlie

    4. Execution account which is also DBO of SCOM database = Diego

    So... I would need to change the service account Charlie and the execution account to Alice ?


    • Edited by admnoobie Monday, September 28, 2015 3:57 PM
    Monday, September 28, 2015 3:56 PM
  • Yes, execution should be Alice

    for more details pl. refer this link http://jimmoldenhauer.blogspot.co.uk/2012/11/sql-2008r2-configuring-ssrs-for-scom.html


    Faizan

    Tuesday, September 29, 2015 8:18 PM