none
Resource ID in PWA 2013 RRS feed

  • Question

  • Hi,

    Some Resource ID are quite simple : 1, 2, 3, 4 ...  some other are more complex : 1,024; 1,230 ...

    Why? What does that mean ? NB: I have only 20 resources in my Resource Center.

    Thanks

    


    • Edited by WLID1966 Friday, January 16, 2015 10:43 AM
    Friday, January 16, 2015 10:40 AM

Answers

  • Project server and the database that are used to support project have a many integrated LOOKUP tables that are used for cross references.  Instead of having hundreds of lookup tables, it uses a few lookup that's that all the lookup records share.

    The enterprise resource table is just another lookup table but when records are created in this table.  When a new record is created in the resource database, it must also get a unque record ID from the master lookup table and thus you may get 4,5,6 for a group of resources, and then 1200,1201, 1202 for the next group of records.

    In between this time, you may have updated tables in the enterprise custom field, or new projects or whatever, and each time you add records in these minor lookup tables, the UID is increated in the master lookup table.

    I believe the master lookup table is lookup in the undocumented PUBLISHED table base, and will have LOOKUP somewhere in the name or METADATA. 


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by WLID1966 Saturday, January 17, 2015 4:49 PM
    Saturday, January 17, 2015 4:36 PM
    Moderator

All replies

  • Hi,

    The resources ID is incremental. I suspect that you previously had more than 1000 resources some times ago and some of them have been deleted. In this case it would be normal to have those different ID.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Friday, January 16, 2015 12:15 PM
    Moderator
  • Thanks Guillaume,

    But, AFAIK, I never used more than 20 resources...

    Friday, January 16, 2015 12:23 PM
  • Are you sure you never had other resources such as generic or cost resources? Note that all types of resources are incremented with the resource ID.

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Friday, January 16, 2015 12:40 PM
    Moderator
  • The numbers are not reused, so if you  have done a lot of deleting and recreating perhaps?

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by WLID1966 Saturday, January 17, 2015 4:48 PM
    • Unmarked as answer by WLID1966 Saturday, January 17, 2015 4:48 PM
    Friday, January 16, 2015 11:10 PM
    Moderator
  • In the past, I deleted 2 resources and inactivate one another. That's all.
    Saturday, January 17, 2015 2:48 PM
  • Project server and the database that are used to support project have a many integrated LOOKUP tables that are used for cross references.  Instead of having hundreds of lookup tables, it uses a few lookup that's that all the lookup records share.

    The enterprise resource table is just another lookup table but when records are created in this table.  When a new record is created in the resource database, it must also get a unque record ID from the master lookup table and thus you may get 4,5,6 for a group of resources, and then 1200,1201, 1202 for the next group of records.

    In between this time, you may have updated tables in the enterprise custom field, or new projects or whatever, and each time you add records in these minor lookup tables, the UID is increated in the master lookup table.

    I believe the master lookup table is lookup in the undocumented PUBLISHED table base, and will have LOOKUP somewhere in the name or METADATA. 


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by WLID1966 Saturday, January 17, 2015 4:49 PM
    Saturday, January 17, 2015 4:36 PM
    Moderator
  • Michael,

    Thanks a lot for this detailed explanation!

    Saturday, January 17, 2015 4:50 PM
  • To check:

    It seems that the Add Resources / Import Resources to Enterprise feature increases the resource ID by 1000 each time!

    Saturday, January 24, 2015 2:13 PM