Re: Index creation problem

dllewell@dimensional.com (Daniel Llewellyn) wrote: :Nils.Myklebust@idg.no (Nils Myklebust) wrote: :>Have you realy checked that ther is no such index. I mean run dbschema :>or used dbaccess (or was it isql at the time). :>If there is no such index you might have run across a bug in a product :>so old your only option is to upgrade. :>Before you do that you might want to try to dbexport your database, :>drop it and import it again just to make sure there is no :>inconsistency in the database. Running bcheck or tbcheck first might :>also be an idea. : Yes, I have confirmed that the index truly does not exist, I have run :dbschema on the effected table and I have check sysindexes table. :Neither sources believe the index exist. : The problem has occured twice now. The first time I dropped the table :and recreated it. That fixed the problem, I could then create the new :index. It has happened a second time now , however, and I don't want :to have to drop the table and recreate it every couple of weeks. : Daniel And what about bcheck/tbcheck (you didn't say whether you had SE or OnLine)? If that doesn't tell you anything I would now dbexport the whole database. Remove it (drop database) and recreate it with dbimport. In the case of OnLine (on raw disk) I would reformat the disks, run scsibadtrk (i think it's called) to check the disk, reinitialize OnLine and then dbimport. If this doesn't help - well an upgrade is the last resort then. It is due time to upgrade anyway. There are lots of new features and facilities around you might find usefull. But if you have a running application and no new developments it might be overkill. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company