Tuesday, February 4, 2014

R12.1 Upgrade Patch Error


Time is: Wed Oct 03 2012 19:39:21
   FAILED: file jai_cond_ren_col.sql on worker 10 for product ja  username JA.
Time is: Wed Oct 03 2012 19:39:21
Start time for file is: Wed Oct 03 2012 19:39:21
sqlplus -s APPS/***** @/d01/bkptest/apps/apps_st/appl/ja/12.0.0/patch/115/sql/jai_cond_ren_col.sql
&un_ja &un_fnd

DECLARE
*
ERROR at line 1:
ORA-00903: invalid table name
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 107

Solution:

To fix the failure, please execute following steps :
1.) Open a new Shell, source the APPS Environment and execute following script located under

$APPL_TOP>/ja/12.0.0/patch/115/sql :

sqlplus apps/apps @$JA_TOP/patch/115/sql/jai_cond_ren_col.sql ja fnd

2.) Once the script runs successfully, use the hidden option 8 of the Utility 'adctrl' to skip the failed worker.

3.) The Patch should continue assigning jobs to the workers, which can be verified by checking the logfile or
by checking the workers Status via the the 'adctrl' Utility.

No comments:

Post a Comment