Forum Discussion

Ccparkhill's avatar
Ccparkhill
Icon for Helper II rankHelper II
8 years ago
Solved

August release - Failed to load expression host assembly

I'm receiving the following errror on a number of SSRS reports using the August 2018 release: Failed to load expression host assembly. Details: Could not load file or assembly 'Micros...
Power BI Report Server
  • jtarquino's avatar
    jtarquino
    8 years ago

    Thanks a lot for your patience and help to diagnose the issue

    For your reference this is the entire assemblyBinding section for the two files in a clean install of PBIRS, after you udpate them you need to restart the service as some of you have mentioned and it should fix your issue.

     

    "C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\web.config"

     

        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral" />
        <bindingRedirect oldVersion="8.0.242.0-2018.8.0.0" newVersion="2018.8.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" publicKeyToken="89845dcd8080cc91" culture="neutral" />
        <bindingRedirect oldVersion="9.0.242.0-2018.8.0.0" newVersion="2018.8.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.ProcessingObjectModel" publicKeyToken="89845dcd8080cc91" culture="neutral" />
        <bindingRedirect oldVersion="9.0.242.0-2018.8.0.0" newVersion="2018.8.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.SqlServer.Types" publicKeyToken="89845dcd8080cc91" culture="neutral" />
        <bindingRedirect oldVersion="10.0.0.0-15.0.0.0" newVersion="14.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="msmgdsrv" publicKeyToken="89845dcd8080cc91" />
        <bindingRedirect oldVersion="9.0.0.0-15.0.0.0" newVersion="15.0.0.0" />
        <codeBase version="15.0.0.0" href="%ProgramFiles%\Microsoft Analysis Services\AS OLEDB\150\msmgdsrv.dll" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.Owin" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Cors" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-5.0.0.0" newVersion="5.2.3.0" />
      </dependentAssembly>
    </assemblyBinding>

    "C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\ReportingServicesService.exe.config"

     

        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <probing privatePath="bin" />
      <dependentAssembly>
        <assemblyIdentity name="ReportingServicesAppDomainManager"
                          publicKeyToken="89845dcd8080cc91"
                          culture="neutral" />
        <bindingRedirect oldVersion="8.0.242.0-15.0.0.0"
                         newVersion="15.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.Interfaces"
                          publicKeyToken="89845dcd8080cc91"
                          culture="neutral" />
        <bindingRedirect oldVersion="8.0.242.0-2018.8.0.0"
                         newVersion="2018.8.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.Exceptions"
                          publicKeyToken="89845dcd8080cc91"
                          culture="neutral" />
        <bindingRedirect oldVersion="8.0.242.0-2018.8.0.0"
                         newVersion="2018.8.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.ProcessingRenderingCommon"
                          publicKeyToken="89845dcd8080cc91"
                          culture="neutral" />
        <bindingRedirect oldVersion="8.0.242.0-2018.8.0.0"
                         newVersion="2018.8.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore"
                          publicKeyToken="89845dcd8080cc91"
                          culture="neutral" />
        <bindingRedirect oldVersion="9.0.242.0-2018.8.0.0"
                         newVersion="2018.8.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.ProcessingObjectModel"
             publicKeyToken="89845dcd8080cc91"
             culture="neutral" />
        <bindingRedirect oldVersion="9.0.242.0-2018.8.0.0"
                         newVersion="2018.8.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.SqlServer.Types"
                          publicKeyToken="89845dcd8080cc91"
                          culture="neutral" />
        <bindingRedirect oldVersion="10.0.0.0-15.0.0.0" newVersion="14.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.Owin" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Cors" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-5.0.0.0" newVersion="5.2.3.0" />
      </dependentAssembly>
    </assemblyBinding>

    We will be working in a fix in order to solve the issues with the config files during the upgrade

jtarquino's avatar
jtarquino
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Ccparkhill, I'm investigating the issue, does the report that fails to render have history snapshots or caching enabled?

 

or its happening to all your reports regardless the features you have enabled on them.

 

Thanks

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I do not have caching or snapshots enabled on my paginated reports, and I am receiving the same error.

    • jtarquino's avatar
      jtarquino
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      For those affected can you validate in this files 

      "C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\web.config"

      "C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\ReportingServicesService.exe.config"

       

      There is a configuration for Microsoft.ReportingServices.ProcessingObjectModel , it should look like the one below

      focus in the values for oldVersion and newVersion

       

      <dependentAssembly>
      <assemblyIdentity name="Microsoft.ReportingServices.ProcessingObjectModel" publicKeyToken="89845dcd8080cc91" culture="neutral" />
      <bindingRedirect oldVersion="9.0.242.0-2018.0.0.0" newVersion="2018.8.0.0" />
      </dependentAssembly>

       

       

      Feel free to change them and verify if that fix your issue, also if they are different that the one I showed, please post here the values you have.

       

      Thanks

       

       

      • pdbenbow's avatar
        pdbenbow
        Icon for Resolver II rankResolver II
        8 years ago

        jtarquino, thanks for the suggestion. I opened up the config files and here is what we have:

         

        web.config

              <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.ProcessingObjectModel"
                     publicKeyToken="89845dcd8080cc91"
                     culture="neutral" />
        <bindingRedirect oldVersion="9.0.242.0-14.0.0.0"
                                 newVersion="2018.8.0.0" />
      </dependentAssembly>

        ReportingServicesService.exe.config

              <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.ProcessingObjectModel"
             publicKeyToken="89845dcd8080cc91"
             culture="neutral" />
        <bindingRedirect oldVersion="9.0.242.0-2018.8.0.0"
                         newVersion="2018.8.0.0" />
      </dependentAssembly>
  • Ccparkhill's avatar
    Ccparkhill
    Icon for Helper II rankHelper II
    8 years ago

    All RDL reports are now rendering sucessfully after updating the config files and restarting the service. We were not using snapshots or caching. Also, not all of our RDL reports were affected by this issue. 

     

    When can we expect to see an updated installer? Thanks.

    • mgmeyer's avatar
      mgmeyer
      Icon for Power BI Team rankPower BI Team
      8 years ago

      We're going to try and get a patch update out for this sometime this week.

      • motoray's avatar
        motoray
        Icon for Advocate V rankAdvocate V
        8 years ago

        Any news on the patch yet?

    • kelly_darren's avatar
      kelly_darren
      Icon for Advocate II rankAdvocate II
      8 years ago

      Ccparkhill Did you just update part of the config files or the whole file?  jtarquino didn't respond to my earlier query so I still don't know if we should still be looking at updating the whole file!!

       

      Thanks

      • Ccparkhill's avatar
        Ccparkhill
        Icon for Helper II rankHelper II
        8 years ago

        kelly_darren I replaced the entire assemblyBinding section in each file with the text jtarquino posted in message 17.