import DB schema from ODBC Error

[sz]

EA version is 8.
I have 3 tables (d.tbl,s.tbl and r.tbl) with same table name but different schema(tables are similar but not identical), when I try to use EA to Import DB schema from ODBC (under Code Engineering) for any table (one of the three) , I got the error msg:
-----------------------------------------------
DAO.Recordset[3022]
the changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
----------------------------------------------
click OK and the table loaded but only load d.tbl whenever which schema is selected.
After remove all the index and primary key, the result is same.

How I can import tables with same table name but different schema?
Thanks.

[Geert Bellekens]

sz,

I've envountered that issue a while ago as well.
For me it was solved by filtering the ODBC import on owner/schema.
(I only needed the dbo. tables and not the dba. tables)
I guess the only workaround is to reverse engineer each schema seperately in a different package.

You might want to report this as a bug to Sparx as well.

Geert