R12.2 Apps DBA. Powered by Blogger.

R12.2 Adop Cutover Failed with ORA-01422: exact fetch returns more than requested number of rows

No comments :
[ERROR] Failed to execute SQL statement :
  declare
  result varchar2(10);
  begin
  ad_zd_adop.cutover;
  exception when others then
  update ad_adop_sessions set status='F'
  where adop_session_id=26;
  commit;
  raise_application_error(-20001,'Error while calling ad_zd_adop.cutover.' || sqlerrm);
  end;

  [ERROR] Error Message :
  [ERROR] ORA-20001: Error while calling ad_zd_adop.cutover.ORA-01422: exact fetch returns more than requested number of rows
  [ERROR] ORA-06512: at "APPS.AD_ZD_LOG", line 78
  [ERROR] ORA-06512: at "APPS.AD_ZD", line 17
  [ERROR] ORA-06512: at "APPS.AD_ZD", line 61
  [ERROR] ORA-01422: exact fetch returns more than requested number of rows
  [ERROR] ORA-06512: at line 9 (DBD ERROR: OCIStmtExecute)
  [UNEXPECTED]Error occurred while performing database cutover
  [UNEXPECTED]Cutover phase completed with errors/warnings. Please check logfiles
Solution:
Please use the following workaround.
1. Bounce the Database completely, ensure that all RAC nodes are down.
2. Update ADOP Repository with the below SQLs :
Take a backup of table.
  1) update ad_adop_sessions set cutover_status='3' where adop_session_id=<session id> and node_name=<host name>;
  2) update ad_adop_sessions set abort_status='X' where adop_session_id=<session id>;
3. After commit, restart Cutover using the same command.

No comments :

Post a Comment

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