Thursday, November 7, 2013

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

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


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:

No comments:

Post a Comment