Problem:
Adcfgclone got complete but at the end it failed for autoconfig with the below error.
Error :
WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory:/u01/apps/esbtest/fs2/inst/apps/APDTST_apdbasrv02/admin/install
adadmprf.sh INSTE8_PRF
Solution:
1. Take backup of ad_timestamps, ad_appl_tops
2. Remove the rows which correspond to current node (on which the script is failing)
SQL> create table ad_timestamps_bkp as select * from ad_timestamps;
Table created.
SQL> create table ad_appl_tops_bkp as select * from ad_appl_tops;
Table created.
SQL> select distinct substr(attribute, 1, instr(attribute, ‘*’) – 1)
from ad_timestamps
where type in (‘INSTANTIATED_CURRENT_VIEW_SNAPSHOT’, ‘BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT’);
SQL> delete ad_timestamps where type in (‘INSTANTIATED_CURRENT_VIEW_SNAPSHOT’,
‘BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT’);
SQL> delete ad_appl_tops where APPLICATIONS_SYSTEM_NAME=’APDROD’;
3.Run the autoconfig , it will complete successfully.
