Ghost entries in MSP_WEB_ASSIGNMENTS

[BananaQuaalude]

I'm seeing multiple assignments for the same resource in the
MSP_WEB_ASSIGNMENTS table. Only one assignment will be shown in the
MSPS client, but there is still data for old assignments in the web
table.

For some of these assignments, the WASSN_DELETED_IN_PROJ field has a
value of 1, instead of the norm of 0. For most, however, the ASSN_UID
is -1, meaning it doesn't match up to any assignment in
MSP_ASSIGNMENTS, and hence the client.


These entries are causing problems when I run queries to get the
WASSN_ID (web assignment ID). Also, I've noticed that the projects
that have these ghost entries are the ones that open, close, save and
publish slower than the rest. These projects have hundreds of ghost
assignments.


Does anyone know how to clean them up?


I don't see anything under Clean Up Project Server database in
Project
Web Acccess. I'm using MS Project Server 2003


Any help would be appreciated!

 

[Scott m Wagner - EPM Consulting Services]

I have seen this before myself. The only way I have been able to clean these
up (without writting a stored procedure or a small application to do this) is
to save the project offline, delete it from the server and re-import it to
the eneterprise.

I read an article on copying and pasting tasks in projects connecting to
Project Server a long while ago that spoke about these "ghosts" in the
machine as well. I will see if I can locate it and if it provides further
insight.

Thanks,

 

[BananaQuaalude]

Hmmm... the only problem with taking offline and bringing back in is I
loose all my protected actuals from time collection.

Interesting note on the cutting and pasting. I have wondered if that
cause problems and know that was the case on some of these projects.
If you find that article, please send it along.

Thanks for the feedback!