Corporation Switch User Manual

Chapter 3
Configuring PG&C
If you have the PG&C component installed, additional configuration may be needed for substance
migration.
Substance migration is necessary if you meet ALL of the following requirements:
à Upgraded your database from Agile PLM 9.2 to Agile PLM 9.2.2.1.
à Imported the JGPSSI substances and substance groups.
à In Agile PLM 9.2.2.1, you want to use IPC declarations with IPC substances and substance
groups. Note that the IPC list of substances and substance groups is slightly different than the
JGP list of substances and substance groups.
Important Contact your Agile Solutions Delivery representative to obtain the files needed for
substance migration.
If you imported the JGPSSI substances in Agile PLM 9.2, but do not want to use the IPC
substances, you can continue to use the JGPSSI substances without migrating.
Configuring PPM
With PPM objects, there should always be at least one user in the team, such as Owner. For every
user on the team, a corresponding Access Control List (ACL) in the Share should exist. In the 9.0
and 9.1 releases of Agile PLM, a logged in user was allowed to delete all users from Share which
included the owner’s ACL.
You must clean the corrupted data in the ObjectACL database table to access the shared objects.
The data cleanup involves replacing the deleted role with a valid, non-deleted equivalent role. The
following SQL statement cleans all of the corrupted rows in ObjectACL table where a deleted role is
assigned to a user with the valid role:
DELETE FROM TEAM WHERE ACTIVITY_ID<=0;
INSERT INTO OBJECTACL SELECT TEAM.activity_id,(SELECT CLASS FROM ACTIVITY WHERE
id=TEAM.activity_id),TEAM.user_id,',9506,',sysdate,sysdate FROM TEAM WHERE TEAM.user_id NOT IN
(SELECT USERID FROM OBJECTACL WHERE OBJECTACL.objid=TEAM.activity_id AND
OBJECTACL.objclass IN (18022,18387))
In the previous SQL statement, the Program Team Member role is generally assigned to a user
and the ID for this out-of-box role is 9506.
The roleid values may differ, if you have customized your database. In this case, use the following
SQL statement to obtain roleid values for each role in your database:
select ID from nodetable where parentid=5006 and value = '<name of role>';
Page - 27