lookup table structures conflict RRS feed

  • Question

  • One of my project file seems to have the lookup table structures conflict with the server. What happened was when I imported the project file to the server, it complained about violation of the primary key contraint for the Lookup table structures key and the import was failed.

    Can anyone one advice where I can locate the lookup table structures on the project file? I would like to remove it and see if the problem can be resolved?


    Thursday, November 1, 2012 6:32 PM

All replies

  • Hello hkg04,

    You need to go to Project -> Custom fields and look for Task and Resource fields that contains lookup tables. Also look for customized Outline Codes in the same place.

    Best regards,

    Rene Alvarez

    Rene Alvarez

    Friday, November 2, 2012 3:43 PM
  • I saw those fields but I was not able to identify which fields are causing problem. When the project client is connected to the server, the custom fields\lookup table showed under the Project catalog. The are basically from the server (those items are not available when Project client is not connected).

    I guest what I really want to know is what item\object within the project file represent the lookup table structure in MSP_Lookup_table_structures table in the the project_published database.


    Friday, November 2, 2012 6:51 PM