home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,196 of 19,505   
   Erland Sommarskog to Query Builder   
   Re: SQL 2012 CLR Function Causing Error:   
   15 Jun 15 23:13:44   
   
   From: esquel@sommarskog.se   
      
   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 "":   
   >...   
   > 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca