Friday 7 October 2022

FAILED: file adinvset.pls on worker 1

 adadmin Shows:

ATTENTION: All workers either have failed or are waiting:


   FAILED: file adinvset.pls on worker  1.


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



    Fixed: file adinvset.pls on worker  1 for product ad  username APPLSYS.

   FAILED: file adinvset.pls on worker  1 for product ad  username APPLSYS.


There are now 65 jobs remaining (current phase=iv_setup):

    0 running, 0 ready to run and 65 waiting.




adctrl says:

Worker  Code      Context            Filename                    Status
------  --------  -----------------  --------------------------  --------------
     1  Run       Invoker R120       adinvset.pls                FAILED        


Solution:

SELECT owner, object_name 
FROM all_objects
WHERE  object_name= 'APPS_ARRAY_DDL'
AND object_type = 'PACKAGE'
AND status = 'INVALID';

alter package asg.apps_array_ddl compile;


Restasrt Failed Worker

No comments:

Post a Comment