Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[LaDonna Stephens]

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.

——————————
LaDonna Stephens
Sr Software Developer
Dallas TX

——————————

[Hasham Niaz]

Hi,

As a best practice when you migrate from 1 version to other, you check these report subscriptions manually to verify they are transferred properly & running as well.

When you transferred reports from 1 version to another, some of the report GUID gets broken & that’s the reason why those subscriptions are not triggered because in new version they have a new GUID and subscriptions table have old GUID.

You can try creating a query to check GUID between subscription table & report table in [ReportServer] database to see what are the GUID’s which are unavailable in reports table.

If no. of report subscriptions are low you can set those up manually.

Hope this will help you get started in the right direction.

Regards,

——————————
Hasham Bin Niaz
Director Data & Analytics
Karachi, Pakistan
——————————
——————————————-

[LaDonna Stephens]

Thanks for the suggestions.  Datasources and everything are good as the reports run just fine.  I’ve also been using the Catelog and Subscription tables to monitor the for failures, so I know that they are all tying together correctly.

The interesting part is a subscription will fail.  We can select it, click Run Now and it will fail again.  Without making any change at all to the subscription, report, etc we select and hit Run Now again and the subscription fires successfully.  

I have tried deleting a report from the server and republishing it and resetting up subscriptions, still seeing failures on say 2 or the 3, but when you run a second time the ones that failed succeed.  

Hard to track down an issue with you can’t get consistent results!

——————————
LaDonna Stephens
Sr Software Developer
Dallas TX
——————————
——————————————-

[Michael Foss]

I would suggest verifying your datasource credentials are accurate on the reports that are failing. Also verify subscriptions are enable, lastly double check any default parameters or parameters that are set on the report. ?Also make sure you have a service account associated to the report server in the report server manager.

——————————
Michael Foss
Functional/Business Systems Analyst
——————————
——————————————-