This content has been marked as final. Show 2 replies
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.
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
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..