Devart Forums

The same mistake continues

Oracle Version

OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.5.0
Oracle Data Provider for Net 9.2.0.7
Oracle Net 9.2.0.1.0 (I installed the "Oracle Data Provider for Net 9.2.0.7" and was installed this version)

I need change de Oracle Net??? (¿Can I download from where?)

I am importing as Exhibit 3 tables, but to have the error, imported a single table and the error persists.

The tables are really small, a table have eleven fields, other table have four fields and another table has two fields. I tried each of these individual.

Table details:

create table TLC_SUSPREAC_TA_ARCHIVO
(
ID_SECUENCIA NUMBER not null,
NOMBRE_ARCHIVO VARCHAR2(50) not null,
USUARIO VARCHAR2(20) not null,
COMENTARIO VARCHAR2(1024)
)
alter table TLC_SUSPREAC_TA_ARCHIVO
add constraint PK_SUSPREAC_SECUENCIA primary key (ID_SECUENCIA)

create table TLC_SUSPREAC_TA_LINEAS
(
NUMERO VARCHAR2(50) not null,
FK_ID_SECUENCIA NUMBER
)
alter table TLC_SUSPREAC_TA_LINEAS
add constraint FK_SUSPREAC_IDSECUENCIA foreign key (FK_ID_SECUENCIA)
references TLC_SUSPREAC_TA_ARCHIVO (ID_SECUENCIA);
create index IDX_SUSPREAC_IDSECUENCIA on TLC_SUSPREAC_TA_LINEAS (FK_ID_SECUENCIA)
create index IDX_SUSPREAC_NUMERO on TLC_SUSPREAC_TA_LINEAS (NUMERO)

create table TLC_SUSPREAC_TA_LOG
(
FK_ID_TRANSACCION NUMBER(15) not null,
FK_ID_SECUENCIA NUMBER(15),
DESC_TIPO_TRANSACCION VARCHAR2(100),
PRODUCTO NUMBER(15),
NUMERO VARCHAR2(50),
FECHA DATE,
SOLICITUD NUMBER(15),
MOTIVO NUMBER(15),
USUARIO VARCHAR2(50),
COMENTARIO VARCHAR2(1024),
ESTADO VARCHAR2(4000)
)

alter table TLC_SUSPREAC_TA_LOG
add constraint FK_ID_SECUENCIA foreign key (FK_ID_SECUENCIA)
references TLC_SUSPREAC_TA_ARCHIVO (ID_SECUENCIA);
alter table TLC_SUSPREAC_TA_LOG
add constraint FK_ID_TRANSACCION foreign key (FK_ID_TRANSACCION)
references FLEX.TLC_TA_APIS_TRANSACCION_LOG (ID_TRANSACCION);
create index IDX_ID_TRANSACCION on TLC_SUSPREAC_TA_LOG (FK_ID_TRANSACCION)
create index IDX_SUSPREAC_TALOG_NUMERO on TLC_SUSPREAC_TA_LOG (NUMERO)
create index IDX_SUSPREAC_TALOG_PRODUCTO on TLC_SUSPREAC_TA_LOG (PRODUCTO)

Switch to the new version(4.75.42), but now I have to try to generate the error:

- The item with identity 'XXX' already exists in the metadata collection. Parameter name: item

'XXX' it the name of the field

I have a serious problem:

-- Adding an item type ASO.Net Entity Model
-- Select or create a new connection to Oracle
-- Select tables for inclusion in the model
-- Completion
-- Remains hung system, I have to close because no response VS2008

Configuration:
-VS2008 SP1
-ORADIRECT 4.75.41.0
-Oracle 9i

I need to solve this problem in order to generate new projects using your provider.

Thanks,