disconnected assignment

B

Bob

We have a couple of users that have tasks in their timesheet. They have also
entered time to the assignment. The problem is that the task doesn't show up
in the project when using Project Professional.

This project was originally created and managed by someone who no longer
works here and the project was assigned to another pm. The new pm republished
the entire project and assumed management responsibilities.

The aforementioned assignments remained tied to the previous pm and still
didn't show up in the project. I used sql to assign the 'lost' assignments to
the new pm. This allowed him to see the assignment and work in his 'updates'
list, and let him accept the time. The task is still not in the Project
database. We tried synching etc.

I ran some queries on the database and found the assignment in the web
database, but it isn't in the project database. I at least thought I'd find a
task marked deleted or something.

Does anyone have any suggestions on how to link these together again?

Thanks.
 
G

Gary L. Chefetz [MVP]

I suggest that you delete the orphaned assignments in the database and
recreate the tasks in the Project if they are necessary. Apparently your
previous PM didn't think that the tasks were necessary and deleted them
before he closed out the assignments, leaving the orphans behind.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 
B

Bob

Thanks Gary. After playing detective yesterday, that's the same conclusion I
came to. Of course the new PM isn't overly joyed with the fix, but, at least
it's a fix.
 
C

Calvin

I have this problem also. I have identified the orphaned assignments in the
MSP_Web_Assignments table. Is this the only table that I will need to delete
entries from or are there other related tables that will need deletions also?

Thanks.
 
Top