將截斷字符串或二進制數據。語句已終止……
我在設計數據庫的時候準備在一個表中設計一個NContent字段，它的數據類型為varchar(50)，由于是在可視模式下新建的，沒有太注意，也許是鼠標滑輪不小心滑動力，導致NContent字段的數據變成了：nvarchar()類型了，所以在后來的添加數據時就出現了“將截斷字符串或二進制數據。語句已終止……”的錯誤提示。。。
解決辦法當然有多種，一是修改數據庫字段大小； 二是加強數據強壯性，嚴格的輸入判斷。 目前是采用修改數據的方法：alter table1 alter column caller varchar(50)
| 以下為引用的內容： Server Error in '/Rainbow' Application. -------------------------------------------------------------------------------- 將截斷字符串或二進制數據。語句已終止。 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: 將截斷字符串或二進制數據。語句已終止。 Source Error: Line 488: myInputs.Add("InputParams" , InputParams); Line 489: myInputs.Add("RealModuleID" , ModuleID); Line 490: workflow.DoAction(wid, actionId, myInputs); Line 491: #region Line 492: #region Source File: C:InetpubwwwrootRainbowDesktopModulesTaokeCatalogsActionsDo.ascx.cs Line: 490 Stack Trace: [SqlException: 將截斷字符串或二進制數據。 語句已終止。] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196 NHibernate.Impl.NonBatchingBatcher.AddToBatch(Int32 expectedRowCount) +43 NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Boolean[] includeProperty, Object oldVersion, Object obj, SqlString sqlUpdateString, ISessionImplementor session) +709 NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Object[] oldFields, Object oldVersion, Object obj, ISessionImplementor session) +111 NHibernate.Impl.ScheduledUpdate.Execute() +134 NHibernate.Impl.SessionImpl.ExecuteAll(IList list) +128 NHibernate.Impl.SessionImpl.Execute() +103 [ADOException: could not synchronize database state with session] NHibernate.Impl.SessionImpl.Execute() +184 NHibernate.Impl.SessionImpl.Flush() +27 NHibernate.Transaction.AdoTransaction.Commit() +101 DotNetTools.Workflow.Spi.Hibernate.HibernateWorkflowStore.MarkFinished(IStep step, Int32 actionId, DateTime finishDate, String status, String caller) in D:WorkingWorkflowWorkflow-OldsrcDotNetTools.WorkflowSpiHibernateHibernateWorkflowStore.cs:309 [StoreException: Saving current step with action 102] DotNetTools.Workflow.AbstractWorkflow.DoAction(Int64 id, Int32 actionId, IDictionary inputs) in D:WorkingWorkflowWorkflow-OldsrcDotNetTools.WorkflowAbstractWorkflow.cs:721 Rainbow.DesktopModules.TaokeCatalogs.Actions.Do.DirectDoWorkflowAction(String sWid, Int32 actionId, User user) in C:InetpubwwwrootRainbowDesktopModulesTaokeCatalogsActionsDo.ascx.cs:490 Rainbow.DesktopModules.TaokeCatalogs.Actions.Do.Page_Load(Object sender, EventArgs e) in C:InetpubwwwrootRainbowDesktopModulesTaokeCatalogsActionsDo.ascx.cs:79 System.Web.UI.Control.OnLoad(EventArgs e) +67 Rainbow.UI.WebControls.PortalModuleControl.OnLoad(EventArgs e) in C:InetpubwwwrootRainbowapp_codeRainbowUIWebControlsPortalModuleControl.cs:710 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Control.AddedControl(Control control, Int32 index) +307 System.Web.UI.ControlCollection.Add(Control child) +153 System.Web.UI.WebControls.RowControlCollection.Add(Control child) +33 DUEMETRI.UI.WebControls.DesktopPanes.CreateControlHierarchy() +1129 DUEMETRI.UI.WebControls.DesktopPanes.CreateChildControls() +27 Rainbow.UI.WebControls.DesktopPanes.CreateChildControls() in C:InetpubwwwrootRainbowapp_codeRainbowUIWebControlsDesktopPanes.cs:138 System.Web.UI.Control.EnsureChildControls() +100 System.Web.UI.Control.PreRenderRecursiveInternal() +38 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Page.ProcessRequestMain() +1489 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 |
程序員人生，我編程，我富裕，記住wfuyu網，php教程，php學習，php手冊，CMS模版制作
聲明：本站大部分內容是作者原創，少部分收集于互聯網供大家一起學習，原版權很多不明，如有侵權請聯系本站，謝謝！
粵ICP備14040726號-1?? 2015-2020 程序員人生 版權所有
