none
Project Server 2010 - Task UID is null RRS feed

  • Question

  • We are using Project Server 2010 and have discovered that there are MANY MANY tasks without a Task UID.  They do have assignments with hours against them. Any idea how tasks are in the tables and being used but they don't have a UID?

    Collin

    Friday, July 12, 2013 9:45 PM

Answers

  • The following script can be helpful to find all such tasks in current databases. Please run it on Published database:

    select MSProj.PROJ_NAME, AssnSaved.TASK_NAME, MSProj.PROJ_PROP_AUTHOR,Assnsaved.ASSN_UID
    from MSP_ASSIGNMENTS_SAVED as AssnSaved
    left join MSP_TASKS_SAVED as TaskSaved
    on AssnSaved.Task_UID = TaskSaved.Task_UID
    inner join MSP_PROJECTS as MSProj
    on AssnSaved.PROJ_UID = MSProj.PROJ_UID
    where TaskSaved.TASK_UID is null

    To resolve this issue, please try to republish the task with the following steps:

    1. Ask Project Manager to open the above project plan in Project Professional.
    2. Switch to “Enterprise Gantt Chart” view, and insert “Publish” field.
    3. Locate the above task, and change its “Publish” value from “Yes” to “No”.
    4. Save and publish the project plan.
    5. Go back to Project Professional, and for the same task, change its “Publish” value from “No” to “Yes”.
    6. Save and publish the project plan.


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.


    Tuesday, July 16, 2013 7:03 PM
    Moderator

All replies

  • The following script can be helpful to find all such tasks in current databases. Please run it on Published database:

    select MSProj.PROJ_NAME, AssnSaved.TASK_NAME, MSProj.PROJ_PROP_AUTHOR,Assnsaved.ASSN_UID
    from MSP_ASSIGNMENTS_SAVED as AssnSaved
    left join MSP_TASKS_SAVED as TaskSaved
    on AssnSaved.Task_UID = TaskSaved.Task_UID
    inner join MSP_PROJECTS as MSProj
    on AssnSaved.PROJ_UID = MSProj.PROJ_UID
    where TaskSaved.TASK_UID is null

    To resolve this issue, please try to republish the task with the following steps:

    1. Ask Project Manager to open the above project plan in Project Professional.
    2. Switch to “Enterprise Gantt Chart” view, and insert “Publish” field.
    3. Locate the above task, and change its “Publish” value from “Yes” to “No”.
    4. Save and publish the project plan.
    5. Go back to Project Professional, and for the same task, change its “Publish” value from “No” to “Yes”.
    6. Save and publish the project plan.


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.


    Tuesday, July 16, 2013 7:03 PM
    Moderator
  • We did figure out how this is happening.  I have a full explanation here:  http://dld.bz/cJ8Kv

    Collin

    Tuesday, July 23, 2013 9:10 PM