ERROR:
======
[ERROR] Error occurred while executing <adpatch workers=8 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/mwdb-pl/ebsap/fs1/EBSapps/appl/admin/erpdev/adalldefaults.txt patchtop=/mwdb-pl/ebsap/fs_ne/EBSapps/patch/13543062 driver=u13543062.drv logfile=u13543062.log>
[ERROR] Please check the adpatch log files.
[STATEMENT] Autopatch completed with errors/warnings. Please check logfiles
[STATEMENT] SQL Statement: update ad_adop_sessions
set status='F'
where adop_session_id = 2 and appltop_id = 2233 and node_name='bbhoeccdbdev'
[STATEMENT] SQL Statement: update ad_adop_sessions
set apply_end_date=to_date('07-07-2020 12:25:38','DD-MM-YYYY HH24:MI:SS')
where adop_session_id=2
[STATEMENT] APPLY Phase END TIME: 07-07-2020 12:25:38
[STATEMENT] [START 2020/07/07 12:25:42] Unlocking sessions table
[STATEMENT] SQL stmt: < begin
AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('bbhoeccdbdev',60,2);
end;
[STATEMENT] Online patching tool cannot proceed when a previous patching session is incomplete
[STATEMENT] Please ensure no pending patching sessions exist before trying a new patch
[ERROR] Unrecoverable error occured. Exiting the current session.
[STATEMENT] [START 2020/07/07 13:46:35] Unlocking sessions table
[STATEMENT] [END 2020/07/07 13:46:36] Unlocking sessions table
[STATEMENT] Log file: /adop_20200707_134510.log
[STATEMENT] [START 2020/07/07 13:46:41] Unlocking sessions table
[STATEMENT] [END 2020/07/07 13:46:43] Unlocking sessions table
CAUSE:
======
Node Name Node Type Phase Status Started Finished Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
bbhoeccdbdev master APPLY FAILED 07-JUL-20 12:24:49 +03:00 07-JUL-20 12:25:38 +03:00 0:00:49
PREPARE NOT APPLICABLE
CUTOVER NOT APPLICABLE
Session was in incomplete in ad_adop_sessions tables.
SOLUTIONS:
==========
>> Check the adop cycle status.
SQL>select adop_session_id,status from ad_adop_sessions where status='F';
Output:
adop_session_id status
2 F
>> Update the status to completed.
SQL>update ad_adop_sessions set status='C' where status='F';
SQL>commit;
$adop -status
Node Name Node Type Phase Status Started Finished Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
bbhoeccdbdev master APPLY ACTIVE 07-JUL-20 12:24:49 +03:00 07-JUL-20 12:25:38 +03:00 0:00:49
Now you can start the adop patch.
======
[ERROR] Error occurred while executing <adpatch workers=8 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/mwdb-pl/ebsap/fs1/EBSapps/appl/admin/erpdev/adalldefaults.txt patchtop=/mwdb-pl/ebsap/fs_ne/EBSapps/patch/13543062 driver=u13543062.drv logfile=u13543062.log>
[ERROR] Please check the adpatch log files.
[STATEMENT] Autopatch completed with errors/warnings. Please check logfiles
[STATEMENT] SQL Statement: update ad_adop_sessions
set status='F'
where adop_session_id = 2 and appltop_id = 2233 and node_name='bbhoeccdbdev'
[STATEMENT] SQL Statement: update ad_adop_sessions
set apply_end_date=to_date('07-07-2020 12:25:38','DD-MM-YYYY HH24:MI:SS')
where adop_session_id=2
[STATEMENT] APPLY Phase END TIME: 07-07-2020 12:25:38
[STATEMENT] [START 2020/07/07 12:25:42] Unlocking sessions table
[STATEMENT] SQL stmt: < begin
AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('bbhoeccdbdev',60,2);
end;
[STATEMENT] Online patching tool cannot proceed when a previous patching session is incomplete
[STATEMENT] Please ensure no pending patching sessions exist before trying a new patch
[ERROR] Unrecoverable error occured. Exiting the current session.
[STATEMENT] [START 2020/07/07 13:46:35] Unlocking sessions table
[STATEMENT] [END 2020/07/07 13:46:36] Unlocking sessions table
[STATEMENT] Log file: /adop_20200707_134510.log
[STATEMENT] [START 2020/07/07 13:46:41] Unlocking sessions table
[STATEMENT] [END 2020/07/07 13:46:43] Unlocking sessions table
CAUSE:
======
Node Name Node Type Phase Status Started Finished Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
bbhoeccdbdev master APPLY FAILED 07-JUL-20 12:24:49 +03:00 07-JUL-20 12:25:38 +03:00 0:00:49
PREPARE NOT APPLICABLE
CUTOVER NOT APPLICABLE
Session was in incomplete in ad_adop_sessions tables.
SOLUTIONS:
==========
>> Check the adop cycle status.
SQL>select adop_session_id,status from ad_adop_sessions where status='F';
Output:
adop_session_id status
2 F
>> Update the status to completed.
SQL>update ad_adop_sessions set status='C' where status='F';
SQL>commit;
$adop -status
Node Name Node Type Phase Status Started Finished Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
bbhoeccdbdev master APPLY ACTIVE 07-JUL-20 12:24:49 +03:00 07-JUL-20 12:25:38 +03:00 0:00:49
Now you can start the adop patch.
No comments:
Post a Comment