none
Updating MSP_VIEW_RES tables in Project Server 2003 RRS feed

  • Question

  • Here is our problem.  For Project Server 2003, when we add a new resource to the Enterprise Resource Pool, the following tables MSP_VIEW_RES_CF, MSP_VIEW_RES_ENT and MSP_VIEW_RES_STD are not being updated, which interns does not update the information in the Resource Center when attempting to View Entrerprise Resources in Resource Center.  what is also happening is the in each table it has skipped an entry and also is adding a row for the ResourceUniqueID that is at least two entries ahead what should be the next number.

    Here is an example of the missing entry:  ResourceUniqueID 1386 is missing.

     CF_ResourceUniqueID
    1388
    1387
    1385
    1384
    1383
    1382
    1381
    1380
    1379     

     And in some cases it will add a ResouceUniqueID of 1390 to this table when the next entry should be 1389.

    What should I do to fix this probem.

    Tuesday, February 4, 2014 5:16 PM

All replies

  • How are you adding resources?

    why are you concerned with the numbering?

    how did the resources that are numbered get in there? 

    give us some details, perahps we can help.

    BTW: time for an upgrade, no?


    Thanks, Eric S. Pcubed

    Monday, March 24, 2014 11:54 PM
  • We add resources via the Enterprise global resource pool.  the numbers are the ResourceUniqueID numbers created by Project.  The reason we are concerned is that when the numbers have been skipped the information we enter does not show up in the MSP_View_Res tables and the table MSP_View_Res_Ent is used for when we pull our timesheet info from the EPK portion.   If the information is not in the table the timesheet info is not pulled then the timesheet info does not get pulled.  What I have been doing is entering the info into our test version of Project and then importing the data into the Production version for the tables MSP_View_Res_Cf, MSP_View_Res_ent and MSP_View_Res_Std.  Also since the data is not showing up in these tables the information does not show up in any of our views in the Resource Center.  This problem is also affecting any current or previous resources if they are reactivated or we change any our their info such as RBS.

    As to upgrading - we had looked at it but in this coming October we will be going to a different system for time tracking.

    Tuesday, March 25, 2014 1:42 PM
  • Just a quick note Project Server 2003 will be out of support from 8th April 2014. I would suggest that you look into the options to migrate to the newer version of Project Server.

    Project 2003 and Project Server 2003: End of Support Life Announcement http://blogs.technet.com/b/projectsupport/archive/2014/02/25/project-2003-and-project-server-2003-end-of-support-life-announcement.aspx


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.


    Tuesday, March 25, 2014 2:06 PM