3 Replies Latest reply: Oct 16, 2013 9:21 AM by Asif Muhammad Branched from an earlier discussion. RSS

    Re: Upgrading  ebs 11i to r12 12.1.1 on Suse

    user10994730

      We do not use OPM and gmfpostimportaad.sql is running for last 20 hrs.

       

      I tried to stop this process as per the note Long Running Cstpostimportaad.sql while upgrade to R12.1.1 (Doc ID 1453612.1)/ Even that was taking long to stop. I had cancell it and tried to stop it again it is taking too long again.

      Any help please.

       

      Enter the worker number(s)/range(s) or 'all' for all workers,

      or press [Return] to go back to the menu : 4

       

      ^C

      AD Controller error:

      The following ORACLE error:

       

      ORA-01013: user requested cancel of current operation

       

      occurred while executing the SQL statement:

       

      UPDATE fnd_install_processes

      SET status = 'F'

      WHERE worker_id = 4

      Review the messages above, then press [Return] to continue.

       

      orker Code Context Filename Status

      ------ -------- ----------------- -------------------------- --------------

      1 Run AutoPatch R120 pl Wait

      2 Run AutoPatch R120 pl Wait

      3 Run AutoPatch R120 pl Wait

      4 Run AutoPatch R120 pl gmfpostimportaad.sql Running

       

       

      Review the messages above, then press [Return] to continue.

       

      AD Controller Menu

      ---------------------------------------------------

       

      1. Show worker status

       

      2. Tell worker to restart a failed job

       

      3. Tell worker to quit

       

      4. Tell manager that a worker failed its job

       

      5. Tell manager that a worker acknowledges quit

       

      6. Restart a worker on the current machine

       

      7. Exit

       

      Enter your choice [1] : 4

       

      Enter the worker number(s)/range(s) or 'all' for all workers,

      or press [Return] to go back to the menu : 4