Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi,
each night there appears an message in the message log:
ERROR -1266 Intervals or datetimes are incompatible
Found this with select * from ph_alerts in sysadmin database:
alert_id 1511
run_id 7786
task_id 16
task_name Auto Update Statistics Evaluation
task_description To Evaluate which columns and tables should have the statist
ics and distributions refreshed.
alert_type WARNING
alert_color GREEN
alert_time 2010-07-01 01:00:03
alert_state NEW
alert_object_type MISC
alert_object_name
alert_message TASK NAME Auto Update Statistics Evaluation
LOCATION <UNKNOWN>
ERROR -1266 Intervals or datetimes are incompatible
for the operation.
How can we suppress this error?
TIA, Reinhard
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.