Unable to generate the reports
Hii,,
Scenario:
Windows 2008 R2
SCOM 2007 R2 and SQL 2008 SP1 on different servers.
Issue:
SCOM reportingis not working and giving below error.
Error:
Cannot initialize report. Failed to load expression host assembly.
Details:
Note: The following information was gathered when the operation was attempted. The information may appear cryptic but provides context for the error. The application will continue to run.
Microsoft.Reporting.WinForms.ReportServerException: Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral' or one of its dependencies. The located
assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (rsErrorLoadingExprHostAssembly)
at Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WinForms.ServerReport.GetParameters()
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)
I can access
http://localhost/reports and
http://localhost/reportserver from the SQL nad RMS also.
When trying to generate the reports from above mentioned link from SQL server, I got below error,
Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral'
or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (rsErrorLoadingExprHostAssembly)
Please Suggest.Regards, Syed Fahad Ali
March 28th, 2011 9:26am
Thnx for your response. As I replaced the Microsoft.EnterpriseManagement.Reporting.Code.Dll for System Center Service Manager Installation requirement, now after replacing with default one my issue has been resolved and SCOM reporting is working fine.
But now I am facing issues in SM reporting and I will post the issue on Service Manager Forum.Regards, Syed Fahad Ali
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 10:14am