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

SQL Server Reporting Services

Index ‹ SQL Server
- Archive
  - VC++
  - Visual Studio
  - IE
  - VS 2008
  - Office
  - Visual C#
  - Dotnet
  - Windows Vista
  - VB
  - Windows Live
  - VS Express
  - Architecture
  - Game
  - Smart Device
  - ISV
  - SharePoint
  - VFP
  - SQL Server
  - Windows Forms

- Previous
  - 1
    - SQL2005 SP2 Dec CTP Sharepoint AddIn install problem In Central Admin, can you check if you can find the feature under Site Settings -> Site Collection features If present, make sure that it is activated. Thanks, Sharmila Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 2
    - Reporting Services Instance not found it was stupid of me... got it to work! thanks! -Lawrence Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 3
    - SSIS - Several Bugs in creating a simple task Robert F Bouillon wrote: I was creating an SSIS package, seemingly simple. One of the tasks I needed to do involved copying our production database to a seperate DB instance for staging. I wanted an SSIS package that would stage production so we could push and test changes. My first problem is that I tried to create a simple Transfer Database task. When I tried to run the task, I got an error stating that our Stored Procedure, DtsRun, could not be scripted. It's an encrypted stored procedure. That kinda makes sense does it not The whole point of encrypting it is so no-one can get at it. That's my understanding anyway. Robert F Bouillon wrote: A little annoyed, I decided that I'd do a transfer SQL objects instead. Now I don't want to hard-code my objects to xfer based on the current schema and edit this SSIS script every time we make a DB change; I just want it to copy ALL objects except for my encrypted proc. I'll just build a list with with another task. I decided that I'll write a script that generates a list of proc names, and I'll pass that to the Copy SQL Server Objects task. Well apparantly I can't assign a collection value with a script. I have to create ANOTHER package that modifies THIS package because (1) The entire package isn't exposed to the script task and (2) object variables can't be used in expressions. I've never used Copy SQL Server Objects Task but can you not loop over your objects using ForEach Loop's SMO Enumerator (or other) and move them one by one. Robert F Bouillon wrote: Am I missing something So because I use a single encrypted stored procedure, I have to write 2 fairly complex packages to copy my database That's just stupid. I can understand if SQL can't move the encrypted package while the database is online. I could deal with that. But the extremes I have to go to JUST to copy my database are truly rediculous. Have you tried the Import/Export wizard to generate a package to do this Robert F Bouillon wrote: I was really excited about SSIS, but I've been really dissapointed. The performance of the designer on my machine is really poor (I have a Core T2700 with 2GB RAM). Just about every error message I've gotten, both design-time and run-time, I've had to google because they're so obscure. And if you can only store blittable types and strings in variables, that severely limits the functionality of a package (without going to programmatic extremes). What else would you like to store I haven't yet come across anything that cannot be stored in vars. Robert F Bouillon wrote: Most of all, I'm really dissapointed in the expression system, If the CLR is loaded into the SSQL/SSIS runtime, then why am I coding it using ANOTHER proprietary coding syntax I thought .NET was meant to keep people from having to redesign the wheel Yeah alot of people don't like this but there are good justifications for it. Quite simply, the expression syntax is optimised for what it is provided for. Greasy fast speed. And faster than .Net. Hopefully someone from MSFT will reply will teh proper justification. Robert F Bouillon wrote: Microsoft is constantly pushing C#, yet I can only script in VB.NET, which means I now have code-bases in different languages. It is a problem yeah. The reason is that the scripting environment is VSA - something completely seperate to SSIS. VSA only supports VB.Net. The inclusion of scripting was late in the dev cycle for SSIS v1 and hence they didn't have time to build something that used C#. Given the choice between having VB.Net or nothing at all I know what I'd got for. In the next version VSA is expected to get replaced with VSTO and this will give full C# support. -Jamie Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 4
    - The SELECT permission was denied on the object 'tblName', database 'dbName', schema 'dbo' I would recommend using SQL Server profiler to find out what is the execution context being used at the moment the permission check fails. It may be possible that the connection is being established under a different context than the one you expected. Thanks a lot, -Raul Garcia SDE/T SQL Server Engine Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 5
    - Substring and Patindex having an User Defined Function Hi All, Yes, we can do this. I just figured this out. The fault was that I was not using braces. It was solved. Thanks. Mannu. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 6
    - Why was ReadWriteVariable not populated/updated with a value of the dynamically generated string? Setting the value of a variable is a run-time thing. After the script runs, you won't have the last value generated by the script stored in the variable. The variable will revert back to the default set at design time. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 7
    - DTS Code works only with VS 2003 but not with VS 2005 ? DTS has been replaced with SSIS, so yes, plenty of things have changed. DTS questions can be asked over at the DTS news group, if that helps: http://groups.google.com/group/microsoft.public.sqlserver.dts lnk=srg Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 8
    - i want know the difference between "SQL Server 2005 -Std Edition" and "SQL Server 2005 Std license" IF both descriptions refer to SQL Server, then there probably are no differences. The best way to know the product is to check the SKU. However, since the word 'license' is not capitalized, I wonder if it should have been SQL Server 2005 Std Single Processor License" Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 9
    - Report Definition Not sure if this is what you mean, but you can control the # of rows displayed by limiting the # of rows fetched from the data source. There's no way AFAIK to fetch N rows but only display N-M rows. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 10
    - Access To Dts.Variables Causes Exception Right Click the script task, press F4, this will show the properties of the script task, there you will have properties called ReadOnlyVariables, ReadWriteVariables. You can set the variables name in this based on your requirement. These variables will be available in the script, else they dont have visibility inside the script task and an error will be thrown at run time. Thanks Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 11
    - Property DefaultSchema is not available for Database [DatabaseName] this is by design. Group cannot have a default schema, since no principal can have group as its primary id (as opposite to group id). Consider following: windows user1 is added to windows group1 and group2. If both of them are allowed to have default schema what default schema user1 has then Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 12
    - Cannot insert duplicate key Try the below query, INSERT INTO tbUnique SELECT Distinct * FROM tbDupes Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 13
    - RS Integration with SharePoint 3.0 - Query with userid parameter Hi, actually these are two different questions: it depends how you implemented the authentication. If reports are called by Sharepoint, it is possible to use the information of the Windows Identity to authenticate against the SQL Server. As you are using a UserId approach and not the actual identity at the SQL Server level you could also use SQL Server authentication to run the query of the report. So the following options could be available: [Report (UserId) -- IIS (Windows Integrated Authentication)] -- SQL Server (SQL Server Authentication with static credentials) [Report (UserId) -- IIS (Windows Integrated Authentication)] -- SQL Server (Windows Authentication) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 14
    - SQL 2000 - All Client Tools You don't buy the client tools. If you have a SQL Server installed then, depending on the license (per proc vs server cal), everyone that connects can install the client tools. Just have them install the tools from the SQL Server CD. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 15
    - Printing in Reporting Services hangs I am also facing a very similar problem... Printing to a real printer or export to pdf shows "Printing Now..." and w3wp.exe service on server starts consuming 100% CPU!!! I tired to run/print the same report from VS2005 and RSReportHost.exe dies while printing. After further analysis, we found that there was a field in a subreport that was extremely long... so long that it was spilling over a page's height. It seems like a bug in Reporting Service printing routine when there is a subreport with large fields, it freaks out... Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 16
    - SUM in Report Hello Leandro, I belive something like: Code Block =sum(iif(Fields!FlagPresenca.Value=1,1,0)) will do what you want. The expressions in SQL Server Reporting Services can use Visual Basic syntax so the IIF works as described here: http://msdn2.microsoft.com/en-us/library/27ydhh0d(VS.71).aspx Good luck! Larry Smithmier Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
