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

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.

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.

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