|
|
Rank: Enthusiast
Joined: 8/5/2008
Posts: 25
|
When trying to empty the recycle bin, i select the box to delete the item and press the Empty Trashcan button. then i get this error:
the server method 'EmptyTrashcan' failed with the following error: System.data.sqlClient.sqlException-- string or binary data would be truncated. The statement has been terminated.
Anyone have any ideas on this one.
The trashcan was working a few days ago. i don't know what the issue is. since then i have also backed up and restored the database on another server and that server gives the same error.
Thanks
umbracoNewb
|
|
Rank: Addict
Joined: 9/27/2007
Posts: 977
Location: Belgium
|
Hi umbracoNewb, Fire up SQL Profiler to find out the exact statement that is throwing the exception. And report on Codeplex if it's a bug! Regards, /Dirk
level 1 certified - umbraco blog at netaddicts.be - working on an integrated forum4umbraco
|
|
Rank: Enthusiast
Joined: 8/5/2008
Posts: 25
|
I apologize i do not know much about SQL Profiler. I just installed the standard version of SQL 2005 so i could use this. i have the Profiler running and i am only tracing the Errors so it is a little easier to see when this happens. what should i be looking for in the trace to help with this problem? I get an error ID of 8152 if that helps at all.
|
|
Rank: Addict
Joined: 9/27/2007
Posts: 977
Location: Belgium
|
It would be great if you trace the exact sql statement throwing the error. Just start SQL Profiler just before you empty the trashcan, and stop it again as soon as the error pops up. Dump the output here so we can have a look at it here. We'll soon find out what is causing the problem here! Greetz, /Dirk
level 1 certified - umbraco blog at netaddicts.be - working on an integrated forum4umbraco
|
|
Rank: Enthusiast
Joined: 8/5/2008
Posts: 25
|
How do i get the Profiler Trace to output in a text format. right now when i try to copy the rows not all the information is copied and it is in a terrible format.
|
|
Rank: Addict
Joined: 9/27/2007
Posts: 977
Location: Belgium
|
I'm not completely sure, but I think you can dump the trace output to a text file? /Dirk
level 1 certified - umbraco blog at netaddicts.be - working on an integrated forum4umbraco
|
|
Rank: Enthusiast
Joined: 8/5/2008
Posts: 25
|
ok. I was able to output some xml. so here is the part where the trashcan had errors.
<Events>
<Event id="65534" name="Trace Start">
<Column id="14" name="StartTime">2008-08-14T08:49:23.017-05:00</Column>
</Event>
<Event id="33" name="Exception">
<Column id="31" name="Error">8152</Column>
<Column id="4" name="TransactionID">227473</Column>
<Column id="8" name="HostName">LocalHost</Column>
<Column id="12" name="SPID">51</Column>
<Column id="20" name="Severity">16</Column>
<Column id="64" name="SessionLoginName">loginName</Column>
<Column id="1" name="TextData">Error: 8152, Severity: 16, State: 4</Column>
<Column id="9" name="ClientProcessID">4900</Column>
<Column id="41" name="LoginSid"></Column>
<Column id="49" name="RequestID">0</Column>
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="14" name="StartTime">2008-08-14T08:49:24.843-05:00</Column>
<Column id="26" name="ServerName">ServerName</Column>
<Column id="30" name="State">4</Column>
<Column id="50" name="XactSequence">219043332134</Column>
<Column id="3" name="DatabaseID">5</Column>
<Column id="11" name="LoginName">LoginName</Column>
<Column id="35" name="DatabaseName">DataBaseName</Column>
<Column id="51" name="EventSequence">55272</Column>
</Event>
<Event id="162" name="User Error Message">
<Column id="31" name="Error">8152</Column>
<Column id="4" name="TransactionID">227473</Column>
<Column id="8" name="HostName">localHost</Column>
<Column id="12" name="SPID">51</Column>
<Column id="20" name="Severity">16</Column>
<Column id="64" name="SessionLoginName">loginName</Column>
<Column id="1" name="TextData">String or binary data would be truncated.</Column>
<Column id="9" name="ClientProcessID">4900</Column>
<Column id="41" name="LoginSid"></Column>
<Column id="49" name="RequestID">0</Column>
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="14" name="StartTime">2008-08-14T08:49:24.843-05:00</Column>
<Column id="26" name="ServerName">serverName</Column>
<Column id="30" name="State">4</Column>
<Column id="50" name="XactSequence">219043332134</Column>
<Column id="3" name="DatabaseID">5</Column>
<Column id="11" name="LoginName">loginName</Column>
<Column id="35" name="DatabaseName">DatabaseName</Column>
<Column id="51" name="EventSequence">55273</Column>
</Event>
<Event id="162" name="User Error Message">
<Column id="31" name="Error">3621</Column>
<Column id="8" name="HostName">localHost</Column>
<Column id="12" name="SPID">51</Column>
<Column id="20" name="Severity">10</Column>
<Column id="64" name="SessionLoginName">loginName</Column>
<Column id="1" name="TextData">The statement has been terminated.</Column>
<Column id="9" name="ClientProcessID">4900</Column>
<Column id="41" name="LoginSid"></Column>
<Column id="49" name="RequestID">0</Column>
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="14" name="StartTime">2008-08-14T08:49:24.843-05:00</Column>
<Column id="26" name="ServerName">serverName</Column>
<Column id="30" name="State">0</Column>
<Column id="50" name="XactSequence">0</Column>
<Column id="3" name="DatabaseID">5</Column>
<Column id="11" name="LoginName">loginName</Column>
<Column id="35" name="DatabaseName">DatabaseName</Column>
<Column id="51" name="EventSequence">55274</Column>
</Event>
<Event id="65533" name="Trace Stop">
<Column id="14" name="StartTime">2008-08-14T08:49:29.127-05:00</Column>
</Event>
</Events>
I hope this helps some.
|
|
Rank: Addict
Joined: 9/27/2007
Posts: 977
Location: Belgium
|
Hmm, isn't much of a help currently. I'd like to be of more help, but you"ll have to pinpoint the exact sql statement that troubles the system first before we can think of a solution. Could you tell us more about what you've deleted? Probably a content node of some sort of document type? What document type? What are the properties? What type of properties? Have screenshots as well? Might be related to the length of some property, or the node name? Feed us with as much info as possible! Regards, /Dirk
level 1 certified - umbraco blog at netaddicts.be - working on an integrated forum4umbraco
|
|
|
Guest |