Friday, October 21, 2011

RC-50014: Fatal: Execution of AutoConfig was failed adadmat.pl INSTE8_APPLY

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    RC-50014: Fatal: Execution of AutoConfig was failed      adadmat.pl              INSTE8_APPLY      

While post clone, autoconfig failed with

thread-multi /erpapp/aderp/inst/apps/prtst_erptestpriv-app/admin/install
      adadmat.pl              INSTE8_APPLY       1


AutoConfig is exiting with status 31

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /erpapp/aderp/inst/apps/prtst_erptestpriv-app/admin/log/ApplyAppsTier_07141238.log for details.
ApplyApplTop Completed Successfully.

# Checking the status of AutoConfig run of ApplyApplTop
Warning : AutoConfig has completed with  errors .
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line  after fixing the problem

Solution:
Manually running jtfiappr.sql hit max of extents on CTXSYS.DR$INDEX_ERROR.

Due to <>, development states jtfiaibu.sql is dependent on jtfiappr.sql. If jtfiappr.sql
does not successfully run then jtfiaibu.sql will have errors:
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: APPS.jtf_url_datastore
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 219
ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at line 37
which causes autoconfig to fail.
Solution
1. Manually run jtfiappr.sql 
2. Run jtfiaibu.sql 
3. Run jtffmdel.sql 

The required parameters are as follows: 
1. jtfiappr.sql - Required parameters in order are --- apps 
2. jtfiaibu.sql - Requred parameters parameters in order are --- jtf, jtf, apps 
3. jtffmdel.sql - Does not require any parameters 
NOTE: jtfiappr.sql errored with : max of extents on CTXSYS.DR$INDEX_ERROR. After setting max
extents to unlimited, jtfiappr.sql, jtfiaibu.sql and jtffmdel.sql ran ok. Autoconfig completed
successfully.
References:


AUTOCONFIG FAILED WITH 2 ERRORS: ADADMAT.PL - TXKGENEXTSECCONF.PL [ID 372714.1]
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: