Problem with subscription in Paginated Report

[MateuszB_]

Hello 🙂

I hope someone will be able to tell me where to look for the error 🙂

Environment : Version 1.22.9153.7886 January 2025

Error Message: “Failure sending mail: Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.ReportingServices.ProcessingObjectModel, Version=2024.9.0.0, Culture=neutral, PublicKeyToken=89845dcdxxxxxxx' or one of its dependencies. The lo”

The above error occurs on;y occasionally when we try to delivery the report to an emial adrdress (automatic subscription)

Usually, after a few manual attempts (we trigger the subscription manually by clicking the "run now" button), the report eventually reaches the recipeint.

Br,

Mateusz

[v-kpoloju-msft · Accepted solution]

Hi @MateuszB_,
Thank you for reaching out to the Microsoft fabric community forum. After reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:

Typically, this issue occurs due to the following points: SSRS (SQL Server Reporting Services) or Power BI Report Server misconfiguration, assembly loading issues (missing or corrupted dependencies), and email delivery failures due to temporary connectivity issues.

Ensure that the assembly Microsoft.ReportingServices.ProcessingObjectModel and its dependencies are correctly installed and not corrupted. Verify that the version mentioned in the error message (2024.9.0.0) matches the installed version.

Ensure that the correct version of the .NET framework is installed and properly configured on the server. The error might be due to a mismatch or missing .NET framework version. Ensure that the account running the SSRS service has the necessary permissions to access the required assemblies and dependencies. Sometimes, permission issues can prevent the loading of assemblies.

Since you mentioned that manually triggering the subscription sometimes works, this could indicate a timing or resource issue. Investigate if there are any resource constraints or conflicts during the automatic subscription process.

Reinstall the assembly: If the assembly is missing or corrupted, reinstalling it might resolve the issue. Update SSRS: Ensure you have the latest updates and patches installed for SSRS. Check for hotfixes: Sometimes, specific hotfixes are released to address known issues with certain versions of SSRS.

Kindly refer to the below provided link for more information:
rsProcessingError - Reporting Services error - SQL Server Reporting Services (SSRS) | Microsoft Lear...

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.