"ORA-01850: hour must be between 0 and 23" when creating scheduled alert


 Product(s):Exor Network Manager
 Version(s):04.07.00.01
 Environment:N\A
 Area:Other
 Subarea:N\A

Error or Warning Message

ORA-01850: hour must be between 0 and 23

ORA-06512: at "HIG_ALERT", line 2246

Explanation

This error occurred when applying a bespoke schedule frequency to an alert and saving the record.  The schedule frequency in this case was named 'daily at 7' and specified as:

freq=daily; byhour=7; byminute=0; bysecond=0;

How to Avoid

Use a leading zero in the frequency definition for any single-digit hours, i.e.

freq=daily; byhour=07; byminute=0; bysecond=0;

 Original Author:Sarah Williams