Sunday, 6 May 2012

ORA-27419: unable to determine valid execution date from repeat interval

ORA-27419: unable to determine valid execution date from repeat interval

Cause: The specified repeat interval contained conflicting clauses that made it impossible to ever find a matching date, e.g., FREQ=YEARLY;BYMONTH=FEB;BYMONTHDAY=31. Alternatively, the scheduler reached its maximum number of attempts to try to find a valid execution date. This occurs when theoretically there is a valid execution date far in the future, but the scheduler took too many attempts to determine this date.

Action: Remove the conflicting clauses, or simplify the repeat interval so that it is easier to determine the next execution date.

No comments:

Post a Comment