- Next
  - 1
    - Could not create Maintenance Plan It seems like that should work. Please file a defect report for this on http://connect.microsoft.com/SQLServer . Issues reported on the connect site go directly into our internal issue tracking system. Be sure to describe how the cluster is configured, whether SSIS is installed on each node, etc. Thanks, Steve Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 2
    - Cascade Issue This is not allowed in SQL Server. The tree of cascading referential actions must not have more than one path to any specified table. If the script succeeded, a single update/delete on table [AA] may cause cascading referential actions to table [BB] through both foreign keys [FK_bb_aa] and [FK_BB_AA1]. You need to specify ON DELETE NO ACTION or ON UPDATE NO ACTION on [FK_bb_aa] before creating the foreign key [ FK_BB_AA1]. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 3
    - An error occurred during local report processing. Index was outside the bounds of the array. One thing it might help you is to see if there are any diffrences of your local rdl file compared with the publised one I hope you know how to get the rdl out of the published report. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 4
    - Unable to connect to the remote server Can you verify that this is the correct virtual directory in IIS manager I can't remember if the $ in the name caused any problems. Anyway, in this CTP, RS is effectively the same as SQL 2005 SP2 so don't expect any big changes. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 5
    - Parameters with a union statement Have you tried to use this sql structure ="select * from table_1 where Sale_date = '" & format(Parameters!date,"MM-dd-yyyy") & "'" union select * from table_2 where Sale_date = '" & format(Parameters!date,"MM-dd-yyyy") & "'" Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 6
    - What is the best most efficient performant way to do a Control break in SSIS? Where are the big boys on this one Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 7
    - Virtual cube You can have multiple measure groups in the cube in AS2005 - this gives same functionality as virtual cubes in AS2000. The measure groups can also be linked measure groups to the other cubes, so one measure group can be shared among multiple cubes, just like in AS2000. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 8
    - How to convert SQL Server datetime to Oracle timestamp (or other type with similar precision)? Are you using SSIS Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 9
    - Domain account without a SQL login account It could be working under the guest account, it could be included in a domain group account that has database access, it could be under an ALIAS (a deprecated feature -and still dangerous). Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 10
    - SQLServerException: The statement did not return a result set when sp uses cursors Hi, Could you post some additional detail, including: Driver version you are using (v1.0, v1.1, v1.2 CTP), preferably output from DatabaseMetaData.getDriverVersion(). A snippet of code you are using to call the stored procedure and process its results The stored procedure definition The JDBC driver manages cursors through the ResultSet APIs, so you should not need to create and return cursors from your stored procedure. Are you trying to return a cursor from the stored procedure, or just use one in the stored procedure Thank you, --David Olix [MSFT] Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 11
    - flat file to excel You can add a Conditional Split Transformation to route the data to multiple Excel destinations based on ranges of values in a specific column (i.e. ID). For more information about using the Conditional Split Transformation, see "Conditional Split Transformation" at http://msdn2.microsoft.com/en-us/library/ms137886.aspx . Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 12
    - Displaying an database image in SSRS Report page header It can be done with the help of matrix.For eg: A report named Report1.rdl is the report to which header image has to be placed.Create a report named MainReport.rdl and in that Add a matrix.In the Row grouping give the grouping field name.For eg: Report is designed to display details of particular invoice no.give that in group on condition (Fields!Invoiceno.value) When Matrix is draged rows ,column and data text is displayed in that then in rows column place the expression =Convert.ToBase64String(First(Fields!companylogo.Value, "DataSet2" )) In data column drag a subreport which points to Report1.rdl. place the image in the page header and in the value field place =Convert.FromBase64String(ReportItems!textbox3.Value) .Here textbox3 is the Rows column textbox name. Don't forget to set MIME type and Source as Database. I thinks so this helps! Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 13
    - group by and count of each group Maybe you can use the COMPUTE clause like: Code Block declare @tab table ( myItem int, column2 int, column3 varchar(40) ) insert into @tab select 711056, 22662, 'Finances / -2291 -2479916' union all select 711056, 22663, 'Finances / -2380 -2576255' union all select 711056, 43428, 'Cda) -323 -349635' union all select 711056, 43428, '. -B-(Cda) -44 -47628' union all select 711057, 44348, '. -B-(Cda) -355 -384273' union all select 711057, 47033, '. -B-(Cda) -1278 -1383384' select myItem, column2, column3 from @tab order by myItem, column2 compute count(myItem) by myItem /* -------- Sample Output: -------- myItem column2 column3 ----------- ----------- ---------------------------------------- 711056 22662 Finances / -2291 -2479916 711056 22663 Finances / -2380 -2576255 711056 43428 Cda) -323 -349635 711056 43428 . -B-(Cda) -44 -47628 cnt ----------- 4 myItem column2 column3 ----------- ----------- ---------------------------------------- 711057 44348 . -B-(Cda) -355 -384273 711057 47033 . -B-(Cda) -1278 -1383384 cnt ----------- 2 */ Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 14
    - Advice on developing a mobile app that uses SQL 2005 CE I believe that merge replication will be the solution to your problems, as it will allow you to: Populate the device SDF, but for development and production purposes, and transfer inserted data from the device to the central SQL Server. I would strongly recommend upgrading to SQL Server 2005, but SQL Server 2000 is a supported platform for merge synchronization with SQL 2005 CE. The topics below this covers both SQL Server 2000 and 2005 configurations: http://msdn2.microsoft.com/en-us/library/ms171850.aspx Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 15
    - Simultaneous execution of the same SSIS package from code Can you clarify "only one instance of the package is executed" You mean the subsequenct package executions never occur How are you measuring this There is a major difference between what you're trying to do and executing two instances of DTExecUI.exe. The instances of DTExecUI will be in different processes, while yours will be in the same. I think you're going to have problems with variable collision between your instances. My experience is that by doing this type of execution, the package variables will be shared across all instances. This may be causing it to appear as if the subsequent instances aren't executing. See the bottom of this thread for more info. Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
  - 16
    - Folder Location EM and SSMS do this by calling undocumented XPs Tag: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception

Apurv1301

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)

Is there any solution for that

thanks and Regards

Apurv Shah
IBM India pvt Ltd

Re: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception

Hi Its Me

HI Apurv,

You need to copy your assembly file to the folder under microsoftsqlsever\mssql.2\ Report server\bin

Re: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception

Apurv1301

Hi Its Me wrote:

HI Apurv,

You need to copy your assembly file to the folder under microsoftsqlsever\mssql.2\ Report server\bin

Hi

I have already put the dll file to the report server \bin folder

but still error occured

Re: Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception

Apurv1301

I have already dll file in report server bin folder but still error occured
Is there any other solution