Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
Reload this Page Failed to load expression host assembly
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 19th, 2007, 04:14 AM
Registered User
  
Join Date: Sep 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to apurva_shah1301 Send a message via Yahoo to apurva_shah1301
Default Failed to load expression host assembly
Hi

I am using sql reporting service 2005 with .NET 2.0.
I have created a custom dll file for report and put this dll in appropriate folder.
Report is running fine in designer project.
but when I am trying to view this report after uploading to report manager it give me an error like

    * Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception. (rsErrorLoadingExprHostAssembly)

I have checked the log file for reporting service exception
It shows me there is a security exception.

Exception from log file
aspnet_wp!processing!1!9/19/2007-12:50:12:: e ERROR: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception.
System.TypeInitializationException: The type initializer for 'CableReporting.Utilities' threw an exception. ---> System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
   at System.Security.CodeAccessSecurityEngine.CheckNRet urnSO(PermissionToken permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 unrestrictedOverride, Int32 create)
   at System.Security.CodeAccessSecurityEngine.Assert(Co deAccessPermission cap, StackCrawlMark& stackMark)
   at System.Security.CodeAccessPermission.Assert()
   at CableReporting.Utilities.GetConfigSettings()
   at CableReporting.Utilities..cctor()
The action that failed was:
Demand
The type of the first permission that failed was:
System.Security.Permissions.SecurityPermission
The first permission that failed was:
<IPermission class="System.Security.Permissions.SecurityPermiss ion, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion"/>

The demand was for:
<IPermission class="System.Security.Permissions.SecurityPermiss ion, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion"/>

The granted set of the failing assembly was:
<PermissionSet class="System.Security.PermissionSet"
version="1">
<IPermission class="System.Security.Permissions.SecurityPermiss ion, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Execution"/>
<IPermission class="System.Security.Permissions.StrongNameIdent ityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
PublicKeyBlob="00240000048000009400000006020000002 4000052534131000400000100010029249FF8E6CA52AE77DC5 A9B08AF05A2DA06EEF63F9D6A5650D844A02D07303704165A7 BB7ED25166B15B783A149E1A5228B4D7182D0BA9869B0203FD 8896F58B4D974AB3F990D966BB8CB50B394E12B28408A040E5 A85FADEE7CDC9CD1A29D98EC62AE7D39C53C2045D0A5872724 5F95114B6B4DB92488288F6DD87814D95DE"
Name="RsCableUtilities"
AssemblyVersion="1.0.2816.26912"/>
<IPermission class="System.Security.Permissions.UrlIdentityPerm ission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Url="file:///C:/Program Files/Microsoft SQL Server/MSSQL.4/Reporting Services/ReportServer/bin/RsCableUtilities.DLL"/>
<IPermission class="System.Security.Permissions.ZoneIdentityPer mission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Zone="MyComputer"/>
</PermissionSet>

The assembly or AppDomain that failed was:
RsCableUtilities, Version=1.0.2816.26912, Culture=neutral, PublicKeyToken=62a9545c2135a859
The method that caused the failure was:
System.Collections.Specialized.NameValueCollection GetConfigSettings()
The Zone of the assembly that failed was:
MyComputer
The Url of the assembly that failed was:
file:///C:/Program Files/Microsoft SQL Server/MSSQL.4/Reporting Services/ReportServer/bin/RsCableUtilities.DLL
   --- End of inner exception stack trace ---
   at CableReporting.Utilities..ctor()
   at ReportExprHostImpl..ctor(Boolean parametersOnly, Object reportObjectModel)
aspnet_wp!processing!1!9/19/2007-12:50:12:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException: Exception of type 'Microsoft.ReportingServices.ReportProcessing.Repo rtProcessingException' was thrown., ;
 Info: Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException: Exception of type 'Microsoft.ReportingServices.ReportProcessing.Repo rtProcessingException' was thrown.
aspnet_wp!processing!1!9/19/2007-12:50:16:: e ERROR: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception.
System.TypeInitializationException: The type initializer for 'CableReporting.Utilities' threw an exception. ---> System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
   at System.Security.CodeAccessSecurityEngine.CheckNRet urnSO(PermissionToken permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 unrestrictedOverride, Int32 create)
   at System.Security.CodeAccessSecurityEngine.Assert(Co deAccessPermission cap, StackCrawlMark& stackMark)
   at System.Security.CodeAccessPermission.Assert()
   at CableReporting.Utilities.GetConfigSettings()
   at CableReporting.Utilities..cctor()
The action that failed was:
Demand
The type of the first permission that failed was:
System.Security.Permissions.SecurityPermission
The first permission that failed was:
<IPermission class="System.Security.Permissions.SecurityPermiss ion, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion"/>

The demand was for:
<IPermission class="System.Security.Permissions.SecurityPermiss ion, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion"/>

The granted set of the failing assembly was:
<PermissionSet class="System.Security.PermissionSet"
version="1">
<IPermission class="System.Security.Permissions.SecurityPermiss ion, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Execution"/>
<IPermission class="System.Security.Permissions.StrongNameIdent ityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
PublicKeyBlob="00240000048000009400000006020000002 4000052534131000400000100010029249FF8E6CA52AE77DC5 A9B08AF05A2DA06EEF63F9D6A5650D844A02D07303704165A7 BB7ED25166B15B783A149E1A5228B4D7182D0BA9869B0203FD 8896F58B4D974AB3F990D966BB8CB50B394E12B28408A040E5 A85FADEE7CDC9CD1A29D98EC62AE7D39C53C2045D0A5872724 5F95114B6B4DB92488288F6DD87814D95DE"
Name="RsCableUtilities"
AssemblyVersion="1.0.2816.26912"/>
<IPermission class="System.Security.Permissions.UrlIdentityPerm ission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Url="file:///C:/Program Files/Microsoft SQL Server/MSSQL.4/Reporting Services/ReportServer/bin/RsCableUtilities.DLL"/>
<IPermission class="System.Security.Permissions.ZoneIdentityPer mission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Zone="MyComputer"/>
</PermissionSet>



Is there any solution for that?



Thanks and Regards

Apurv shah
IBM India Pvt Ltd





Similar Threads
Thread Thread Starter Forum Replies Last Post
Assembly failed to laod vinodjv .NET Framework 2.0 0 September 10th, 2008 02:06 AM
Could not load the assembly Jitender BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 6 September 5th, 2008 05:06 PM
Could not load file or assembly 'DLL' or one of it Mahenj BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 January 17th, 2007 10:16 AM
Could not load file or assembly vantoko BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 4 August 27th, 2006 02:26 PM
Can't Up load to local host one image Jacky Kenna Dreamweaver (all versions) 4 July 26th, 2005 12:09 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.