3 Replies Latest reply: Feb 7, 2013 3:06 AM by djoloff RSS

    ERROR when Upgrade R1211 R1213

    djoloff
      Hello

      I need help , i am a new in EBS suite.

      I have the following errors when upgarding R1211 to R1213 : The database is 11.0.1.7

      ATTENTION: All workers either have failed or are waiting:

      FAILED: file ap_sup_party_sites_gt.xdf on worker 1.
      FAILED: file ar_trx_header_gt.xdf on worker 2.
      FAILED: file ar_receipts_gt.xdf on worker 3.
      FAILED: file ar_line_app_detail_gt.xdf on worker 4.


      in log files we can see the following errors

      Executing statement

      ALTER TABLE AP.AP_SUP_PARTY_SITES_GT ADD ( LAST_UPDATED_BY NUMBER NULL )

      Start time for statement above is Tue Feb 05 11:41:29 CET 2013
      End time for statement above is Tue Feb 05 11:41:29 CET 2013
      Error in executing statement ALTER TABLE AP.AP_SUP_PARTY_SITES_GT ADD ( LAST_UPDATED_BY NUMBER NULL )
      Error message is ORA-01430: la colonne ajoutée existe déjà dans la table


      Thanks
        • 1. Re: ERROR when Upgrade R1211 R1213
          Hussein Sawwan-Oracle
          I have the following errors when upgarding R1211 to R1213 : The database is 11.0.1.7
          What is the OS?
          ATTENTION: All workers either have failed or are waiting:

          FAILED: file ap_sup_party_sites_gt.xdf on worker 1.
          FAILED: file ar_trx_header_gt.xdf on worker 2.
          FAILED: file ar_receipts_gt.xdf on worker 3.
          FAILED: file ar_line_app_detail_gt.xdf on worker 4.


          in log files we can see the following errors

          Executing statement

          ALTER TABLE AP.AP_SUP_PARTY_SITES_GT ADD ( LAST_UPDATED_BY NUMBER NULL )

          Start time for statement above is Tue Feb 05 11:41:29 CET 2013
          End time for statement above is Tue Feb 05 11:41:29 CET 2013
          Error in executing statement ALTER TABLE AP.AP_SUP_PARTY_SITES_GT ADD ( LAST_UPDATED_BY NUMBER NULL )
          Error message is ORA-01430: la colonne ajoutée existe déjà dans la table
          Do you get the same error in all worker log files?

          Please see these docs.

          Patch Is Failing Running FndXdfCmp With ORA-01430 [ID 1504251.1]
          Xdf Files Fail with ORA-1430 Errors [ID 472998.1]
          Failures for many XDF files in upgrading 11i Release to 11i10 Using MP 3140000 [ID 297777.1]

          Thanks,
          Hussein
          • 2. Re: ERROR when Upgrade R1211 R1213
            djoloff
            Hello Hussein

            The OS is Enterprise Linux Enterprise Linux Server release 5.4 (Carthage)


            I read the documents and follow the steps in ID 472998.1


            export LANG=en_US.UTF-8
            export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

            And il aunch again the patch, I will let you know

            Thanks for zour answer
            • 3. Re: ERROR when Upgrade R1211 R1213
              djoloff
              Hi hussein

              It seems the patch was ok now, but i have to test more.

              Thanks you for your help