2 Replies Latest reply on Aug 8, 2015 7:14 AM by Pravin Takpire

    Patch hangs and completed.Invalid count increased

    1466728

      HI ALL,

       

      Patch  20604436  hungs and completed .Invalid count increased from 110 to 193 after this patch. Reapplying same patch also dosn't help.

       

      FYI --> Same patch applied in different test insance not having any issues will appying and no invalids.

       

       

      Please check the below patch hung for the worker 1.log

       

      package
      /apps_st/appl/ego/12.0.0/patch/115/sql/EGOVITMS.pls

       

      Line 34: Changed as
      follows:
      -------------------------------------------------------------
      CREATE
      OR REPLACE PACKAGE EGO_Item_PVT
      AS
      -------------------------------------------------------------
      CREATE OR
      REPLACE PACKAGE EGO_Item_PVT AUTHID CURRENT_USER
      AS
      -------------------------------------------------------------

       

      Done deactivating PL/SQL compilation.

       

      AD Worker error:
      ORA-04021: timeout occurred while waiting to lock
      object

       

      Failed to execute statement. Statement is

       

      CREATE OR REPLACE PACKAGE EGO_Item_PVT AUTHID CURRENT_USER AS
      /* $Head
      ...

       

      AD Worker error:
      ORA-04021: timeout occurred while waiting to lock
      object

       

      Done deactivating PL/SQL compilation.

       

      AD Worker error:
      ORA-04021: timeout occurred while waiting to lock
      object


      Failed to execute statement. Statement is

       

      CREATE OR REPLACE PACKAGE EGO_Item_PVT AUTHID CURRENT_USER AS
      /* $Head
      ...

      AD Worker error:
      ORA-04021: timeout occurred while waiting to lock
      object


      Done resetting PL/SQL compilation.

       

      Unable to process file in PACKAGE mode.

       

      Converting file for Invoker's Rights.
        Source file:
      /apps_st/appl/ego/12.0.0/patch/115/sql/EGOVITMS.pls
       
      Dest   file:
      /apps_st/appl/admin/can/out/p001invok.sql

       

      Line 34: Changed as
      follows:
      -------------------------------------------------------------
      CREATE
      OR REPLACE PACKAGE EGO_Item_PVT
      AS
      -------------------------------------------------------------
      CREATE OR
      REPLACE PACKAGE EGO_Item_PVT AUTHID CURRENT_USER
      AS
      -------------------------------------------------------------

       


      sqlplus -s APPS/*****
      @.....apps_st/appl/admin/can/out/p001invok.sql
      Connected.

       

      Package created.


      Commit complete.

       

       

      Regards

      Madhan