2 Replies Latest reply on Oct 21, 2015 8:26 AM by Moyses

    Strange worker failed reasons when applying patch 17529626

    Moyses

      Dear All,

      I'm trying to apply the patch 17529626 on EBS R12.1 Linux X86-64 platform. So i'm facing the following issues :

      1 :

      An error occurred while relinking application programs.

      Continue as if it were successful [No] : Yes

       

      I've respond by "Yes" here to continue the patch as recommended in some other Oracle discussions.

       

      2: After passing the above step the adpatch is blocking in the following lines :

                 FAILED: file ap_holds_all.xdf on worker  1.

                 FAILED: file zx_import_tax_lines_gt.xdf on worker  2.

      ATTENTION: Please fix the above failed worker(s) so the manager can continue.


      I've checked the worker's logs, and i got the following :

      worker1 :

      INFO: An additional column ATTRIBUTE7 exists in the target database

      INFO: An additional column ATTRIBUTE8 exists in the target database

      INFO: An additional column ATTRIBUTE9 exists in the target database

      INFO: An additional column LAST_UPDATED_BY exists in the target database

      The table AP_HOLDS_ALL is missing the column LAST_UPDATED_BY

      Warning: The missing column is NOT NULL and there is no default value to apply

      Adding a nullable column with the statement

      Executing statement

        ALTER TABLE AP.AP_HOLDS_ALL ADD ( LAST_UPDATED_BY NUMBER(15) NULL  )

      Start time for statement above is Tue Oct 20 23:42:21 CET 2015

      End time for statement above is Tue Oct 20 23:42:21 CET 2015

      Error in executing statement ALTER TABLE AP.AP_HOLDS_ALL ADD ( LAST_UPDATED_BY NUMBER(15) NULL  )

      Error message is ORA-01430: column being added already exists in table

      Error code is    1430

      ==========================================================

      Done calling the utility function. Return Code = [1] TimeStamp = [Tue Oct 20 23:42:21 CET 2015]

      Updating task with status 1

      AD Worker error:

      The utility FndXdfCmp returned error for the above task.

      AD Worker error:

      The above program failed.  See the error messages listed

      above, if any, or see the log and output files for the program.

      Time when worker failed: Tue Oct 20 2015 23:42:21

       

      Worker 2 :

       

      INFO: An additional column ATTRIBUTE7 exists in the target database

      INFO: An additional column ATTRIBUTE8 exists in the target database

      INFO: An additional column ATTRIBUTE9 exists in the target database

      The table ZX_IMPORT_TAX_LINES_GT is missing the column ATTRIBUTE1

      Executing statement

        ALTER TABLE ZX.ZX_IMPORT_TAX_LINES_GT ADD ( ATTRIBUTE1 VARCHAR2(150) NULL  )

      Start time for statement above is Tue Oct 20 23:41:59 CET 2015

      End time for statement above is Tue Oct 20 23:41:59 CET 2015

      Error in executing statement ALTER TABLE ZX.ZX_IMPORT_TAX_LINES_GT ADD ( ATTRIBUTE1 VARCHAR2(150) NULL  )

      Error message is ORA-01430: column being added already exists in table

      Error code is    1430

      ==========================================================

      Done calling the utility function. Return Code = [1] TimeStamp = [Tue Oct 20 23:41:59 CET 2015]

      Updating task with status 1

      AD Worker error:

      The utility FndXdfCmp returned error for the above task.

      AD Worker error:

      The above program failed.  See the error messages listed

      above, if any, or see the log and output files for the program.

      Time when worker failed: Tue Oct 20 2015 23:41:59

       

      So I've checked both tables for these columns:

      desc AP.AP_HOLDS_ALL : LAST_UPDATED_BY     NOT NULL NUMBER(15)  exists

      desc ZX.ZX_IMPORT_TAX_LINES_GT : ATTRIBUTE1                         VARCHAR2(150) exists

       

      Now i'm confused and i don't know how to resolve this issue, please Help ?!!

       

      Also, I've tried to restart worker through adctrl, they've been restarted but still runing for long long time !!!!

       

      Thank you for your help !

       

      Regards

      Moussa