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 |
PROC-00106: Unidentified component error
NCR-01018: NCRS: Encryption failure.
TNS-12204: TNS:received data refused from an application
ORA-24024: Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]
DGM-17002: Primary database can not be removed.
PCC-02373: Invalid declaration in EXEC SQL DECLARE section
ORA-16061: Log file status has changed
PCC-02151: Line number column number file string:
ORA-24156: duplicate table alias string
ORA-01088: cannot shut down ORACLE while active processes exist
ORA-12170: TNS:Connect timeout occurred
ORA-19361: ONLINE option not allowed with this type of index