R12.1 Upgrade Patch Error
FAILED: file jai_ren_tab.sql on worker
Patch : 6678700
Errors:
Patch Log:
There are now 131110 jobs remaining (current phase=A2):
7 running, 0 ready to run and 131103 waiting.
ATTENTION: All workers either have failed or are waiting:
FAILED: file jai_ren_tab.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker Log
AD Worker error:
The following ORACLE error:
ORA00955: name is already used by an existing object
occurred while executing the SQL statement:
RENAME JA_IN_RCV_JOURNALS_B to JAI_RCV_JOURNAL_ENTRIES
Error occurred in file
/d01/bkptest/apps/apps_st/appl/ja/12.0.0/patch/115/sql/jai_ren_tab.sql
with arguments '&un_ja'.
Time when worker failed: Mon Oct 01 2012 13:17:08
"adwork001.log" 12520L, 320372C
Solution:
1.Take the backup of jai_rcv_journal_entries
2.Drop the table ja.jai_rcv_journal_entries
3.restart the failed worker
No comments:
Post a Comment