Thursday, May 14, 2015

adop phase=cleanup is Failing with below error

adop phase=cleanup is Failing with below error


Calling cleanup in STANDARD mode...
    Log: @ADZDSHOWLOG.sql "2015/05/14 19:21:47"
    [ERROR]     Failed to execute SQL statement :
       begin
        execute immediate 'alter session set DDL_LOCK_TIMEOUT = 600';
        ad_zd.cleanup('STANDARD');
      end;

    [ERROR]     Error Message :
    [UNEXPECTED]Error occurred while calling cleanup plsql API
    [UNEXPECTED]Cleanup phase completed with errors/warnings. Please check logfiles


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.

adop exiting with status = 1 (Fail)

SQL> select count(*) from dba_obJects where status='INVALID' AND object_name like 'AD%';


  COUNT(*)
----------
         1

SQL> SQL> select object_name from dba_obJects where status='INVALID' AND object_name like 'AD%';

OBJECT_NAME
--------------------------------------------------------------------------------
AD_ZD_TABLE

SQL> alter package apps.AD_ZD_TABLE compile;

Warning: Package altered with compilation errors.

SQL> alter package apps.AD_ZD_TABLE compile body;

Warning: Package Body altered with compilation errors.

Fix#
SQL> @/ad_TXK_patches_delta_6/19197270/admin/adgrants.sql APPS
Connected.

then compile the object.
SQL> alter package apps.AD_ZD_TABLE compile;

Package altered.

SQL> alter package apps.AD_ZD_TABLE compile body;

Package body altered.

No comments:

Post a Comment