adaptch：ATTENTION: All workers either have failed or are waiting:

shunfengfan

说明：p8706840,12.0.6版本，在12.0.6及以下版本有效，系统是12.0.3，patch之前只要停掉所有应用即可，没有其他的准备工作，执行到以下步骤，就不执行了……不知道下一步咋办了
问题：There are now 1038 jobs remaining (current phase=A1):
    11 running, 2 ready to run and 1025 waiting.
Assigned: file fa_xla_upg_headers_gt.xdf on worker  5 for product fa  username APPS.
Completed: file fa_mrc_inq_financials.xdf on worker  4 for product fa  username APPS.
Completed: file fa_inquiry_trx_gt.xdf on worker  6 for product fa  username APPS.
Assigned: file fabks.odf    on worker  4 for product fa  username FA.
   FAILED: file fabks.odf    on worker  4 for product fa  username FA.
Deferred: file fabks.odf    on worker  4 for product fa  username FA.               (Deferment number 2 for this job)
Assigned: file fabks.odf    on worker  4 for product fa  username FA.
   FAILED: file fabks.odf    on worker  4 for product fa  username FA.
Completed: file fa_xla_ext_headers_b_gt.xdf on worker 12 for product fa  username APPS.
Completed: file fa_xla_upg_events_gt.xdf on worker 10 for product fa  username APPS.
Completed: file fa_xla_upg_headers_gt.xdf on worker  5 for product fa  username APPS.
Completed: file fa_balances_report_gt.xdf on worker  3 for product fa  username APPS.
Completed: file fa_book_controls_gt.xdf on worker  7 for product fa  username APPS.
Completed: file fa_asset_failures_gt.xdf on worker 11 for product fa  username APPS.
Completed: file fa_reserve_ledger_gt.xdf on worker  2 for product fa  username APPS.
Completed: file fa_track_members.xdf on worker  9 for product fa  username APPS.
Completed: file fa_xla_ext_lines_b_gt.xdf on worker  1 for product fa  username APPS.
Completed: file fa_xla_ext_lines_stg_gt.xdf on worker  8 for product fa  username APPS.
ATTENTION: All workers either have failed or are waiting:
           FAILED: file fabks.odf    on worker  4.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.


该贴已经同步到 shunfengfan的微博

shunfengfan

查询metalink
Patch failed on ODF Comparison Utility - aduoixrc: ERROR: Failed to find column [ID 845576.1]

如下解决办法：
好用的，粘贴如下

Cause
The issue is caused due to following custom indexes created on FA_BOOKS table

FA_BOOKS_IDX$$_25080062
FA_BOOKS_IDX$$_25080062
FA_BOOKS_IDX$$_25080088
FA_BOOKS_IDX$$_2508008C

Error can be cross verified by running adodfcmp utility manually as:

adodfcmp odffile=fabks.odf userid=fa/<fa_password> changedb=no
priv_schema=system/<password> mode=indexes touser=apps/apps logfile=fabks.log

.


Solution
To implement the solution, please execute the following steps :

1) Confirm the total number of indexes on FA_BOOKS table :

SQL> SELECT INDEX_NAME, COLUMN_NAME, COLUMN_POSITION FROM DBA_IND_COLUMNS
     where TABLE_NAME = 'FA_BOOKS' and TABLE_OWNER ='FA';  
2) Verify and drop these custom indexes.

Note: If not sure about custom indexes then raise SR with corresponding product support for confirmation

3) Restart failed workers.

4) If required recreate custom indexes which were dropped in step2 above.