Phantom Project in Reporting Database RRS feed

  • Question

  • I have discovered that there is a phantom or duplicate project in the Project Server reporting database, which does not exist in the other (working, draft, archive) databases.  The duplicate projects have the same ProjectName but different UIDs. The phantom project also associated tasks & assignments. The only significant effect this is having is that reports & queries are displaying this extra information or including it in totals.  In the meantime I have excluded this data by filtering out the project UID in the views I have created for users to report from.

    Is there a way to resychronise the reporting database, or clean out this erroneous data ? I have already tried deleting & recreating the project I can see through PWA but this hasn't made any difference.

    Thursday, August 12, 2010 8:43 PM