Groups | Search | Server Info | Keyboard shortcuts | Login | Register

Groups > comp.databases.ms-sqlserver > #1922

Re: SQL 2012 CLR Function Causing Error: - Msg 6522, Level 16, State 1, Line 3 A .NET Framework error occurred during execution of user-defined routine or aggregate. CLR Function Causing Error:

Show all headers | View raw

Query Builder (querybuilder@gmail.com) writes:
> We are in the process of migrating our SQL 2008 R2 Enterprise Edition > environment to a new SQL Server 2012 Enterprise Edition. 

What does "SELECT @@version" report for the new server?
 
> The function returns fine most of the time, but at intermittent times,
> its giving me the following error: 
> 
> 
> Msg 6522, Level 16, State 1, Line 3
> A .NET Framework error occurred during execution of user-defined routine 
> or aggregate "<FunctionName>": 
>...
> We have played with PERMISSION_SET to be SAFE EXTERNAL_ACCESS and also
> switched the trustworthy Property on the database. 

So what was the permission set of the assembly originally?

Assuming that it was SAFE, the fact that you get a stack dump indicates a
bug in SQL Server - or a hardware problem like bad memory board. In this case you should verify that you have the most recent Service Pack installed. If that does not resolve the issue, open a case with Microsoft that can
analyse the stack dump.

If you have an unsafe assembly, you better do your homework before you 
open a case.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

SQL 2012 CLR Function Causing Error: - Msg 6522, Level 16, State 1, Line 3 A .NET Framework error occurred during execution of user-defined routine or aggregate. CLR Function Causing Error: Query Builder <querybuilder@gmail.com> - 2015-06-15 13:09 -0700
  Re: SQL 2012 CLR Function Causing Error: - Msg 6522, Level 16, State 1, Line 3 A .NET Framework error occurred during execution of user-defined routine or aggregate. CLR Function Causing Error: Erland Sommarskog <esquel@sommarskog.se> - 2015-06-15 23:13 +0200

csiph-web