topic Re: Subscription Failures - Unable to load assembly in Report Server

Subscription Failures - Unable to load assembly

lastephens69 — Tue, 11 Jun 2019 18:43:40 GMT

We just upgraded our Report Server to the January Version from SSRS 2005(made the hop to 2008 then to the latest version). Now some of our subscriptions are failing to run correctly and I have not been able to determine what is causing the errors. We have subscriptions that send emails, use our own delivery extension and save to a file share. There is no pattern that I can find as to which ones are failing. We even have cases where the report has mutliple subscriptions an only some of them fail.

I have been trying to google and research this issue, but have only found references to fixes that were needed in the August release, but the issue was supposed to have been fixed in the January release.

I have tried resaving the reports to the report server, and that has worked for a few of the subscriptions, but not all of them.

Each report that fails shows the following two errors in the log:

e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Unable to load assembly Microsoft.ReportingServices.Cloud.DataExtensions, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. The system cannot find the file specified.

e ERROR: Exception caught instantiating DAX report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. The system cannot find the file specified.

Re: Subscription Failures - Unable to load assembly

bradsy — Wed, 12 Jun 2019 17:00:51 GMT

Hi Lastephens69,

An assembly is missing, but it is unclear which one. It may not be the one mentioned in the error. You will need to figure out what assembly is missing. . You can run FusionLog to get more detail. This has a good description: https://stackoverflow.com/questions/255669/how-to-enable-assembly-bind-failure-logging-fusion-in-net

Re: Subscription Failures - Unable to load assembly

JonasKjeldsenDK — Thu, 21 Nov 2019 10:10:26 GMT

I have encountered the exact same error when trying to run data driven subscriptions with the September 2019 version of Report Server (Power BI) standard SSRS paginated reports.

Any help?

Re: Subscription Failures - Unable to load assembly

bradsy — Mon, 25 Nov 2019 23:32:45 GMT

I never heard what caused the issue for the customer. But you can run fusionlog and find out what is missing. Then you need to find that dll and put it in a location PBIRS can find. Most likely the bin folder in the program files location.

Re: Subscription Failures - Unable to load assembly

sheetalshettiga — Wed, 18 Mar 2020 05:22:11 GMT

Hello,

I am facing below error for email subscrition in Power Bi Report Server .Please Reply if you have any answer.

ERROR: Exception caught instantiating DAX report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. The system cannot find the file specified..