P12ACTool output. Assignments in projects without resources RRS feed

  • Question

  • The P12ACTool output shows me some projects with over 2000 assignments. However those project do not have resources. THe output has this section: Getting list of of top 15 projects with largest number of assignments.  Proj_UID, Proj_Name, Total Assns. Then it lists 6 projects with anywhere between 170 to 2492 as the total Assns.

    THe very next section in the output is "Top 30 resources with the largest number of assns" and it confirms that there are no resources with assignments.

    Just curious if I have to flush a table or what? I am worried about bloat and corruption.


    MOPS2007, SQL Server 2008R2, WinServer 2008R2
    • Edited by Quized again Thursday, January 19, 2012 8:55 PM left off details
    Thursday, January 19, 2012 8:35 PM

All replies

  • Hi Quized,

    can you check in reporting database in MSP_EPMAssignment_UserView with a simple query grouping count(assignmentUid) for all projectuid?

    Do you get same results?

    I hope this can helps you,

    Best Regards,

    Paolo O.

    Saturday, January 21, 2012 11:31 AM
  • Sorry Paolo, but I do not know how to construct that query. Can you please tell me what it would look like?

    Thank you for your help!

    Wednesday, January 25, 2012 9:02 PM