none
TaskUID in MSP_EpmTask and MSP_TimesheetTask is not the same RRS feed

  • Question

  • I found some assignments with different TaskUID in the table "pub.MSP_TIMESHEET_LINES" and MSP_EpmAssignment of the same assignmentuid.

    Is it by design? And by the way, I also see some task uid in MSP_TimesheetTask but not in MSP_EpmTask table, should this be normal?


    Kevin Li

    Monday, April 13, 2015 10:19 AM

All replies

  • Hello,

    Have you by any chance deleted projects out of the system then imported them again etc.? This process will create "orphaned" tasks in the timesheet tables.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Monday, April 13, 2015 12:55 PM
    Moderator
  • Yes, this might be the cause. But the issue is the AssignmentUID in the Timesheet table linked to another task that exists in the system.

    Let say, we have an AssignmentUID A1, in pub.MSP_TIMESHEET_LINES table, its taskuid is T1, but in MSP_EpmAssignment, its taskuid is T2, and T1 is the orphaned task, but T2 is a valid task.

    If it's caused by task deleting, from my understanding, the assignment will be deleted as well, and will not link to another task.


    Kevin Li

    Tuesday, April 14, 2015 6:24 AM