R12.2 Apps DBA. Powered by Blogger.

Adop Phase=prepare Failed While Synchronizing Snapshots (Doc ID 2022760.1)

No comments :
SYMPTOMS
On Orace Applications 12.2.4 version,
when attempting to run adop phase=prepare, the following error occurs:
Executing "adop" action in all nodes
    Remote execution results xml output file = /fs_ne/EBSapps/log/adop/8/prepare_20150619_121220/ABCD_yqz123/remote_execution_result_20150619_122924.xml
   [ERROR]     Node: "qctebsts2app2"  Status: "failed"
   [ERROR]     Node: "qctebsts2app1"  Status: "failed"
   [ERROR]     Remote execution failed on Node: "qctebsts2app1".
   [ERROR]     Remote execution failed on Node: "qctebsts2app2".
   [UNEXPECTED]Remote execution on all the nodes returned failure.
   [UNEXPECTED]So, Unable to continue.
   [UNEXPECTED]Error: While executing "adop" on all other nodes.
   [UNEXPECTED]Execution failed when performing remote action.
The following steps to reproduce the problem:
1.   Set the environment.
2.   Execute the command adop phase=prepare.
3.   The error is shown in the adop log file.
CAUSE
Synchronizing Snapshots failed and that is the root cause for prepare phase failure.
The remote_execution_result_20150619_122924.xml file shows following error.
Synchronizing Snapshots...
  [ERROR] Failed to execute SQL statement :
  begin
  ad_zd_adop.sync_snapshots(342);
 exception
  when others then
  update ad_adop_sessions set status='F'
  where adop_session_id=8;
  commit;
  raise_application_error(-20001,'Error while calling ad_zd_adop.sync_snapshots.' || sqlerrm);
 end;
This was the root cause for prepare phase failure.
SOLUTION
Execute the following steps to resolve the issue.
1.  Execute the following script from SQL command prompt:
begin
   ad_zd_adop.sync_snapshots(342);
 exception when others then
  raise_application_error(-20001,'Error while calling ad_zd_adop.sync_snapshots.' || sqlerrm);
 end;
end;
/
2.  Execute the adop phase=prepare again.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.