Hallo,
ProPDM Umsteiger (d.h. wenn irgendwann von PDM auf Intralink konvertiert wurde) sollten sich folgendes mal anschauen.
Release 3.3
TAN 122293
Datecode: 2002470
Description
-----------------
Upgrading to 3.3 or running convert_update may cause the vault path/hash name of some legacy Pro/PDM objects converted via Pro/CONVERT to change. Some objects may fail checkout or regeneration as incorrect file content may be brought into the Workspace. This TAN is for customers who have upgraded to Pro/INTRALINK From Pro/PDM using Pro/CONVERT. Please refer to the scenarios listed in the Resolution to determine if your installation is affected and how to resolve the issue.
Examples of the issue are as follows:
Prior to running convert_update or upgrading to 3.3, the following objects and paths to content exist:
widget.prt 7777@fileserver1:c:\ptc\pdm_vault1\C12345
sprocket.prt 7777@fileserver2:d:\ptc\pdm_vault2\C12345
Upgrading to 3.3 may have changed the vault path of one object to match that of the other object (the second object may now be incorrectly referenced in the vault):
widget.prt 7777@fileserver1:c:\ptc\pdm_vault1\C12345
sprocket.prt 7777@fileserver1:c:\ptc\pdm_vault1\C12345
Running convert_update may have changed the hash names of both objects to standard sequential hash numbers. In each case the metadata was updated but when the scripts were created to rename the files in the vault, one of the objects may not have been included (it may still be named Cxxxxx in the vault).
widget.prt 7777@fileserver1:c:\ptc\pdm_vault1\67890.prt
sprocket.prt 7777@fileserver2:d:\ptc\pdm_vault2\67890.prt
See TANs 115838 (http://www.ptc.com/cs/tan/115838.htm) and 113846 (http://www.ptc.com/cs/tan/113846.htm) for more information regarding the convert_update utility.
Alternate Technique
-----------------
See the Resolution.
Resolution
-----------------
The resolution of this issue is dependent upon the state of the converted legacy objects. Match the state of the implementation to one of the following scenarios in order to determine if the issue exists. Resolve the issue by following the instructions associated with the corresponding scenario.
- If the convert_update utility has been executed OR to determine if the convert_update utility has been executed:
*(Scenario 1) ... The convert_update utility was executed while in any 3.0, 3.1 or 3.2 build.
- If you have NEVER executed the convert_update utility on your Pro/INTRALINK implementation and your site ...
*(Scenario 2) ... has no immediate plans of upgrading to 3.3.
*(Scenario 3) ... is upgrading to 3.3 (Scenario referenced in Pro/INTRALINK 3.3 reship customer letter).
*(Scenario 4) ... has already implemented Pro/INTRALINK 3.3 2002470.
If you are uncertain as to which scenario applies or if your implementation does not match one outlined here, please contact Technical Support.
Scenario 1
----------
The convert_update utility was executed while in any 3.0, 3.1 or 3.2 build.
In some circumstances, the convert_update utility described in TANs 115838 and 113846 may have caused the vault path and/or hash name for legacy Pro/PDM objects converted via Pro/CONVERT to change. Please refer to TAN 122864 (http://www.ptc.com/cs/tan/122864.htm) for a resolution.
Scenario 2
----------
The convert_update utility has NEVER been executed on your Pro/INTRALINK implementation and your site has no immediate plans of upgrading to 3.3.
-Discard old copies of convert_update.
-Backup the Dataserver and vaults.
-Obtain a copy of the convert_update2_32 utility and apply if a resolution to TANs 115838 and 113846 is desired.*
*If the convert_update2_32 utility was applied, make sure to checkin at least one object before upgrading to 3.3. (SPR 1047906).
-When upgrading to 3.3, use Datecode 2002471.
-If convert_update2_32 was not applied prior to upgrading, obtain a copy of the convert_update2_33 utility and apply if a resolution to TANs 115838 and 113846 is desired.
-No further action is necessary.
Scenario 3
----------
The convert_update utility has NEVER been executed on your Pro/INTRALINK implementation and your site is upgrading to 3.3 (Scenario referenced in Pro/INTRALINK 3.3 reship customer letter).
-Discard old copies of convert_update.
-Backup the Dataserver and vaults.
-Obtain a copy of Pro/INTRALINK 3.3 2002471 and upgrade using that build.
-Obtain a copy of the convert_update2_33 utility and apply if a resolution to TANs 115838 and 113846 is desired.
-No further action is necessary
Scenario 4
----------
The convert_update utility has NEVER been executed on your Pro/INTRALINK implementation and your site has already implemented Pro/INTRALINK 3.3 2002470.
-Discard old copies of convert_update.
-Backup the Dataserver and vaults.
-Contact Technical Support to obtain a detection script (report_broken_mapname.sql).
-Save the script to a path on the Dataserver.
-Execute the report_broken_mapname.sql script from a command prompt/shell as an Administrator or Oracle user as follows:
sqlplus system/manager @<path_to_script>report_broken_mapname.sql
*If the script returns:"PL/SQL procedure successfully completed." and no "WARNING" messages, legacy objects were not be affected by the upgrade to 3.3.
-Obtain a copy of convert_update2_33 utility and apply if a solution to TANs 115838 and 113846 is desired.
-No further action is necessary.
*If the script returns output similar to the following:
WARNING: mixed source found...
WARNING: file(s) belonging to different PIs...
WARNING: file(s) belonging to different LOs...
-Contact Technical Support to obtain a healing scripts (hl_convert33.sql and hl_convert_gen.sql).
-Obtain a copy of a 2.0 200470 to 3.2 datecode dumpfile created after the Pro/CONVERT process was complete and prior to upgrading to 3.3. If the only backup available is a cold backup (only *.dbf and *.ctl files were backed up), contact Technical Support for assistance with restoring the database to a test machine and creating a dumpfile.
-Place the dumpfile in a path on the Dataserver.
-Execute the following from a command prompt/shell as an Administrator or Oracle user:
sqlplus system/manager
SQL> create user test identified by test;
SQL> grant resource to test;
SQL> grant connect to test;
SQL> exit
imp system/manager file=<path to dumpfile>dumpfile.dmp fromuser=pdm touser=test tables=pdm_productitemverfile, pdm_pivreplfile, pdm_lovfile, pdm_lovreplfile log=import.log
During import, the following Oracle errors may be returned and can be ignored:
IMP-00017: following statement failed with ORACLE error 942
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
ORA-01917: user or role '<role_name>' does not exist
All other errors should be reported to Technical Support.
sqlplus test/test
SQL> grant all on pdm_productitemverfile to pdm;
SQL> grant all on pdm_pivreplfile to pdm;
SQL> grant all on pdm_lovfile to pdm;
SQL> grant all on pdm_lovreplfile to pdm;
SQL> exit
Change directories to the path containing the healing scripts
sqlplus system/manager @hl_convert33.sql test
During execution, the following Oracle error may be returned and can be ignored:
ORA-00942: table or view does not exist" for statement "drop table ..."
All other errors should be reported to Technical Support.
-Obtain a copy of convert_update2_33 utility and apply if a resolution to TANs 115838 and 113846 is desired.
-No further action is necessary.
Note: The convert_update2_32 and convert_update2_33 utilities can be found in the Downloadable Software Updates section of PTC's website under Pro/INTRALINK (http://www.ptc.com/cs/doc/prointralink31.htm). Contact Technical Support for any healing or detection scripts.
Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP