Developer forum

Forum » Development » Strange error when trying to delete a page

Strange error when trying to delete a page

E-mail notifications

Reply
Posted on 04/07/2008 16:32:59

Hi i got a strange error, after making a copy of a solution to make their intranet. For some reason i get this strange error. Any help would be much appriciated:

 

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: String or binary data would be truncated.
The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
   System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +1455816
   System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +41
   System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) +2037
   System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) +40
   System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) +183
   System.Data.Common.DbDataAdapter.Update(DataSet dataSet) +12
   Dynamicweb.Information.Logger.Log(Action Action, String EntityType, String Entity, String EntityID, String LocationType, String Location, String LocationID, String DestinationType, String Destination, String DestinationID) +408
   Dynamicweb.Information.Logger.Log(Action Action, EntityType EntityType, String Entity, String EntityID, EntityType LocationType, String Location, String LocationID, EntityType DestinationType, String Destination, String DestinationID) +313
   Dynamicweb.Information.Logger.ParagraphDeleted(String ParagraphName, Int32 ID, Int32 LocationID) +111
   Dynamicweb.TrashBin.MoveParagraphToTrashBin(Int32 intParagraphId, String strData, Int32 intUnitOfWork) +155
   Dynamicweb.TrashBin.MoveAllParagraphsToTrashBin(ArrayList alChilds, String strData, Int32 intUnitOfWork) +81
   Dynamicweb.TrashBin.MovePageToTrashBin(Int32 intPageId, String strData) +942
   Dynamicweb.TrashBin.MoveAllPagesToTrashBin(ArrayList alChilds, String strData) +77
   Dynamicweb.TrashBin.MoveToById(Int32 intID, String strDescription, String strData, Type typeEnum, Int32 PageID, Int32 MasterID) +143
   Dynamicweb.TrashBin.MoveToById(Int32 intID, String strDescription, String strData, Type typeEnum, Int32 MasterID) +25
   Dynamicweb.Admin.Page_Delete.Page_Load(Object sender, EventArgs e) +197
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

Server Error in '/' Application.

String or binary data would be truncated.
The statement has been terminated.

 

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

 


Replies

 
Posted on 07/07/2008 09:14:14
Reply

The error occurs when Dynamicweb logs the action.

 

I took a look at the default log database, and there are some text fields that allow 250 characters. They may conflict with another piece of information from a field where we allow 255 characters. They are in the ActionLog table (of Log.mdb if you're running MS Access). You could try to alter the field length of these fields an see what happens. If you could send me a copy of the database, or the solution is hosted by us, I'd like to see it in action.

 

Plese let me know, how it works out.

 
Posted on 07/07/2008 09:29:10
Reply
Sorensen wrote:

The error occurs when Dynamicweb logs the action.

 

I took a look at the default log database, and there are some text fields that allow 250 characters. They may conflict with another piece of information from a field where we allow 255 characters. They are in the ActionLog table (of Log.mdb if you're running MS Access). You could try to alter the field length of these fields an see what happens. If you could send me a copy of the database, or the solution is hosted by us, I'd like to see it in action.

 

Plese let me know, how it works out.


Thanks lars, ill try and look else ill give you information on database.

 
Posted on 07/07/2008 09:30:19
Reply

Sure, please keep me posted:)

 
Posted on 08/07/2008 16:16:51
Reply

hey Lars.

 

I changed the fields to nvarchar(max) and vupti all worked , thanks mate...


Also for others if you get this error its in the table called: dbo.Actionlog if you are running SQL server.

 
Posted on 08/07/2008 16:36:41
Reply

NP:)

 

You must be logged in to post in the forum