This discussion is archived
1 Reply Latest reply: Aug 8, 2012 1:01 AM by RRSOra? RSS

Ora-24155 error DBMS_SCHEDULER DBA_SCHEDULER_CHAIN_RULES

RRSOra? Newbie
Currently Being Moderated
Hi,

This is in continuance with my question posted at the end of threadID = 691223. DBMS Scheduler error Today also I received the following error in my scheduler:

ERROR=ORA-24155: rule CPM_GS.CH_RU_3_01082012080123 not in rule set CPM_GS.SCHED_RULESET$16020ORA-06512: at "SYS.DBMS_ISCHED", line 3867
ORA-06512: at "SYS.DBMS_ISCHED", line 1340
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1257
ORA-06512: at "CPM_GS.PKG_LOAD_PROD_CREDITS_MAIN", line 148
As indicated in my message in threadID 691223, there seems to be no relation between CH_RU_3_01082012080123 AND SCHED_RULESET$16020 in DBA_SCHEDULER_CHAIN_RULES, DBA_SCHEDULER_CHAINS, DBA_RULE_SET_RULES, DBA_RULES and DBA_RULE_SETS.

The details are as follows:
select * from dba_scheduler_chain_rules where rule_name = 'CH_RU_3_01082012080123';
owner      chain_name                             rule_owner   rule_name                          condition

CPM_GS    GEN_UP_EV_01082012080120  CPM_GS       CH_RU_3_01082012080123  CH_ST_2_01082012080120 SUCCEEDED
action                                             comments
START "CH_ST_3_01082012080122"  Starting chain_step_3

select * from dba_scheduler_chains where chain_name = 'GEN_UP_EV_01082012080120';
owner chain_name rule_set_owner rule_set_name number_of_rules number_of_steps enabled user_rule_set comments
CPM_GS GEN_UP_EV_01082012080120 CPM_GS SCHED_RULESET$15327 4 3 TRUE FALSE A chain for connecting Upd_event_attr and Gen_event

SELECT * FROM DBA_RULE_SET_RULES WHERE rule_name = 'CH_RU_3_01082012080123';
rule_set_owner rule_set_name rule_owner rule_name rule_set_rule_enabled rule_set_rule_comment
CPM_GS SCHED_RULESET$15327 CPM_GS CH_RU_3_01082012080123 ENABLED Starting chain_step_3

SELECT * FROM DBA_RULE_SET_RULES WHERE RULE_SET_NAME = 'SCHED_RULESET$16020';
rule_set_owner rule_set_name rule_owner rule_name rule_set_rule_enabled rule_set_rule_comment
CPM_GS SCHED_RULESET$16020 CPM_GS CH_RU_1_01082012080123 ENABLED Starting chain_step_1
CPM_GS SCHED_RULESET$16020 CPM_GS CH_RU_2_01082012080123 ENABLED Starting chain_step_2

The error seems to indicate a race condition where ruleset of one rule is somehow related to another? Can someone throw some light as to why this is happening?

Edited by: 920445 on Dec 18, 2012 11:32 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points