This discussion is archived
7 Replies Latest reply: Aug 1, 2012 3:45 AM by RRSOra? RSS

DBMS Scheduler error

523648 Newbie
Currently Being Moderated
Hi,

When i try to run the scheduler create program, getting the following error, please advice.

Error at line 1
ORA-24155: rule MODEL.REBPRO_VALIDATE_DATA_RULE not in rule set MODEL.SCHED_RULESET$2
ORA-06512: at "SYS.DBMS_ISCHED", line 3719
ORA-06512: at "SYS.DBMS_ISCHED", line 1198
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1257
ORA-06512: at line 234
  • 1. Re: DBMS Scheduler error
    Aman.... Oracle ACE
    Currently Being Moderated
    Amul,
    Your error code give this in description,
    Oracle Error : ORA-24155: rule string.string not in rule set string.string

    Cause: the rule to be removed from the rule set is not in the rule set

    Action: do not remove a rule from a rule set that does not contain the rule

    So what you are doing in the program creation?
    Aman....
  • 2. Re: DBMS Scheduler error
    Aman.... Oracle ACE
    Currently Being Moderated
    Removed as by mistake added the same reply twice.
    Aman....

    Message was edited by:
    Aman....
  • 3. Re: DBMS Scheduler error
    523648 Newbie
    Currently Being Moderated
    BEGIN
    DBMS_SCHEDULER.DEFINE_CHAIN_RULE (
    chain_name => 'REBPRO_REBATES_PROJECT_CHN',
    condition => 'TRUE',
    action => 'START REBPRO_VALIDATE_STEP',
    rule_name => 'REBPRO_VALIDATE_DATA_RULE',
    comments => 'FIRST STEP IN REBATE PROJECTION');
    end;

    This is what i am trying

    Message was edited by:
    amul
  • 4. Re: DBMS Scheduler error
    RnR Pro
    Currently Being Moderated
    Hi,

    You will need to post all create_chain and define_chain_rule and define_chain_step statements to reproduce the problem.

    Does dropping the chain and recreating the chain help ?

    Have you been using dbms_rule directly to do anything (you should not for chains) ?

    -Ravi
  • 5. Re: DBMS Scheduler error
    523648 Newbie
    Currently Being Moderated
    Dropping and recreating also didtn work


    Scripts for Create Chain and Define Chain Step
    -----

    -- Create the Chain object

    -----
    DBMS_SCHEDULER.CREATE_CHAIN (

    chain_name => 'REBPRO_REBATES_PROJECT_CHN',

    rule_set_name => NULL,

    evaluation_interval => NULL,

    comments => 'This chain will be used for testing the Project Rebates chaining process');



    -----

    -- Create the steps associated with chain object

    -----



    DBMS_SCHEDULER.DEFINE_CHAIN_STEP (

    chain_name => 'REBPRO_REBATES_PROJECT_CHN',

    step_name => 'REBPRO_VALIDATE_STEP',

    program_name => 'REBPRO_VALIDATE_DATA_PRG');
  • 6. Re: DBMS Scheduler error
    RnR Pro
    Currently Being Moderated
    Hi,

    This still isn't enough info (both statements run without errors over here. Can you reproduce this on a different database and then post the steps and code that you took to do that ?

    If it doesn't reproduce here's something else to try. Drop the chain and then check the following queries (as SYS)

    select RULE_SET_OWNER, RULE_SET_NAME from dba_rule_sets;
    select RULE_OWNER, RULE_NAME from dba_rules;

    Make sure there are no stale rules or rule sets left over in the chain schema (chains create rules and rule sets under the covers). If there any stale rules or rule sets you can drop them using dbms_rule_adm .

    -Ravi
  • 7. Re: DBMS Scheduler error
    RRSOra? Newbie
    Currently Being Moderated
    Hi Ravi,

    I too am using dbms_scheduler and chains. I too received the following error :
    ERROR=ORA-24155: rule CPM_GS.CH_RU_1_31072012080247 not in rule set CPM_GS.SCHED_RULESET$14635ORA-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 130

    When I checked in dba_scheduler_chain_rules, I found the following - The chain name for CH_RU_1_31072012080247 is GEN_UP_EV_31072012080245. In dba_scheduler_chains the corresponding rule_set_name for the above chain_name is SCHED_RULESET$13940. Even in dba_rule_set_rules the rule_set_name SCHED_RULESET$13940 corresponds to rule_name CH_RU_1_31072012080247.

    The rule_set_name SCHED_RULESET$14635 refers to chain_name GEN_UP_EV_31072012080243 in dba_scheduler_chains. I don't find entries for the rule_set_name SCHED_RULESET$14635 in dba_rule_set_rules nor is there any entry for chain_name GEN_UP_EV_31072012080243 in dba_scheduler_chain_rules. Does this throw some light? How is it that a rule_name that is not related to rule_set_name is displayed in the error? I mean there is no relation between CPM_GS.CH_RU_1_31072012080247 and SCHED_RULESET$14635. Where is it checking for any relationship between these two?

    Many thanks,
    RRS