Saturday, November 3, 2018

GET_ACTIVE_CP_REQ_ID(c_req_id) error while running adop=prepare

While running adop=prepare phase
 recieved error

LOG FILE 
----------------------- 
Filename =adop_20180822_140410.log 
See the following error: 

[EVENT] Submitting ADZDPATCH concurrent program. 
[PROCEDURE] [START 2018/08/22 14:07:21] Running adzdpatch concurrent program 
[STATEMENT] Getting active concurrent program request ID 
[ERROR] Failed to execute SQL statement: 
declare 
c_req_id number; 
begin 
ad_zd_adop.GET_ACTIVE_CP_REQ_ID(c_req_id); 
dbms_output.put_line(c_req_id); 
end; 

[ERROR] Error Message: 
[ERROR] ORA-06550: line 4, column 16: 
[ERROR] PLS-00302: component 'GET_ACTIVE_CP_REQ_ID' must be declared 
[ERROR] ORA-06550: line 4, column 5: 
[ERROR] PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicator at char 54 in ' declare 
[ERROR] c_req_id number; 
[ERROR] begin 
[ERROR] ad_zd_adop.<*>GET_ACTIVE_CP_REQ_ID(c_req_id); 
[ERROR] dbms_output.put_line(c_req_id); 
[ERROR] end; 
[ERROR] ') 
[UNEXPECTED]Error calling runConcurrentProgram subroutine. 
[EVENT] Stopping services on patch file system. 
[EVENT] Stopping admin server. 
[PROCEDURE] [START 2018/08/22 14:07:21] Check and stop patch Admin Server 
[EVENT] Stopping node manager. 
[PROCEDURE] [START 2018/08/22 14:07:21] Check and stop patch Node Manager 
[ERROR] Prepare phase has failed. 

Verification steps

select f.release_name RELEASE, i.version VERSION 
from v$instance i,fnd_product_groups f 
where upper(substr(i.instance_name,1,4)) = 
upper(substr(f.applications_system_name,1,4));


RELEASE VERSION 
-------------------------------------------------- ----------------- 
12.2.4 12.1.0.2.0 


select text from dba_source where name='AD_ZD_ADOP' and line<3; 

TEXT 
-------------------------------------------------------------------------------- 
PACKAGE AD_ZD_ADOP AUTHID CURRENT_USER AS 
/* $Header: ADZDADOPS.pls 120.18.12020000.36 2015/06/19 13:27:23 rraam ship $ */ 


PACKAGE BODY AD_ZD_ADOP AS 
/* $Header: ADZDADOPB.pls 120.25.12020000.104 2015/08/04 10:46:21 vgannara ship 
$ */ 

strings -a $AD_TOP/patch/115/sql/ADZDADOPS.pls | grep Header 
strings -a $AD_TOP/patch/115/sql/ADZDADOPB.pls | grep Header 


Issue found
---------------

The function GET_ACTIVE_CP_REQ_ID is not defined. 
Issue with the packages  of source file version of 
ADZDADOPS.pls and ADZDADOPB.pls with the function.


Solution

Load these Packages on DB to fix the issue.

@$AD_TOP/patch/115/sql/ADZDADOPS.pls; 

@$AD_TOP/patch/115/sql/ADZDADOPB.pls; 


After executing - adop=prepare stage went fine.


No comments: