Adop Phase=prepare Failed While Synchronizing Snapshots

Orace Applications 12.2.4 version,
when attempting to run adop phase=prepare, the following error occurs:

Steps to reproduce the problem:

  1. Set the environment variables.
  2. Execute the command adop phase=prepare.
  3. The error is shown in the adop log file.

Synchronizing Snapshots failed and that is 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;
/

  1. Execute the adop phase=prepare again.

Leave a Comment

Your email address will not be published.