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