Free Support Forum - aspose.com

Aspose cells 19.1 error on SSRS load


#1

I tried to test version 19.1 but receive the following error:

ERROR: Exception caught instantiating ACXLSX report server extension: System.IO.FileLoadException: Could not load file or assembly ‘Aspose.Cells.ReportingServices, Version=19.1.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=19.1.0.0, Culture=neutral, PublicKeyToken=e6b46033861b5318’ —> System.Security.Policy.PolicyException: Execution permission cannot be acquired.
at System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission)
at System.Security.SecurityManager.ResolveCasPolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission)
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssembly(String name)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.<>c__DisplayClass2.b__0()
at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.b__0(Object state)
at System.Security.SecurityContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state)
at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig, Boolean typeOnly)


#2

@Charlie.R,

Thanks for the stacktrace.

It looks like you do not give Aspose.Cells for Reporting Services sufficient permissions for execution. You need to check your “rssrvpolicy.config” file into your SSRS installation directory. You need to grant full trust permissions to the Aspose.Cells for Reporting Services assembly to work, see point 7) for reference:
https://docs.aspose.com/display/cellsreportingservices/Using+DLL+Only


#3

@Charlie.R,

Could you provide your test environment details, including windows server version, SQL Server Reporting Services version and .Net framework versions, etc., we will check it soon.


#4

windows 16
SQL server 2017
SSRS 2016
cannot see .NET installed on the server.

version 18.11 works fine, as soon as I replace the fell with 2019.2 I get the error above.

thanks,


#5

@Charlie.R,

Thanks for the details.

I have logged an investigation ticket with an id “CELLSRS-549” for your issue. The issue is logged as following:
CELLSRS-549 - Exception caught instantiating ACXLSX report server extension: “System.IO.FileLoadException: Could not load file or assembly”

We will look into your issue soon. Once we have an update on it, we will let you know.


#6

@Charlie.R,

Please try our latest version/fix v19.3 for SSRS 2016 (attached).

Copy Aspose.Cells.ReportingSerivces.dll into ${SSRS 2016 installation folder}\ReportServer\bin.
If you still face the issue, please post rsreportserver.config and rssrvpolicy.config files here, we will check it soon.
ACRS2016.V19.3.0.zip (5.0 MB)