sp_browsereplcmds crashes loading CLR assembly -
10-08-2010
, 10:49 AM
Below is the actual Error:
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Msg 10314, Level 16, State 11, Procedure sp_browsereplcmds, Line 110
An error occurred in the Microsoft .NET Framework while trying to load
assembly id 65536. The server may be running out of resources, or the
assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or
UNSAFE. Run the query again, or check documentation to see how to
solve the assembly trust issues. For more information about this
error:
System.IO.FileLoadException: Could not load file or assembly
'asm_tranrepl, Version=9.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Invalid
IL or CLR metadata. (Exception from HRESULT: 0x8013153A) --->
System.InvalidProgramException: Common Language Runtime detected an
invalid program.
System.InvalidProgramException:
at System.Security.Policy.PolicyLevel.GenericResolve( Evidence
evidence, Boolean& allConst)
at System.Security.Policy.PolicyLevel.Resolve(Evidenc e evidence,
Int32 count, Char[] serializedEvidence)
at System.Security.PolicyManager.CodeGroupResolve(Evi dence
evidence, Boolean systemPolicy)
at System.Security.PolicyManager.ResolveHelper(Eviden ce evidence)
at System.Security.SecurityManager.ResolvePolicy(Evid ence evidence,
PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset,
PermissionSet& denied, Boolean checkExecutionPermission)
at System.Security.SecurityManager.ResolvePolicy(Evid ence evidence,
PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset,
PermissionSet& denied, Int32& securitySpecialFlags, Boolean
checkExecutionPermission)
System.IO.FileLoadException:
at System.Reflection.Assembly._nLoad(AssemblyName fileName, String
codeBase, Evidence assemblySecurity, Assembly locationHint,
StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean
forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyNa me
assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark,
Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString,
Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIn...
----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Server 2005 x64 SP2 EE
Win 2003 x64 EE
Is there a way to FIX this before the server crashes ?
The OS has enough memory... SQL Server is currently under not a big
load
Any suggestions ? |