Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

100 - ISAM error: duplicate value for a record with unique key

Status
Not open for further replies.

krusely

Technical User
Feb 21, 2008
5
US
Red Hat Enterprise Linux Server release 5.8 (Tikanga)
$ dbschema -d $DBNAME -t invc_hdr

DBSCHEMA Schema Utility INFORMIX-SQL Version 7.25.UC6R1
Copyright (C) Informix Software, Inc., 1984-1997
Software Serial Number CML#R364550
100 - ISAM error: duplicate value for a record with unique key.

I can't schema this table. Can't find 'myschema' either on the server to try a schema with that either.
I know what the indexes look like from other servers so I've dropped the unique index and rebuilt it as non-unique.
Did a search for the old unique value and it didn't come up with anything.
I'm thinking there is something corrupt in sysindexes, syscolumns, or systables. Has anyone seen this?
This table is huge and an unload, remove table, rebuild, and reload of data isn't an option.

Any ideas.
Tom K
 
Forum404 would possibly be a better location for your question.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

Never mind this jesus character, stars had to die for me to live.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top