Re: SCHAPI error

Did you recently upgrade this server from an earlier 11.xx version? If so, you may have to drop sysadmin and rebuild it. Improperly rebuilt sysadmin databases after an upgrade were a problem in all but the most recent release of 11.50. You can find instructions for doing this if you Google for it. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 1, 2010 at 2:38 AM, Habichtsberg, Reinhard < RHabichtsberg@arz-emmendingen.de> wrote: > 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 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >