IDS Forum

1205 error

Posted By: John Adamski
Date: Monday, 19 April 2010, at 10:48 a.m.

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

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.