locked
Cannot delete list items made prior to a certain date RRS feed

  • Question

  • A few days ago one of our SharePoint designers approached me with a problem with a custom list. He could not delete a certain item from the list. After troubleshooting it for a while, we determined that any list item made prior to 10/31/2010 cannot be deleted. These list items can be edited without trouble. List items created after that date have no problem with deletion. Other custom lists do not exhibit this issue. Also, no configuration changes or updates were made to the server on that date. Our last round of updates happened earlier in the month of October.

    I have so far tried rebooting the server and re-indexing the database (only because doing so in QuickBooks seems to fix a lot of issues).

    This is SharePoint Server 2007 SP2 Standard on Windows Server 2003 R2 Enterprise with SQL Server 2008 Standard. Everything is in a 32-bit environment. We have ample freespace on all connected drives.

    I am fairly new to troubleshooting SharePoint issues, so I'll be frank that I may need some hand holding. Could one of you please offer assistance?

    Saturday, November 6, 2010 3:39 PM

Answers

  • I just closed our case with PSS. Apparently there was some data corruption in the list. My support specialist was able to take the data (it was only about 6 MB), fix it on their end, and send it back to me.

    • Marked as answer by Dustin_Dallas Monday, November 22, 2010 6:05 PM
    Monday, November 22, 2010 6:05 PM

All replies

  • > I have so far tried rebooting the server and re-indexing the database (only because doing so in QuickBooks seems to fix a lot of issues).

    I'm curious, how did you "reindex" SharePoint?

     

    > one of our SharePoint designers

    Does this list have any workflows or event receivers attached?  What kind of design do these designers do?  Branding only? Visual Studio code development?

     

    > I am fairly new to troubleshooting SharePoint issue

    Have you checked your logs? Both the SharePoint logs (C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS) and the Windows event logs?

     


    Mike Smith TechTrainingNotes.blogspot.com
    Saturday, November 6, 2010 3:52 PM
  • It might also help if you said what happens when the user tries to delete.  Is the option missing entirely?  Is it silently failing?  Etc.
    --Paul Galvin, Computer Generated Solutions (CGS)
      Microsoft MVP - SharePoint
      Blogging @ http://www.mstechblogs.com/paul
      Twitter @ http://www.twitter.com/pagalvin
    Sunday, November 7, 2010 11:45 AM
  • Hi,

     

    As Mike and Paul mentioned, please provide more information about this issue.

    Without enough information as to what is happening, this is going to be hard to troubleshoot.

     

    Additionally please try to create new list and check whether you can reproduce this issue.

     

    Thanks!

    Stanfford

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com


    Everything will be fine.
    Monday, November 8, 2010 5:03 AM
  • HI Dustin_Dallas,

    Any updates about your issue?

    Thanks!

    Stanfford

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com


    Everything will be fine.
    Wednesday, November 10, 2010 7:50 AM
  • I'm sorry, everyone. I marked the thread to alert me via e-mail when there was a reply, but I never received any e-mail alerts.

    Mike, I re-indexed the SharePoint database using the SQL Server 2008 Management Studio. I created a run-once maintenance task to do so. There is a workflow attached to the list that was created using SharePoint Designer 2007. None of the designers have access to Visual Studio. They are responsible for branding, building custom lists, and creating workflows using the Designer application. In the SharePoint logs on the C: drive, this is presented every time the deletion attempt fails. "11/11/2010 14:11:00.56 | w3wp.exe (0x1438) | 0x19F4 | Windows SharePoint Services | General |8kh7 | High | Cannot complete this action.  Please try again." I have added pipe characters between columns. There are no entries in the application or system event logs for these timestamps. The closest entry is about an hour ago related to Office Server Search completing a master merge.

    Paul, when the user tries to delete any of the items created prior to 10/31/2010 an error message is displayed. "Error - Cannot complete this action. - Please try again."

    Stanfford, I created a new custom list without any workflows attached under the same site, and I was able to create and delete items at will from it.

    Thank you all for responding, and I once again apologize for the delay in answering your questions.

    Thursday, November 11, 2010 8:20 PM
  • Hi,

     

    Thanks for your update.

    It’s really hard to reproduce your issue in my local. I would like you to do some testing and narrow down this issue.

    As you said, there is a custom workflow attached in this list. When you delete the item created prior to 10/31/2010,

    Is  the workflow running for this item? If true, can you terminate this workflow for the item, do delete operation for this item

    and check whether the error happens .


    Everything will be fine.
    Friday, November 12, 2010 3:37 AM
  • I show there are no currently running workflows for any of the items that can't be deleted. Each item has a single completed workflow listed.

    I also need to correct myself from my previous reply. There are actually three workflows for this custom list. One workflow creates various tasks based on the information entered into the list item by the end-user, one workflow handles dates that fall on holidays, and one workflow marks tasks as completed that have a completed date entered (end-users have often forgotten to choose "Completed" from the drop-down list).

    Friday, November 12, 2010 4:57 PM
  • Do you have any other thoughts on the matter? I generally don't like to bump threads, but I haven't heard anything since Friday.

    Tuesday, November 16, 2010 9:13 PM
  • Hi Dustin,

    When this designer attempts to delete the item, we need to see what is happening behind the scenes.

    Here are my suggestions.

    1. Turn on stack trace (http://blogs.msdn.com/b/souravd/archive/2009/06/23/sharepoint-2007-moss-2007-enable-stack-trace-for-better-logging-information.aspx)

    2. Gather ULS logs in verbose format and correlate the time of when the user tries to delete the item.

    Let us know with the above come up with.

     


    Regards, Savoeurn Va Microsoft Online Community Support
    Friday, November 19, 2010 3:49 PM
  • Thank you for the reply, Savoeurn.

    I am now working with a Microsoft product support specialist over the phone on this issue. I will post back with the solution so others may benefit from it in the future.

    Friday, November 19, 2010 4:21 PM
  • I just closed our case with PSS. Apparently there was some data corruption in the list. My support specialist was able to take the data (it was only about 6 MB), fix it on their end, and send it back to me.

    • Marked as answer by Dustin_Dallas Monday, November 22, 2010 6:05 PM
    Monday, November 22, 2010 6:05 PM