U9报服务器可能资源不足,或者不信任该程序集的处理方法
[13][admin ][11:55:13][ERROR][UI.FormProcess]-System.Data.SqlClient.SqlException: 在尝试加载程序集 ID 65536 时 Microsoft .NET Framework 出错。 服务器可能资源不足,或者不信任该程序集,因为它的 PERMISSION_SET 设置为 EXTERNAL_ACCESS 或 UNSAFE。请重新运行查询,或检查有关的文档了解如何解决程序集信任问题。有关此错误的详细信息: System.IO.FileLoadException: 未能加载文件或程序集“ufida.u9.sql.clrlib, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null”或它的某一个依赖项。异常来自 HRESULT:0x80FC80F1 System.IO.FileLoadException: 在 System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) 在 System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) 在 System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) 在 System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) 在 System.Reflection.Assembly.Load(String assemblyString) at UFSoft.UBF.Service!0x060000c8!UFSoft.UBF.Service.ServerDynamicProxy.Invoke(IMessage myIMessage) +0xf3 at mscorlib!0x0600572e!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x155 at UFIDA.U9.SM.SMBP.Agent!0x06000763!UFIDA.U9.SM.Ship.Proxy.IShipmentApprove.Do(IContext context, IList`1& outMessages, EntityKey shipmentKey, Boolean isUnApprove, Int64 sysVersion) at UFIDA.U9.SM.SMBP.Agent!0x0600076e!UFIDA.U9.SM.Ship.Proxy.ShipmentApproveProxy.InvokeImplement[T](T oChannel) +0x2a at UFSoft.UBF.AopFrame!0x060000a6!UFSoft.UBF.Service.Base.ProxyBase.InvokeAgent[T]() +0x3e at UFIDA.U9.SM.SMBP.Agent!0x0600076d!UFIDA.U9.SM.Ship.Proxy.ShipmentApproveProxy.Do() +0x8 at UFIDA.U9.SCM.SD.ShipUI.WebPart!0x06007c4d!UFIDA.U9.SCM.SD.ShipUIModel.ShipUIModelAction.UnApproveClick_Extend(Object sender, UIActionEventArgs e) +0x9f at UFSoft.UBF.UI.ActionProcess!0x060001e4!UFSoft.UBF.UI.ActionProcess.BaseAction.InvokeAction(Object sender, UIActionEventArgs e, ActionDelegate actionExtend) +0xdc at UFIDA.U9.SCM.SD.ShipUI.WebPart!0x06007b10!UFIDA.U9.SCM.SD.ShipUIModel.ShipUIModelAction.UnApproveClick(Object sender, UIActionEventArgs e) +0x15 at UFIDA.U9.SCM.SD.ShipUI.WebPart!0x06000044!UFIDA.U9.SCM.SD.ShipUIModel.ShipMainUIFormWebPart.BtnUndoApprove_Click_DefaultImpl(Object sender, EventArgs e) +0x12 at UFIDA.U9.SCM.SD.ShipUI.WebPart!0x06000185!UFIDA.U9.SCM.SD.ShipUIModel.ShipMainUIFormWebPart.BtnUndoApprove_Click_Extend(Object sender, EventArgs e) +0x9 at UFSoft.UBF.UI.FormProcess!0x0600009e!UFSoft.UBF.UI.FormProcess.BaseWebForm.InvokeMethod[EA](Object sender, EA e, EventHandler`1 handle) +0x15f ========== MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; MODULE: UFIDA.U9.SCM.SD.ShipUI.WebPart => UFIDA.U9.SCM.SD.ShipUI.WebPart, Version=25.5401.33301.0, Culture=neutral, PublicKeyToken=null; G:ff3d8961178643e69ac7e55566e8c261; A:1 MODULE: UFIDA.U9.SM.SMBP.Agent => UFIDA.U9.SM.SMBP.Agent, Version=25.5401.33355.0, Culture=neutral, PublicKeyToken=null; G:c138fec5c3474db4b5329ccc050fbdc3; A:1 MODULE: UFSoft.UBF.AopFrame => UFSoft.UBF.AopFrame, Version=25.5401.28703.0, Culture=neutral, PublicKeyToken=null; G:0809f490fd724f81a1691244438967e5; A:1 MODULE: UFSoft.UBF.Service => UFSoft.UBF.Service, Version=25.5401.30039.0, Culture=neutral, PublicKeyToken=null; G:861e3387c1d547a38178fa16644acbbe; A:1 MODULE: UFSoft.UBF.UI.ActionProcess => UFSoft.UBF.UI.ActionProcess, Version=25.5401.23276.0, Culture=neutral, PublicKeyToken=null; G:d7bf39d829f6460289195ac0c97bb094; A:1 MODULE: UFSoft.UBF.UI.FormProcess => UFSoft.UBF.UI.FormProcess, Version=25.5401.31104.0, Culture=neutral, PublicKeyToken=null; G:87164d41169a4a23971d77eab385cea0; A:1
针对上面的报错代码,解决方案为,把数据库的所有者设成SA