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

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 (AT) iiug (DOT) 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 (AT) arz-emmendingen (DOT) 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 (AT) iiug (DOT) org
[mailto:informix-list-bounces (AT) iiug (DOT) 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 (AT) iiug (DOT) 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 (AT) arz-emmendingen (DOT) 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 (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Open a case with IBM.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) 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 (AT) arz-emmendingen (DOT) de> wrote: