We recently upgraded from 2.0 to 3.2 and when we did we all sorts of problems with family table parts, The answer was a healing script that comes with the Intralink 3.2 CD. It took a few seconds to run on the entire database and it fixed the problem. I don't remember the name but if you call PTC and mention that phrase they will point you to it.
4) Execute the following three commands in sqlplus:
SQL> alter user pdm identified by pdm;
SQL> connect pdm/pdm
When run successfully, something similar to the following will be output to the screen
=== Please wait while script is running ...
=== Found 4 LOs with bad name.
. Recovered 4 of them.
=== Fixed 43 LOVs with bad folder.
PL/SQL procedure successfully completed.
20 rows updated.
0 rows updated.
*Note that the numbers depicted here are just examples. They will vary on each installation.
5) After the script executes and exits from sqlplus, reset the 'pdm' user password so that Pro/INTRALINK clients can connect successfully:
Change directory to the following location:
6) Execute the 'proipwd' utility to set the password back to the default value. In order to perform a full reset, the command must be executed in a shell with both arguments listed on one line as shown:
> proipwd system <system user password>
Example: > proipwd system manager
When executed properly, the following note will be displayed: