Re: Engine assertion failure for create Index

Have you ran oncheck -cD on this table? On 8/2/07, mohitanchlia@gmail.com <mohitanchlia@gmail.com> wrote: > > Version: IDS 10 > > Informix engine threw "altering older version row to latest version > failed" error when I tried to create index on one of the tables. > Little history on the events: > > 1. I disabled all the constraints and indexes on this table > 2. Then I realized that I need to drop one column, so I dropped one > column of this table > 3. Loaded data to this table using hpl > 4. Ran level 0 archive > 5. Ran create index for this table and then engine gave error > "altering older version row to latest version failed". It also points > to "File: rssupp.c Line: 2874" > > I am not sure if it's a bug in Informix that it's not recognizing the > changes that I did in point 2 above. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- The biggest oxymoron: common sense