Error 1265
Informix 11.70.FC5GE OS: Linux openSUSE 11.3 (x86_64) Every 10 seconds I get message in online.log: 08:44:00 SCHAPI: [post_alarm_message 0-580664] Error -1265 Overflow occurred on a datetime or interval operation. 08:44:10 SCHAPI: [post_alarm_message 0-580664] Error -1265 Overflow occurred on a datetime or interval operation. it seems that everything works fine on the server, except this messages ... Bounce Informix and restart Linux did not help. Server has worked 3 years without this message. Does anyone have any ideas?
This is coming from Client side operation. Either any of your program or=20
SQL at DB access is calculating some INTERVAL for Datetime field.Check the =
precision that is specified for an INTERVAL value. If the INTERVAL value=20
that you want to enter is greater than the default number of digits that=20
are allowed for that field, you must explicitly identify the number of=20
significant digits in your definition.=20
Use onstat -g SQL to findout what all queries are running.
Thanks,,
Amitava
(This is an Informix Enthustic Comment - IBM company not responsible)
From: "Ivan Zavis" <ivan.zavis@mi-system.co.rs>
To: ids@iiug.org
Date: 12/02/2015 12:55 PM
Subject: Error 1265 [36138]
Sent by: ids-bounces@iiug.org
Informix 11.70.FC5GE=20
OS: Linux openSUSE 11.3 (x86=5F64)=20
Every 10 seconds I get message in online.log:=20
08:44:00 SCHAPI: [post=5Falarm=5Fmessage 0-580664] Error -1265 Overflow=20
occurred on a datetime or interval operation.=20
08:44:10 SCHAPI: [post=5Falarm=5Fmessage 0-580664] Error -1265 Overflow=20
occurred on a datetime or interval operation.=20
it seems that everything works fine on the server, except this messages=20
...=20
Bounce Informix and restart Linux did not help.=20
Server has worked 3 years without this message.=20
Does anyone have any ideas?=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Thank you for your reply.
Yes, that's what I thought, but the message appears non-stop even when
there is not an active client on the server !
I found (and resolve) the problem:
On database sysadmin in one task was wrong tk_next_execution value
(3918- 11-09 00:03:31) because someone mistakenly set system time on the
server, for a moment ...
On 03.12.2015 08:07, Amitava Chakraborty wrote:
> This is coming from Client side operation. Either any of your program or=20
> SQL at DB access is calculating some INTERVAL for Datetime field.Check the =
>
> precision that is specified for an INTERVAL value. If the INTERVAL value=20
> that you want to enter is greater than the default number of digits that=20
> are allowed for that field, you must explicitly identify the number of=20
> significant digits in your definition.=20
>
> Use onstat -g SQL to findout what all queries are running.
>
> Thanks,,
> Amitava
> (This is an Informix Enthustic Comment - IBM company not responsible)
>
> From: "Ivan Zavis" <ivan.zavis@mi-system.co.rs>
> To: ids@iiug.org
> Date: 12/02/2015 12:55 PM
> Subject: Error 1265 [36138]
> Sent by: ids-bounces@iiug.org
>
> Informix 11.70.FC5GE=20
> OS: Linux openSUSE 11.3 (x86=5F64)=20
>
> Every 10 seconds I get message in online.log:=20
>
> 08:44:00 SCHAPI: [post=5Falarm=5Fmessage 0-580664] Error -1265 Overflow=20
> occurred on a datetime or interval operation.=20
> 08:44:10 SCHAPI: [post=5Falarm=5Fmessage 0-580664] Error -1265 Overflow=20
> occurred on a datetime or interval operation.=20
>
> it seems that everything works fine on the server, except this messages=20
> ....=20
>
> Bounce Informix and restart Linux did not help.=20
>
> Server has worked 3 years without this message.=20
> Does anyone have any ideas?=20
>
> ***************************************************************************=
> ****=20
>
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--
*Ivan Zavi*
System & database administrator
*T* +381 21 68 98 608 | *M* +381 69 846 99 08
*@*ivan.zavis@mi-system.co.rs <mailto:ivan.zavis@mi-system.co.rs>
*M&I Systems, Co. Group*
Bulevar vojvode Stepe 16, 21000 Novi Sad
*T:* +381 21 68 98 602
*F:* +381 21 68 98 604
*@:* info@mi-system.co.rs
*w:* www.mi-system.co.rs
<http://www.facebook.com/pages/MI-Systems-Co/263409380366499>;
<http://www.linkedin.com/company/m&i-systems-co.>;
<http://www.youtube.com/misystemsco>;
Odricanje od odgovornosti:
Ovaj dokument namenjen je samo licima kojima je upucen i za pozivanje na
isti od stane bilo kog lica, neophodna je naknadna pismena potvrda
njegovog sadraja. Shodno tome, M&I Systems, Co. Novi Sad odrice svaku
odgovornost i ne prihvata bilo kakvu obavezu (ukljucujuci slucaj
nepanje) za posledice koje moe pretrpeti bilo koje lice zbog cinjenja
ili necinjenja na bazi takve informacije pre nego to takva lica prime
dodatnu pismenu potvrdu. Ukoliko ste grekom primili ovu elektronsku
poruku, unitite ili izbriite istu sa vaeg racunara. Svako
umnoavanje, irenje, kopiranje, obelodanjivanje, izmene, distribucija
i/ili objavljivanje ove elektronske poruke je strogo zabranjeno. Sadraj
ove elektronske poruke ne predstavlja nuno stavove M&I Systems, Co.
Novi Sad
Not client side. The message is coming from some task running in the Task
Manager. You have to track that down. Look in the sysadmin:ph_task table to
see what tasks are running at the times when the messages come out and
whittle the list down until you figure it out.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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, Dec 3, 2015 at 2:58 AM, Ivan Zavis <ivan.zavis@mi-system.co.rs>
wrote:
> Thank you for your reply.
>
> Yes, that's what I thought, but the message appears non-stop even when
> there is not an active client on the server !
>
> I found (and resolve) the problem:
> On database sysadmin in one task was wrong tk_next_execution value
> (3918- 11-09 00:03:31) because someone mistakenly set system time on the
> server, for a moment ...
>
> On 03.12.2015 08:07, Amitava Chakraborty wrote:
> > This is coming from Client side operation. Either any of your program
> or=20
> > SQL at DB access is calculating some INTERVAL for Datetime field.Check
> the =
> >
> > precision that is specified for an INTERVAL value. If the INTERVAL
> value=20
> > that you want to enter is greater than the default number of digits
> that=20
> > are allowed for that field, you must explicitly identify the number of=20
> > significant digits in your definition.=20
> >
> > Use onstat -g SQL to findout what all queries are running.
> >
> > Thanks,,
> > Amitava
> > (This is an Informix Enthustic Comment - IBM company not responsible)
> >
> > From: "Ivan Zavis" <ivan.zavis@mi-system.co.rs>
> > To: ids@iiug.org
> > Date: 12/02/2015 12:55 PM
> > Subject: Error 1265 [36138]
> > Sent by: ids-bounces@iiug.org
> >
> > Informix 11.70.FC5GE=20
> > OS: Linux openSUSE 11.3 (x86=5F64)=20
> >
> > Every 10 seconds I get message in online.log:=20
> >
> > 08:44:00 SCHAPI: [post=5Falarm=5Fmessage 0-580664] Error -1265
> Overflow=20
> > occurred on a datetime or interval operation.=20
> > 08:44:10 SCHAPI: [post=5Falarm=5Fmessage 0-580664] Error -1265
> Overflow=20
> > occurred on a datetime or interval operation.=20
> >
> > it seems that everything works fine on the server, except this
> messages=20
> > ....=20
> >
> > Bounce Informix and restart Linux did not help.=20
> >
> > Server has worked 3 years without this message.=20
> > Does anyone have any ideas?=20
> >
> >
> ***************************************************************************=
> > ****=20
> >
> > Forum Note: Use "Reply" to post a response in the discussion forum.=20
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --
> *Ivan Zavi*
> System & database administrator
> *T* +381 21 68 98 608 | *M* +381 69 846 99 08
> *@*ivan.zavis@mi-system.co.rs <mailto:ivan.zavis@mi-system.co.rs>
>
> *M&I Systems, Co. Group*
> Bulevar vojvode Stepe 16, 21000 Novi Sad
> *T:* +381 21 68 98 602
> *F:* +381 21 68 98 604
> *@:* info@mi-system.co.rs
> *w:* www.mi-system.co.rs
>
> <http://www.facebook.com/pages/MI-Systems-Co/263409380366499>;
> <http://www.linkedin.com/company/m&i-systems-co.>;
> <http://www.youtube.com/misystemsco>;
> Odricanje od odgovornosti:
> Ovaj dokument namenjen je samo licima kojima je upucen i za pozivanje na
> isti od stane bilo kog lica, neophodna je naknadna pismena potvrda
> njegovog sadraja. Shodno tome, M&I Systems, Co. Novi Sad odrice svaku
> odgovornost i ne prihvata bilo kakvu obavezu (ukljucujuci slucaj
> nepanje) za posledice koje moe pretrpeti bilo koje lice zbog cinjenja
> ili necinjenja na bazi takve informacije pre nego to takva lica prime
> dodatnu pismenu potvrdu. Ukoliko ste grekom primili ovu elektronsku
> poruku, unitite ili izbriite istu sa vaeg racunara. Svako
> umnoavanje, irenje, kopiranje, obelodanjivanje, izmene, distribucija
> i/ili objavljivanje ove elektronske poruke je strogo zabranjeno. Sadraj
> ove elektronske poruke ne predstavlja nuno stavove M&I Systems, Co.
> Novi Sad
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113eeaf41fc83c0525fcda97