Oninit cdi / Archive
Talk to an expert →

dbexport causes error 100 (duplicate where unique index exists)

Posted in 2000

Topics: Error Codes & Troubleshooting, Migration, Import/Export & Data Conversion

azteczenith@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

I am having a problem. I am on SE 7.2X on linux platform. Everytime I try to do a dbexport it gives me an ISAM error 100- Duplicate records with unique index. I dont have any data in the table giving me the problem. The only way I could proceed was to drop the table and re-create it. But running dbexport again stopped at the next table with the same error and this table did not have any unique indexes, constraints or anything. Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to azteczenith@my-deja.com
Victor Glass — — source: Informix-list mailing list archive (1991-1998)

I too have just experienced this error using dbschema on IDS 7.3, running under AIX 4.3. And I am very interested in knowing what set of circumstances causes this. azteczenith@my-deja.com wrote: > I am having a problem. I am on SE 7.2X on linux > platform. Everytime I try to do a dbexport it > gives me an ISAM error 100- Duplicate records > with unique index. > I dont have any data in the table giving me the > problem. The only way I could proceed was to drop > the table and re-create it. But running dbexport > again stopped at the next table with the same > error and this table did not have any unique > indexes, constraints or anything. > > Sent via Deja.com http://www.deja.com/ > Before you buy.

Glossary