.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Event ID 5586 when deleting items from Admin recycle bin

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :SharePoint

We have one WFE running MOSS 2007 August 2009 Cumulative Update, one Index Server(same MOSS version) and a separate SQL server 2005 SP2 64 bit.

Attempting to delete items from Admin recycle bin, get a SharePoint Unknown Error. Application log has this entry:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 5586
Date:  9/30/2010
Time:  6:58:28 AM
User:  N/A
Computer: servername
Unknown SQL Exception 515 occured. Additional error information from SQL Server is included below.

Cannot insert the value NULL into column 'DiskUsed', table 'databasename.dbo.SiteQuota'; column does not allow nulls. INSERT fails.
The statement has been terminated..

Any ideas of how to fix this?

Thanks in advance!

View Complete Post

More Related Resource Links

Deleting items from the index (custom protocol handler)

I created a custom protocol handler. I successfully emit entries into the index. I just can't seem to delete them during an incremental crawl.

I tried:

1. no emitting child item during the enumeration of child entries in a folder
2. returning PRTH_E_OBJ_NOT_FOUND from CreateAccessorEx

doing either 1, 2, or both did nothing. The entries are still there.

what i need to do to delete these entries from the index during an incremental crawl?


Can't see items in the recycle bin

I cannot see items in the recycle bin, but others can see items there.  I am an owner of the site and this there are no modifications to the default master page.  Anyone know what is going on here?

Event ID 6398 and 5586 (SharePoint 2010)


I have configured Search on a Single Farm SharePoint 2010 server on Windows Server 2008 R2. The crawls are working and I’m getting results on a search page, but the event log creates these two events every minute:

Critical Event 6398

The Execute method of job definition Microsoft.Office.Server.Search.Monitoring.HealthStatUpdateJobDefinition (ID 151f6f19-594d-4ba8-ab82-0b187839325a) threw an exception. More information is included below.

Could not find stored procedure 'dbo.Search_GetRecentStats'.


Error Event 5586

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Recycle bin, how can one see items deleted by others ?



When I have contribute rights I can delete items from a list/library.
I'll find these items when I open the recycle bin.

When a colleague of mine checks the list/library he doesn't find the item I deleted.
When he opens the recycle bin, he doesn't see the item there.

How can I change this behavior? It would be nearly impossible to search who deleted something in order to ask them to restore it, and it shouldn't be something to ask the site collection administrator each time because it's a basic task for end users.

Deleting items simultaneously in two different site library


Hi experts,

I have create a workflow to copy item (documents)  in site A library to site B library, its worked fine when i run the workflow, both library can contains same documents.

But the problem is, i can't set the workflow to deleting both items. I create a delete item workflow but it doesnt work for both, it can only work for 1 library. Is there possibility for me to create a workflow that can delete both item when i run the workflow in designated library, for example, from Site A, i run a workflow to delete a document in Site A, which will delete in Site B too.

I have googled but i can't find the best way, might as well you familiar with the works and can guide me.

Thanks so much! 

Deleting items from a list based on a stored procedure

          foreach (SPListItem listItem in collListItems)
            var result = db.sp_MOSSCloseCase(Convert.ToInt32(listItem["Case Number"]));
            if (result == listItem["Case Number"])


Obviously I can't delete items in a collection within a Foreach loop. Problem is that the stored procedure is to return the case number in the DB only if there is a completed date(case being closed). So i thought if (result != null) then move the result to a List or something. Then go through the list and delete items where results = item["Case Number"] but result is never null... nor does it ever == listItem["Case Number"]


For the life of me, I cannot figure out how to get the result values into a list and then delete them from the SPList.

Need to Remove Event Log Error after deleting a database sharepoint 2010


I deleted a couple of databases  fron SQL after recreating  the service application. I am getting event log errors  ID 3760 that these db's are unable to be located.

How do I remove the trigger that is making this error apear?

I have looked all through CA but unable to figuer it out.

jQuery: Styling DropDownList Alternating Items (Rows)

In the following example, I will show how you can style any asp:dropdownlist very easily.

The example demonstrates how you can change alternating row items background color, using the fadeTo() to add a nice touch in the dropdownlist. You can change alt rows with a couple lines.

Hide a repeater in ASP.NET C# if the DataSource contains no items?

I have an ASP.NET page that uses a repeater nested within another repeater to generate a listing of data. It's to the effect of the following:
In the (C#) code-behind I'm basically using LINQ to pull a listing of information from an XML document and bind that information to the first repeater.

Searching for the answer to this, it seems the method is to determine whether the data for the nested repeater is empty. If it is, then you set the visibility of the repeater to false.

Creating SharePoint items with CreateItemActivity

Instead of creating new list items from code in your workflow you can use CreateItemActivity. CreateItemActivity can be used for creating list items or files. Properties of interest for this activity are the following (most of them are self-explanatory):

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

HttpContext.Items and Server.Transfer/Execute

The problem was basically that when a Server.Transfer call was applied the script container (and also various ClientScriptProxy script embedding routines) would potentially fail to load up the specified scripts.

Radio Button Event

Here I have explained the events of radio button with javascript.
Let me explain the scenarion first,
We are having two radio button say radioobtn1 and radiobtn2. If I click on the button 1 then I need to show one DIVor FORM. same as when I click on radiobtn 2. I have given the code for the above scenarion.

Adding Client-Side Confirmation When Deleting

The JavaScript confirm(string) function displays its string input parameter as the text inside a modal dialog box that comes equipped with two buttons - OK and Cancel (see Figure 1). The confirm(string) function returns a Boolean value depending on what button is clicked (true, if the user clicks OK, and false if they click Cancel).

Get pixel format, raw format, property id list and property items image in VB.net - C#.net.

n this simple article you will learn that how we can get pixel format, raw format, property id list and property items image in VB and C#.net.

Get Pixel Format:

Image consists of pixels to get the format of the pixel we have a property named pixel format. This property returns an enumeration of pixel format. This enumeration tells the pixel format.

To demonstrate make a window application. Drag one button and a picture box on form.

Now write the following code on Button click event:

how to impose javascript event processing?


If I have some form control like textbox and I want the event handler to be located in the html instead of at the server side, how to do that? Of course I can copy paste javascript code in the aspx file. But is it possible to do that using some object oriented approach (ie programmatically in the code behind)?


ListViewControl - how to group items by their value, for eg. date range



I have a table containing courses, columns are 

Name - "Yoga Classes"

DateStart - "2/23/2010"

DateEnd - "2/24/2010"

I am using ListView Control to bind it, is there a way to display them and group them by Month? 

for eg.


Piano Class (10th Jan 2010 - 11th Jan 2010)
Guitar Class (10th Jan 2010 - 11th Jan 2010)


Yoga Class (15th Feb 2010 - 16th Feb 2010)

Thanks for help.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend