Article - CS377266
Oracle to SQL migration utility installation failing with an error " Package O2S_DIAG_UTIL is invalid " in Windchill PDMLink
Modified: 26-Sep-2022
Applies To
- Windchill PDMLink 11.0 to 11.2
Description
- Oracle to SQL migration utility failing with error Package "O2S_DIAG_UTIL is invalid" in Windchill PDMLink
DEBUG java.lang.RuntimeException: java.lang.RuntimeException: Package O2S_DIAG_UTIL is invalid.
DEBUG at com.ptc.o2s.install.utils.PreMigrationCheck.install(PreMigrationCheck.java:1453)
DEBUG - at com.ptc.o2s.install.actions.InstallPreMigUtilAction.process(InstallPreMigUtilAction.java:56)
DEBUG - at com.ptc.windchill.install.framework.InstallAction.run(InstallAction.java:468)
DEBUG - at com.ptc.windchill.install.framework.InstallAction.install(InstallAction.java:313)
DEBUG - at com.zerog.ia.installer.actions.CustomAction.installSelf(Unknown Source)
DEBUG - at com.zerog.ia.installer.InstallablePiece.install(Unknown Source)
DEBUG - Caused by: java.lang.RuntimeException: Package O2S_DIAG_UTIL is invalid.
DEBUG - at com.ptc.o2s.install.utils.PreMigrationCheck.createPreCheckOraObject(PreMigrationCheck.java:170)
DEBUG - at com.ptc.o2s.install.utils.PreMigrationCheck.install(PreMigrationCheck.java:1445)
DEBUG - ... 11 more
DEBUG - Install Pre-Migration Diagnostic Utility failed: "Error: installing Pre-Migration Diagnostic Utility has errors."
DEBUG Install Pre-Migration Diagnostic Utility failed: "Error: installing Pre-Migration Diagnostic Utility has errors."
DEBUG - Exiting with return code 1
- Getting below error while running the compile package body script.
216/5 PL/SQL: Statement ignored
216/55 PLS-00364: loop index variable 'R1' use is invalid
218/5 PL/SQL: Statement ignored
218/43 PLS-00364: loop index variable 'R1' use is invalid
220/5 PL/SQL: Statement ignored
220/47 PLS-00364: loop index variable 'R1' use is invalid
232/5 PL/SQL: SQL Statement ignored
233/7 PL/SQL: ORA-00904: "DBMS_XMLGEN"."CONVERT": invalid identifier
250/5 PL/SQL: Statement ignored
250/55 PLS-00364: loop index variable 'R1' use is invalid
Errors: check compiler log
This is a printer-friendly version of Article 377266 and may be out of date. For the latest version click CS377266