7 Replies Latest reply: Aug 1, 2012 5:45 AM by RRSOra? RSS

    DBMS Scheduler error

    523648
      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....
          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....
            Removed as by mistake added the same reply twice.
            Aman....

            Message was edited by:
            Aman....
            • 3. Re: DBMS Scheduler error
              523648
              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-Oracle
                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
                  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-Oracle
                    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?
                      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