none
Reporting fails to load. RRS feed

  • Question

  • Hi

    Since upgrading to DPM 2012R2 reporting no longer works. When I try to open a report IE launches but all I get is an error message as follows:

    "Failed to load expression host assembly. Details: Could not load file or assembly 'ReportSRV4, Version=1.0.523.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingExprHostAssembly)"

    I have searched around but can't find an answer to this. Everything else working fine. Anyone else encountered this?

    Thanks

    Richard

    Tuesday, December 17, 2013 2:41 PM

Answers

  • Hi,

    I upgraded our DPM 2012 SP1 server.  This entailed upgrading the operating system to Server 2012 SP1 and SQL to SQL 2012 SP1.  SQL in our case is also installed on the DPM server.  We encountered the same issue you did.  To resolve (and because we had upgraded SQL) we were able to locate the file in the old SSRS instance folder and copy it to the new SSRS instance folder.  We waited about five minute and presto the reports worked again.

    Copied ReportSRV4.dll from: 

    Old SSRS instance folder: C:\Program Files\Microsoft System Center 2012\DPM\SQL\MSRS10_50.MSDPM2012\Reporting Services\ReportServer\bin to:

    New SSRS instance folder: C:\Program Files\Microsoft System Center 2012\DPM\SQL\MSRS11.MSDPM2012\Reporting Services\ReportServer\bin

    I hope this is of help to someone. Regards

    • Marked as answer by stafford7 Wednesday, September 10, 2014 10:38 AM
    Tuesday, September 9, 2014 6:31 AM

All replies

  • Hi

    is your SSRS working correctly? I also upgraded without an issue. 

    Any errors logged regarding reporting?

    Thursday, December 19, 2013 4:52 AM
  • I'm getting the same error after upgrading SQL 2008 r2 to 2012 sp1. I'm also trying to upgrade DPM 2012 SP1 to R2 but getting an error on the prerequisite check.

    Did you find a solution?



    • Edited by Tim Boothby Thursday, February 6, 2014 4:03 PM typo
    Thursday, February 6, 2014 3:47 PM
  • Very sorry not able to help. Never have found a sloution. Not a critical feature for me so I haven't really spent much time on the issue.

    Unsure as to whether it is an SQL problem or a DPM problem. I am a general network technician so not expert in either.

    Might come back to it later when workload allows. Hope you find an answer to your problem.

    Richard

    Monday, February 10, 2014 11:03 AM
  • On the server hosting the SQL Reporting Services for DPM can you verify that there is a file called "ReportSRV4.resources.dll" inside the folder "\Reporting Services\ReportServer\bin" for your SQL Instance?

    As an example;

    C:\Program Files\Microsoft SQL Server\MSRS11.DPM\Reporting Services\ReportServer\bin\ReportSRV4.dll

    There should also be several subfolders for each localization, for example:

    C:\Program Files\Microsoft SQL Server\MSRS11.DPM\Reporting Services\ReportServer\bin\sv-SE\ReportSRV4.resources.dll

    Let us know if these exists or not and we can continue from there.

    Kind regards,

    Tobias


    • Edited by .Tobias Nilsson Monday, February 10, 2014 4:21 PM Filename Error
    Monday, February 10, 2014 4:16 PM
  • You can reinstall Reporting.
    http://scdpm.blogspot.ru/2012/03/dpm-reporting-fails-after-server.html


    Have a nice day !!!

    Tuesday, February 11, 2014 6:15 AM
    Moderator
  • Hi,

    Thanks all, in the end the only way I could get DPM reinstalled and working was a reinstall of Windows.

    Tim

    Tuesday, February 11, 2014 3:25 PM
  • Hi,

    I upgraded our DPM 2012 SP1 server.  This entailed upgrading the operating system to Server 2012 SP1 and SQL to SQL 2012 SP1.  SQL in our case is also installed on the DPM server.  We encountered the same issue you did.  To resolve (and because we had upgraded SQL) we were able to locate the file in the old SSRS instance folder and copy it to the new SSRS instance folder.  We waited about five minute and presto the reports worked again.

    Copied ReportSRV4.dll from: 

    Old SSRS instance folder: C:\Program Files\Microsoft System Center 2012\DPM\SQL\MSRS10_50.MSDPM2012\Reporting Services\ReportServer\bin to:

    New SSRS instance folder: C:\Program Files\Microsoft System Center 2012\DPM\SQL\MSRS11.MSDPM2012\Reporting Services\ReportServer\bin

    I hope this is of help to someone. Regards

    • Marked as answer by stafford7 Wednesday, September 10, 2014 10:38 AM
    Tuesday, September 9, 2014 6:31 AM
  • This totally worked.

    Brilliant simple fix.

    Thanks for Sharing.

    Richard

    Wednesday, September 10, 2014 10:39 AM
  • I had the same problem and this simple fix solved it for me. Thanks!
    • Edited by Musoke Tuesday, September 1, 2015 9:56 AM
    Tuesday, September 1, 2015 9:56 AM
  • I can confirm this procedure works for SCSM 2012.

    After an in-place upgrade of our SCSM 2012 R2 UR9 environment (from Windows Server 2008 R2 to 2012 R2 and from SQL Server 2008 R2 SP2 to 2012 SP3) I had this problem with the reporting module in the console. The file that could not be found in the case of SCSM was Microsoft.EnterpriseManagement.Reporting.Code.dll; however, following this advice led me to the location of the file from the old instance, and after copying it to the new instance folder, everything is working.

    Thank you!

     
    Thursday, January 5, 2017 5:56 PM
  • thanks a LOT, it really works , is in the case when you do a update-inplace..best regards
    Wednesday, July 12, 2017 5:23 PM