ORA-27419: unable to determine valid execution date from
repeat interval
Answers were Sorted based on User's Feedback
Answer / senthilora
Two of my jobs have failed with the same error.
They were using the following scheduled clauses:
'FREQ=HOURLY;BYMINUTE=0'.
I scheduled them to run for 3 days by setting up start_date
and end_date attribute of scheduler.
They ran successfully for every hours for 3 days and failed
on 3rd day when it reached the end_date (time).
I think, this error can be read as a alarm note to note that
the scheduler has reached the end_date and so the jobs which
are all using this scheduler will not be executed here after.
Regards
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
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.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 1 No |
O2F-00334: A user-defined type is listed more than once in the INTYPE file
IMG-02008: 2FF08 - color histogram feature cannot be determined
SQL*Loader-00823: TREAT AS clause for object tables not supported for external tables
ORA-39726: unsupported add/drop column operation on compressed tables
DRG-10506: table does not exist: string
TNS-00122: Missing ADDRESS(es) in TNSNET.ORA file
ORA-31047: Could not retrieve resource data at path string
ORA-27043: unable to seek to beginning of file
ORA-28664: a partitioned table may not be coalesced as a whole
ORA-39098: Worker process received data objects while loading metadata. Invalid process order range is string..string
ORA-06558: buffer in dbms_pipe package is full. No more items allowed
RMAN-08501: output filename=string recid=string stamp=string