cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ccparkhill Regular Visitor
Regular Visitor

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 'Microsoft.ReportingServices.ProcessingObjectModel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (rsErrorLoadingExprHostAssembly)

 

I've tried clearing the cache in both IE and Chrome but this does not resolve the issue. I have found that deleting the report and redeploying it does resolve the issue, however. 

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team jtarquino
Power BI Team

Re: August release - Failed to load expression host assembly

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

38 REPLIES 38
Highlighted
messerjc Member
Member

Re: August release - Failed to load expression host assembly

Sounds like the same issue @DaveW and @CB1 was/is having? Tagging them here to get their attention...

pdbenbow Regular Visitor
Regular Visitor

Re: August release - Failed to load expression host assembly

I encountered the exact same issue after upgrading to the August 2018 version of PBIRS. It seemed to affect all paginated reports that already existed on the server prior to the upgrade. I was able to clear the issue by re-deploying all of the reports using our VSTS release pipeline.

Moderator mgmeyer
Moderator

Re: August release - Failed to load expression host assembly

There was a dll version change that happened in this release that is the root cause here, most likely it's caused by execution snapshots being cached in the database. If you re-render (not from cache) the report you shouldn't need to be republished.

pdbenbow Regular Visitor
Regular Visitor

Re: August release - Failed to load expression host assembly

That was not the case for us. I upgraded our dev report server first in order to regression-test all our reports before proceeding with the upgrade to the test and production servers, and none of our dev reports use cached snapshots.

messerjc Member
Member

Re: August release - Failed to load expression host assembly

Is there any way force a refresh of the cache if that is the case? I'm hoping to upgrade our dev and qa servers with this today and it's all older paginated reports, so I'll report back if I run into the same issue.

Moderator mgmeyer
Moderator

Re: August release - Failed to load expression host assembly

We're investigating it now, will update shortly.

Power BI Team jtarquino
Power BI Team

Re: August release - Failed to load expression host assembly

@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

 

cksiz Regular Visitor
Regular Visitor

Re: August release - Failed to load expression host assembly

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

Power BI Team jtarquino
Power BI Team

Re: August release - Failed to load expression host assembly

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