This discussion is archived
2 Replies Latest reply: Sep 14, 2011 5:29 PM by 888310 RSS

PT 8.51 Upgrade - How to find duplicate keys for Portal Registry Structure?

user3242117 Newbie
Currently Being Moderated
I am upgrading peopletools for two applications (CRM 9.00 and FDM 9.00) from the 8.48.10 to 8.51.11 versions.

For CRM, Task 4-15-9 Completing the Peopletools Conversion ran app engine PTUPGCONVERT ran smoothly.

For FDM, I have the following error messages:

The Navigation Pagelet does not exist. Portal = EMPLOYEE. Object = PT_SC_PGT_MAIN_MENU. Collection = PT_PTPP_PORTAL_ROOT (219,2083)
Message Set Number: 219
Message Number: 2083
Message Reason: The Navigation Pagelet does not exist. Portal = EMPLOYEE. Object = PT_SC_PGT_MAIN_MENU. Collection = PT_PTPP_PORTAL_ROOT (219,2083)

Duplicate key. Portal: EMPLOYEE, Obj Name: PT_SC_PGT_MAIN_MENU, Nodename: LOCAL_NODE, URL: s/WEBLIB_PTPP_SC.HOMEPAGE.FieldFormula.IScript_SCP (133,4)

PT_SC_PGT_MAIN_MENU already exists. (96,3)

Copy of the Main Menu Pagelet From PS_SITETEMPLATE to Portal: EMPLOYEE failed. (219,2111)
Message Set Number: 219
Message Number: 2111
Message Reason: Copy of the Main Menu Pagelet From PS_SITETEMPLATE to Portal: EMPLOYEE failed. (219,2111)

I checked table PSPRSMDEFN which does not have an entry for PT_SC_PGT_MAIN_MENU, under the Employee Portal. I tried to migrate the missing Portal Registry object using App Designer but again receive the "duplicate key" error.

So it seems that I have to find the duplicate key and resolve it before I can migrate the missing object.


Anyone know a quick way to figure out what the duplicate keys are?


Thanks
  • 1. Re: PT 8.51 Upgrade - How to find duplicate keys for Portal Registry Structure?
    user3242117 Newbie
    Currently Being Moderated
    I tried several things to find the duplicates with no success.

    A couple of workarounds were attempted that resulted in the same "duplicate key" error, including:
    a) Re-copying file project PPLTLS84CUR
    b) Copy object 'PT_SC_PGT_MAIN_MENU" from Demo

    After opening an SR, the successful workaround was to use Data Mover to export from Demo the "EMPLOYEE" portal entries for "PT_SC_PGT_MAIN_MENU" from tables PSPRSMDEFN, PSPRSMSYSATTR and PSPRSMSYSATTRVL. The import to the target upgrade environment was successful. A re-run of PTUPGCONVERT finished successfully.

    The upgrade is progressing but where the duplicate keys are is still a mystery.


    Cheers
  • 2. Re: PT 8.51 Upgrade - How to find duplicate keys for Portal Registry Structure?
    888310 Newbie
    Currently Being Moderated
    looks like your target database tabel had some invalid references to the mentioned portal obect.

    there are a binch of tables where this info can be present

    PSPRSMDEFN
    PSPRSMDEFNLANG
    PSPRSMATTR
    PSPRSMATTRLANG
    PSPRSMATTRVAL
    PSPRSMATTRVALNG
    PSPRSMPERM
    PSPRSMSYSATTR
    PSPRSMSYSATTRVL
    PSPRSMHPASGPGLT
    PSPRSMSYNC
    PSPRDMDEFN
    PSPRDMDEFNLANG
    PSPRDMCNTPRV
    PSPRUHPERSPGLT

    The best possible way I can think of is to copy the PT_SC_PGT_MAIN_MENU to the target db from any db of same tools with copy option set as delete.
    This should remove any duplicates or invalid refenences..

    Regards
    Nevin

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points