Hello I’m currently using aspose cells for SSRS version 19.5.1.0
I wanted to upgrade to the latest version but there are errors in the ssrs log when starting ssrs and I can’t select the aspose outputs.
Error in the log:
extensionfactory!ReportServer_0-1!1538!11/11/2024-17:28:52:: e ERROR: Exception caught instantiating ACTXT report server extension: System.IO.FileLoadException: Could not load file or assembly ‘Aspose.Cells.ReportingServices, Version=24.9.0.0, Culture=neutral, PublicKeyToken=e6b46033861b5318’ or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418)
File name: ‘Aspose.Cells.ReportingServices, Version=24.9.0.0, Culture=neutral, PublicKeyToken=e6b46033861b5318’ —> System.Security.Policy.PolicyException: Execution permission cannot be acquired.
Same error is repeated for ACCSV, ACXML, ACXLSX and ACXLS.
All I did was replace the old dll by the new one, the rssrvpolicy.config file looks fine, the rssreportserver.config as well.
The same happens on my SSRS 2017 server and my SSRS 2019 server.
I tried with versions 24.9 and 24.10, same result. As soon as I put my 19.5 dll back it works again.
What am I doing wrong?
It seems you are encountering a permissions issue when trying to upgrade to a newer version of Aspose.Cells for SSRS. The error message indicates that the assembly ‘Aspose.Cells.ReportingServices’ could not be loaded due to a failure to grant execution permission.
Here are some steps you can take to troubleshoot and resolve this issue:
Check the Configuration Files: Ensure that your rssrvpolicy.config and rssreportserver.config files are correctly configured to allow the new assembly. You may need to add the new version of the assembly to the security policy in rssrvpolicy.config. Make sure that the public key token and version number match the new DLL.
Assembly Version: Verify that you are using the correct version of the DLL that corresponds to your SSRS version. There are different versions of the Aspose.Cells for Reporting Services DLLs that support various Microsoft report server products. Ensure that you have downloaded the correct one for your setup.
Permissions: The error suggests that the execution permission cannot be acquired. You may need to adjust the .NET security settings for your SSRS instance. This can involve modifying the trust level in the rssrvpolicy.config file to allow the new assembly to execute.
Reinstall the Component: If the above steps do not resolve the issue, consider uninstalling the current version of Aspose.Cells for SSRS and then reinstalling the latest version. This can help ensure that all necessary configurations are correctly applied.
Consult Documentation: Review the installation and upgrade documentation for Aspose.Cells for Reporting Services to ensure that all steps have been followed correctly. This documentation often contains specific instructions for upgrading and resolving common issues.
If you continue to experience problems, you may want to reach out to Aspose support or check the Aspose forums for similar issues encountered by other users.
We recommend you to uninstall older Aspose.Cells for Reporting Services precisely. For example, please refer to the document if you used MSI Installer to install Aspose.Cells for Reporting Services 19.5.1.0. After uninstalling the previous component, please refer to the document on how to install the component using MSI installer.
In case, you had installed/registered DLL version previously. Please see and follow the guidelines on how to install (new) Dll version for your reference.
Hello, I found part of the problem. The dll had been copied from another server and needed to be unblocked.
But I now have the following error in the log and cannot select the XLSX render format:
library!ReportServer_0-1!1c18!11/12/2024-14:21:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Could not create Extension of type: Rendername: ACXLSX, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
extensionfactory!ReportServer_0-1!1c18!11/12/2024-14:21:23:: e ERROR: Exception caught instantiating ACXLSX report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. .
Typically, such a configuration error occurs when Aspose.Cells for Reporting Services (ACXLSX extension) hasn’t been correctly registered or the necessary permissions are allotted.
Ensure that Aspose.Cells for Reporting Services has been correctly added to both the rsreportserver.config and rssrvpolicy.config files.
e.g., in rsreportserver.config, confirm that an entry for ACXLSX exists under <Render>:
I have verified the rssrvpolicy.config and the rsreporsterver.config files several times.
When I deploy the 21.10 dll it works, when I deploy the 25.10 or 24.10 it doesn’t.
ACXLS rendering works fine on 25.10 so it’s not an issue with the permissions or the dll not being in the correct folder. Issue only happens with ACXLSX.
We built a test environment: Windows Server 2016, MS SQL Server 2016, MS Reporting Services 2017, and .NET Framework 2.0/3.5/4.6.
We have installed Aspose Cells for Reporting Services 24.9 and successfully exported a test report by Aspose Cells for Reporting Services.
Please share your installation process and user rights.