Oninit cdi / Archive
Talk to an expert →

Re: SCHAPI error

Posted in 2010

Art Kagel — — source: Usenet: comp.databases.informix

Open a case with IBM. 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 Fri, Jul 2, 2010 at 1:45 AM, Habichtsberg, Reinhard < RHabichtsberg@arz-emmendingen.de> wrote: > Sysadmin DB was rebuilt. Error appears again, anyway: > > > > 08:56:08 Building 'sysadmin' database ... > > 08:56:31 'sysadmin' database built successfully. > > 08:56:31 SCHAPI: Started dbScheduler thread. > > 08:56:31 SCHAPI: Started 2 dbWorker threads. > > 08:56:31 Checkpoint Completed: duration was 0 seconds. > > 08:56:31 Thu Jul 1 - loguniq 148, logpos 0x123e018, timestamp: 0x3bf9263> Interval: 457 > > > > 08:56:31 Maximum server connections 2 > > 08:56:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked> 1, Plog used 1319, Llog used 2270 > > > > > > Fri Jul 2 01:00:00 2010 > > > > 01:00:00 Checkpoint Completed: duration was 0 seconds. > > 01:00:00 Fri Jul 2 - loguniq 148, logpos 0x1968018, timestamp: 0x3c04fa9> Interval: 458 > > > > 01:00:00 Maximum server connections 2 > > 01:00:00 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked> 0, Plog used 145, Llog used 1834 > > > > 01:00:04 SCHAPI: Error -1266 Intervals or datetimes are incompatible for> the operation. > > 01:00:04 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, > Location: NULL. > > 01:00:04 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation,> Error Message: Unable to execute function [ aus_evaluator(integer,integer) ] > . > > > > Version is: IBM Informix Dynamic Server Version 11.50.FC5W4X9. > > > > Any idea? > > > > Reinhard > > > > *From:* informix-list-bounces@iiug.org [mailto: > informix-list-bounces@iiug.org] *On Behalf Of *Art Kagel > *Sent:* Thursday, July 01, 2010 1:11 PM > *To:* Habichtsberg, Reinhard > *Cc:* Informix-List (E-Mail) > *Subject:* 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 > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >

Related threads