R12.2 Apps DBA. Powered by Blogger.

R12.2 ORA-04063: rule set APPLSYS.WF_DEFERRED_R has errors

No comments :
adcvmlog.xml renamed to /oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/log/08051619/adcvmlog.xml.08051627
WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>
  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/bin/perl -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /oaph/oracle/oaphappl/fs1/EBSapps/appl/au/12.0.0/perl -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/scripts/adexecsql.pl sqlfile=/oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/install
      txkappsprf.sql          INSTE8_PRF         1
AutoConfig is exiting with status 1
AutoConfig execution completed on Tue Aug  5 16:27:42 2014
Time taken for AutoConfig execution to complete : 7 mins  56 secs

ORA-04063: Rule Set "Applsys.Wf_deferred_r" Has Errors
Sol 1:
1. Add the missing subscriber back:
sqlplus applsys/<pwd>
declare
lagent sys.aq$_agent;
subscriber_exist exception;
pragma EXCEPTION_INIT(subscriber_exist, -24034);
begin
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.add_subscriber(queue_name =>'APPLSYS.WF_DEFERRED',subscriber=>
lagent,rule=>'1=1');
exception
when subscriber_exist then
-- just add the rule if subscriber exists
dbms_aqadm.alter_subscriber(queue_name =>'APPLSYS.WF_DEFERRED',subscriber=>
lagent,rule=>'1=1');
end;
/
2. Run the concurrent program "GLOOAP module: Open Period" to confirm periods are defined in the proper calendar.
(This step is required only when the request failed with the ORA-04063 error as reported.)
Sol 2:
SELECT DISTINCT substr(object_name, 1, length(object_name)-2) q_name
FROM dba_objects
WHERE object_type = 'RULE SET'
AND object_name like 'WF%'
AND owner in ('APPLSYS', 'APPS')
AND status = 'INVALID';
still returns
WF_JAVA_ERROR
WF_JAVA_DEFERRED
WF_WS_JMS_OUT
WF_WS_SAMPLE
WF_WS_JMS_IN
WF_JMS_OUT
WF_JMS_JMS_OUT
WF_JMS_IN
Type: ODM Question
How to recreate 'APPLSYS.WF_JAVA_DEFERRED_R' subscriber?
Type: ODM Answer
1. Ensure that you have taken a backup of your system before applying the recommended solution.
2. Run the following scripts in a TEST environment first:
Login as apps user and execute the below two scripts
declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_JAVA_DEFERRED';
lagent := sys.aq$_agent('WF_JAVA_DEFERRED',null,0);
dbms_aqadm.remove_subscriber(queue_name=>l_new_queue, subscriber=>lagent);
end;
/
commit;

declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_JAVA_DEFERRED';
lagent := sys.aq$_agent('WF_JAVA_DEFERRED',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;
3. Once the scripts complete, confirm that the OBJECT is VALID.
You can use the following SQL to confirm:
select object_name, object_type, status from dba_objects where object_name='WF_JAVA_DEFERRED_R' ;

No comments :

Post a Comment

Note: only a member of this blog may post a comment.