Re: dbexport causes error 100 (duplicate where unique index
You have a duplicate index or contraint name in the systables.
Try this at your own risk.
1. Discover the tablename from dbschema.
2. In dbaccess,
select tabid, tabname from systables where tabname = "tablename"
Note the tabid.
3. select * from sysobjstate where tabid = [tabid from step 2];
Note index and contraint names. Run steps 4-7 for each index found.
4. select * from sysobjstate where name = "[index/constraint name]"
We had two entries with different tabids. Note the bogus tabid.
5. select tabid, tabname from systables where tabid = [bogus tabid]
We had "no rows found". Table does not exist.
6. delete from sysobjstate
where name = "[index name]" and tabid = [bogus tabid]
7. select * from sysobjstate where name = "[index/constraint name]"
just to check. Should only return 1 row.
8. Run dbschema for that table. It should work.
|--------+------------------------------->
| | Victor Glass |
| | <vglass@impop.bellatl|
| | antic.net> |
| | |
| | 05/03/2000 08:29 PM |
| | Please respond to |
| | vglass |
| | |
|--------+------------------------------->
>------------------------------------------------------------|
| |
| To: informix-list@iiug.org |
| cc: (bcc: Kernoal Stephens/STS/AUTOZONE) |
| Subject: Re: dbexport causes error 100 (duplicate|
| where unique index exists) |
>------------------------------------------------------------|
This is a multi-part message in MIME format.
--------------38A0303FDD8C3A11D83E27DC
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
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.
--------------38A0303FDD8C3A11D83E27DC
Content-Type: text/x-vcard; charset=us-ascii;
name="vglass.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Victor Glass
Content-Disposition: attachment;
filename="vglass.vcf"
begin:vcard
n:Glass;Victor
tel;fax:908.781.0987
tel;home:908.781.5129
tel;work:908.781.6541
x-mozilla-html:FALSE
org:Integrated Computer Concepts, Inc.
adr:;;26 Ski Hill Drive;Bedminster;NJ;07921;
version:2.1
email;internet:vglass@bellatlantic.net
fn:Vic Glass
end:vcard
--------------38A0303FDD8C3A11D83E27DC--