What is the complete error message you get?
ORA-24155: Regel IDIS_INFRA.END_BS_LAGE befindet sich nicht in Regelgruppe IDIS_INFRA.SCHED_RULESET$2
ORA-06512: in "SYS.DBMS_ISCHED", Zeile 4856
ORA-06512: in "SYS.DBMS_ISCHED", Zeile 1578
ORA-06512: in "SYS.DBMS_SCHEDULER", Zeile 1619
ORA-06512: in Zeile 124
24155. 00000 - "rule %s.%s not in rule set %s.%s"
*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
But I havn't specified a rule set nor have I tried to remove the rule...so I do not understand this error mesage ;-)
Maybe some stuff from old rules. What does the following query return:
select * from user_rule_set_rules;
SCHED_RULESET$1 IDIS_INFRA ABORT_PROCESS ENABLED SCHED_RULESET$1 IDIS_INFRA STAGE_TO_TRANSFORM ENABLED SCHED_RULESET$1 IDIS_INFRA START_PROCESS ENABLED SCHED_RULESET$2 IDIS_INFRA END_ABGKN ENABLED SCHED_RULESET$2 IDIS_INFRA END_BS_FW ENABLED SCHED_RULESET$1 IDIS_INFRA END_PROCESS ENABLED
Ruleset 1 belongs to a different chain. When I drop the chain which contains END_ABGKN then also Ruleset 2 will be dropped. And as you see two rules were created for ruleset 2 althaugh I used the same procedure calls...
Maybe the DEFINE_CHAIN_RULE procedure tries to drop the rule prior to creating it, and it seems there's a conflict with some name. Can you try the same thing without specifying a value for the RULE_NAME parameter?
Also, what does the following return:
select * from user_scheduler_chain_rules;
with RULE_NAME => null it works for all of my rules. When I specify rule names it just works for some of my rules, which I don't understand. But with knowing this fact it's ok for me. Thanks a lot!
There's maybe a bug, but I couldn't find anything relevant in the Oracle Support KB about this problem.
Thanks for the feedback.