Tuesday, February 19, 2008

MS Project 2007 :: Corrupted Tasks

How do you know if your Project has a corrupted tasks, simply the following indicators will till you if so

  1. One ore more of your resource report that his "My Taks" is showing sharepoint error message
    my tasks error
  2. If you know how to query your database (Published DB of your server) and get unfortunately one row at lease

    SELECT MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.TASK_NAME,
    MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS_SAVED.ASSN_UID,
    MSP_ASSIGNMENTS_SAVED.PROJ_UID,
    MSP_ASSIGNMENTS_SAVED.TASK_UID, MSP_ASSIGNMENTS_SAVED.RES_UID
    FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
    MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
    MSP_PROJECTS.PROJ_UID INNER JOIN
    MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
    MSP_RESOURCES.RES_UID
    WHERE (NOT EXISTS
    (SELECT TASK_UID
    FROM MSP_TASKS_SAVED
    WHERE (TASK_UID =
    MSP_ASSIGNMENTS_SAVED.TASK_UID)))

     

    Then to resolve this issue do the following

  • Open Gantt View, Insert "Publish" column, and select No for the task that you got from the above query
  • Publish your project
  • Again Gantt View, For the  "Publish" column, and select "Yes" for the task that you got from the above query
  • Publish you project

Best Regards

Bilal Okour

6 comments:

Ravisat said...

Great Stuff - I was struggling this for the last 2 days.

This just worked in 2 minutes.

Regards
Ravi
http://silicus.blogspot.com

Bilal Okour said...

Great !
I am really glad to know that this post helped you
best regards
bilal okour

mks said...

Thank You, this is work but i think it not logic to do this,
why this problem happend,

Bilal Okour said...

you are 100% right
but simply it is a bug, so no need to search for the logic behind it

best regards
Bilal Okour

Frank said...

Dear Bilal,

Your solution has helped me a lot...in the past. Since this week the problem (my task screen gone)popped up again but the query does not give me any results!
A thing that has changed between the past and now is that we installed the infrastucture update. Can you help me with this ?

DBA said...

thanks...