Import issue

[Former Member]

When trying to import the design objects, I am getting the below error.

[NWMss][SQLServer JDBC Driver][SQL Server]Violatin of PRIMARY KEY constraint 'PK_XI_PVISRELATION_1B479A0C'.Cannot insert duplicate key in object 'dbo.XI_PVISRELATION'.

Could anyone please suggest me the solution...

Thanks,

[Former Member]

Hi Hareen,

The problem happend in primary key of your table,

when ever we insert same record for second time into to table, We can get the error like " Duplicate key".

I think you are inserted the same data, what you inserted before for key element.

Kindly check it.

Thank you very much.

Sateesh

[Former Member]

Hi Hareen,

NWMssSQLServer JDBC DriverSQL ServerViolatin of PRIMARY KEY constraint 'PK_XI_PVISRELATION_1B479A0C'.Cannot insert duplicate key in object 'dbo.XI_PVISRELATION'.

Make sure the field you mainatained as primary key isl there in the key node of the target data structure.

Also chk the below thread for further help...

Hope this will help you

Regds,

Pinangshuk.

[former_member200962]

If I am not wrong you are pointing to issue during Transport and not during execution of JDBC scenario ....check this similar thread:

Regards,

Abhishek.

[Former Member]

I feel from the error it is pointing to JDBC driver and 'dbo.XI_PVISRELATION' table.

pls check with basis person ...

chirag