Re: Strange error with date field (Online 5.01)

Posted in 1996

David Williams — Tue, 24 Sep 1996 20:42:44 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <5283bd$mmn@sparcserver.lrz-muenchen.de>, Richard Spitz <spitz@ana.med.uni-muenchen.de> writes >Douglas Wilson <dougw@amgen.com> wrote: >DW: Try updating the date to a valid date with the between clause: >DW: update edomorg set opdate="19.09.96" >DW: where opdate between "19.09.96" and "20.09.96" > >DW: since they get selected, they should get updated(hopefully) > >The update failed with a similar error: > >346: Could not update a row in the table >105: ISAM error: bad isam file format> >I also looked in the "online.log" file. There it says: > >09:34:18 Rowid 0xc01 not found for delete in partnum 10000d8, key 1 >09:34:18 7fffe488: 11098108 00000001 34de98e6 00050012 ........ 4....... >09:34:18 Run tbcheck -cI 16777432 >09:34:18 -- Fail Consistency Check -- Delete failed -- pid=19591 user=104>us=11001ee8 > >The suggested "tbcheck -cI 16777432" returns no error. > >I am still clueless... > >Regards, Richard Try running the following tbcheck -cr tbcheck -ce tbcheck -cc <database name> tbcheck -cID <database name> -- David Williams