RE: SCHAPI error

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, # Txnsblocked 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, # Txnsblocked 0, Plog used 145, Llog used 1834 01:00:04 SCHAPI: Error -1266 Intervals or datetimes are incompatiblefor 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