IDS Forum

RE: 1205 error

Posted By: John Adamski
Date: Tuesday, 20 April 2010, at 8:28 a.m.

In Response To: Re: 1205 error (Alexandre Marini)

Alexandre & Art were right as I manually dropped the 3 triggers and then could update at least one of the records in question. Once I get management approval will run the 3rd-party Make process to put the triggers back and see if we get the problem again. My guess we will.

Thanks everyone for help and suggestions.

John

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alexandre Marini
Sent: Monday, April 19, 2010 12:14 PM
To: ids@iiug.org
Subject: Re: 1205 error [19735]

Hello.
You could enable a trace on the error (I always use it here, but I´m on
11.50 version).
Try to start it with:
onmode -I 1205
and monitor your online.log file, until it raises the AF file.
Then remember to trace it of, using
onmode -I

The af file always generates usefull informations.
I hope it works on IDS 10.X version.

Best regards.

Alexandre Marini

Tecnologia da Informação - DBA

msn: alexandre_marini@hotmail.com

SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix

See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf

<http://www.iiug.org>

John Adamski escreveu:
> Art,
>
> Well I'm not seeing any date fields in indexes. From a dbschema:
>
> id integer,
>
> prog char(4),
>
> site char(4),
>
> sess char(4),
>
> yr smallint,
>
> sess_ord smallint
>
> default 0 not null ,
>
> create index "informix".stuac_id on "informix".stu_acad_rec (id)
>
> using btree ;
> create index "informix".stuac_key on "informix".stu_acad_rec (prog,
>
> sess,yr) using btree ;
> create index "informix".stuac_key2 on "informix".stu_acad_rec
>
> (yr,sess,id) using btree ;
> create index "informix".stuac_key4 on "informix".stu_acad_rec
>
> (id,prog,site,yr,sess_ord) using btree ;
> create unique index "informix".stuac_prim on "informix".stu_acad_rec
>
> (id,prog,sess,yr,site) using btree ;
>
> For the audit table
>
> create index "informix".gu_stu_acadrua on "informix".stu_acad_rec
>
> (id,yr,sess,prog) using btree ;
>
> Art, do you know of a way to identify which table ('live' or 'audit') that
is
> giving the 1205 error.
>
> John
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Monday, April 19, 2010 10:53 AM
> To: ids@iiug.org
> Subject: Re: 1205 error [19730]
>
> The problem is likely a bad key in one of the indexes that contains the
> datetime column the engine is complaining about. You can try dropping all
> indexes and constraints (or at least any that reference this column),
> stopping auditing then try to update this row. If you can, then rebuilding
> the indexes should do the trick and you can reinstate the indexes,
> constraints, and auditing.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> 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 Mon, Apr 19, 2010 at 10:48 AM, John Adamski <adamski@graceland.edu>wrote:
>
>
>> HPUX B.11.23 U ia64
>> IDS 10.00.FC9
>>
>> I have a table with 91 columns about 334966 rows and we recently found 1
>> row
>> that can't be updated or deleted. If you try we get a 1205 error (Invalid
>> month in date). There are 3 rows that are data fields and the table has an
>> audit trigger on 15 of the columns which includes the 3 date fields.
>>
>> SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit
>> Modify the current SQL statements using the SQL editor.
>>
>> ----------------------- cars@carsitcp ---------- Press CTRL-W for Help
>> --------
>>
>> update stu_acad_rec
>> set prog="TEST"
>> where id=xxxxxx
>> and sess="FA" and yr=2010
>>
>> 1205: Invalid month in date
>>
>> I have ran an oncheck -cI and oncheck -cD on both the 'live' and 'audit'
>> tables and it finds not problems. The audit table is getting other audits
>> from
>> other rows.
>>
>> Before I go through the obstacle course needed to get IBM support (I have
>> to
>> go through our 3rd party provider). Is there anything else I can do? My
>> assumption is data corruption of some sorts. But sure don't see it. As
>> doing a
>> select in dbaccess or an unload of the row the data looks good.
>>
>> Part of the row in question
>>
>> ....
>> reg_upd_date 02/22/2010
>> no_adrp 0
>> cl_rank 0
>> cl_size 0
>> ....
>> goal
>> wd_code WD
>> wd_date 02/22/2010
>> wd_hrs 0.00
>> last_attended_date 02/22/2010
>> ....
>>
>> I even tried to this which works:
>>
>> select last_attended_date, last_attended_date + 5 fiveplus
>> from stu_acad_rec
>> where id=xxxxxx and sess="FA" and yr="2010"
>>
>> last_attended_date fiveplus
>>
>> 02/22/2010 02/27/2010
>>
>> 1 row(s) retrieved.
>>
>> Any suggestions would be welcomed.
>>
>> John Adamski
>> Network Specialist
>> Graceland University
>>
>>
>>
>>
>>
>
>
*******************************************************************************
>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>
> --001636e0a5e886ead4048498f3ea
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• 1205 error
  John Adamski -- Monday, 19 April 2010, at 10:48 a.m.
  • RE: 1205 error
    Everett Mills -- Monday, 19 April 2010, at 11:24 a.m.
    • RE: 1205 error
      John Adamski -- Monday, 19 April 2010, at 12:57 p.m.
  • Re: 1205 error
    Art Kagel -- Monday, 19 April 2010, at 11:52 a.m.
    • RE: 1205 error
      John Adamski -- Monday, 19 April 2010, at 1:05 p.m.
      • Re: 1205 error
        Art Kagel -- Monday, 19 April 2010, at 1:11 p.m.
        • RE: 1205 error
          John Adamski -- Monday, 19 April 2010, at 2:09 p.m.
      • Re: 1205 error
        Alexandre Marini -- Monday, 19 April 2010, at 1:13 p.m.
        • RE: 1205 error
          John Adamski -- Tuesday, 20 April 2010, at 8:28 a.m.
  • RE: 1205 error
    dharmendra sharma -- Monday, 19 April 2010, at 12:13 p.m.
  • RE: 1205 error
    dharmendra sharma -- Monday, 19 April 2010, at 1:19 p.m.
    • RE: 1205 error
      John Adamski -- Monday, 19 April 2010, at 2:15 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.