FAILED: file mth_pre_upgrade.sql on worker 1 for product mth username MTH
issue R12.1.3 Upgrade
the patch logfile..
FAILED: file mth_pre_upgrade.sql on worker 1 for product mth username MTH.
Time is: Tue Mar 03 2020 19:27:40
Completed: file pos_drop_types.sql on worker 4 for product pos username POS.
Time is: Tue Mar 03 2020 19:27:50
Completed: file csrrsreg.sql on worker 3 for product csr username CSR.
Time is: Tue Mar 03 2020 19:36:23
ATTENTION: All workers either have failed or are waiting:
FAILED: file mth_pre_upgrade.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Tue Mar 03 2020 19:36:24
worker logfile
Time when worker started job: Tue Mar 03 2020 19:27:40
Start time for file is: Tue Mar 03 2020 19:27:40
sqlplus -s MTH/***** @/app/appdev/DEV/apps/apps_st/appl/mth/12.0.0/patch/115/sql/mth_pre_upgrade.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59
Solution -
SQL> conn mth/mth
Connected.
SQL>
SQL>
SQL>
SQL> rename MTH_RESOURCES_D_TEMP to MTH_RESOURCES_D_TEMP_OLD;
Table renamed.
SQL>
Then, restart the worker using adctrl utility.
