locked
Duplicate task IDin RRS feed

  • Question

  • I have a page setup for gantt view and i notice there is duplicate tasks in the view. I have verified that is actually duplicate because I see two tasks with the same ID.  Anyone knows if this is a bug or how to fix it?

     

    I'm running MOSS2007 with version 12.0.0.6421

    Wednesday, May 18, 2011 10:00 PM

All replies

  • I had never heard of such things as duplicate list item id. For troubleshooting purpose, you can run the following SQL Query in your content database:

     

    SELECT     Webs.FullUrl, AllLists.tp_Title, AllUserData.*

    FROM         AllLists INNER JOIN

                          Webs ON AllLists.tp_WebId = Webs.Id INNER JOIN

                          AllUserData ON AllLists.tp_ID = AllUserData.tp_ListId

    WHERE     (AllLists.tp_Title = N'Tasks')

     

    Note that running this query directly in production system is not supported, please backup your SharePoint content database and restore it into the test system and run the query in test system.

     

    And you may shall change the WHERE clause in the query to filter with your site url (Webs.FullUrl) and task list name(AllLists.tp_Title)

     

    Different lists of cause will have duplicate value in AllUserData.tp_ID field, but there won't be duplicates in the same list.

    • Marked as answer by GuYuming Wednesday, May 25, 2011 5:30 AM
    • Unmarked as answer by Mike Walsh FIN Friday, June 10, 2011 5:28 AM
    Thursday, May 19, 2011 2:48 AM
  • Hello,

    Thanks for the code. I do not see duplciate ID in the database but why is it that I see it in the gantt view?

    Thanks,

    Tin Cao

    Thursday, June 9, 2011 11:40 PM