3 Replies Latest reply on Jan 25, 2017 9:10 PM by mdtaylor

    R12Upgrade(u6678700.drv)  : Worker FAILED: file invtempl.sql

    655572

      Hello All,

       

      We are upgrading from 11i to R12.1 on RHEL 7 86_64 bit environment, while running R1211 upgrade driver(u6678700.drv)  we are facing this issue.

      Please let us know if any one encountered this issue in upgrades or any suggestions.

       

      Adpatch Error:

       

         FAILED: file invtempl.sql on worker 10 for product inv username INV.

      ATTENTION: All workers either have failed or are waiting

                 FAILED: file invtempl.sql on worker 10.

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

       

      Worker log error:

      DECLARE

      *

      ERROR at line 1:

      ORA-00001: unique constraint (INV.MTL_ITEM_TEMPLATES_U1) violated

      ORA-06512: at line 57

       

      Appreciate your time and efforts.

       

      Thanks

      DBA

        • 1. Re: R12Upgrade(u6678700.drv)  : Worker FAILED: file invtempl.sql
          Gbenga Ajakaye

          See this bug. Bug 16250113 : R12 UPGRADE ORA-00001: UNIQUE CONSTRAINT (INV.MTL_ITEM_TEMPLATES_U1) VIOLATED

          1 person found this helpful
          • 2. Re: R12Upgrade(u6678700.drv)  : Worker FAILED: file invtempl.sql
            655572

            Hi Gbenga,

             

            Thanks for quick response and sharing bug number.

            I have gone through the Bug data and don't see any work around mentioned in this bug.

             

            Thanks

            • 3. Re: R12Upgrade(u6678700.drv)  : Worker FAILED: file invtempl.sql
              mdtaylor

              I had the same issue.

               

              ATTENTION: All workers either have failed or are waiting:

               

                         FAILED: file invtempl.sql on worker 21.

               

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

               

              Commit complete.

               

              DECLARE

              *

              ERROR at line 1:

              ORA-00001: unique constraint (INV.MTL_ITEM_TEMPLATES_U1) violated

              ORA-06512: at line 57

               

              Skipped

               

              delete  from MTL_ITEM_TEMPLATES where template_id = 1294;

               

              delete  from MTL_ITEM_TEMPLATES_B where template_id = 1294;

               

              delete  from MTL_ITEM_TEMPLATES_TL where template_id = 1294;

               

              delete  from MTL_ITEM_TEMPLATES_B where template_id = 1302;

               

              delete  from MTL_ITEM_TEMPLATES_TL where template_id = 1302;

               

              select * from MTL_ITEM_TEMPLATES_B order by 2;

               

              Look to see if you have any of these item templates or with @ symbols in front of them and delete them.

               

              from invtempl.sql:

               

                FOR templ_id IN 1 .. 16 LOOP

               

                   IF    templ_id = 1 THEN  Templ_Name := 'Finished Good';

                   ELSIF templ_id = 2 THEN  Templ_Name := 'Purchased Item';

                   ELSIF templ_id = 3 THEN  Templ_Name := 'Supply Item';

                   ELSIF templ_id = 4 THEN  Templ_Name := 'Outside Processing Item';

                   ELSIF templ_id = 5 THEN  Templ_Name := 'Subassembly';

                   ELSIF templ_id = 6 THEN  Templ_Name := 'ATO Model';

                   ELSIF templ_id = 7 THEN  Templ_Name := 'PTO Model';

                   ELSIF templ_id = 8 THEN  Templ_Name := 'ATO Option Class';

                   ELSIF templ_id = 9 THEN  Templ_Name := 'PTO Option Class';

                   ELSIF templ_id = 10 THEN  Templ_Name := 'Planning Item';

                   ELSIF templ_id = 11 THEN  Templ_Name := 'Kit';

                   ELSIF templ_id = 12 THEN  Templ_Name := 'Phantom Item';

                   ELSIF templ_id = 13 THEN  Templ_Name := 'Reference Item';

                   ELSIF templ_id = 14 THEN  Templ_Name := 'ATO Item';

                   ELSIF templ_id = 15 THEN  Templ_Name := 'Freight';

                   ELSIF templ_id = 16 THEN  Templ_Name := 'Product Family';

                   ELSE

                      EXIT;

                   END IF;

              1 person found this helpful