Problem with duplicated keys while inserting in database

CloverDX Platform
1

Hi,
I found some problems when inserting data in DB_OUTPUT_TABLE.
I post here my graph and my test files.
When inserting say 3 records, with first record with duplicated primary key, I got a DB error for all 3 records (they are rejected as duplicated) but I expect only error on wrong record.

I encountered this problem only with MS SQLServer2005, while on Oracle 10g it works properly.
Is this a possible fault or configuration problem?
Any answer would be really appreciated…
Thanks.

Sample Graph:

<?xml version="1.0" encoding="UTF-8"?>

Sample Data:
(Run 1, correct)
00000;zxc;qa1

(Run 2, all 3 line rejected instead of first)
00000;zxc;qa1
11111;abc;qwe
22222;zxc;qa1

2

What is in error message?

3

The error message is the standard database error for duplicated keys:
“Violation of PRIMARY KEY constraint ‘PK_test’. Cannot insert duplicate key in object ‘dbo.test’.”
The matter is that I got the same message also for correct records, which are not inserted in database.
It seems that after first error, every record looks like duplicated.
Thanks

4

Pls check you database table definition. I can’t replicate your problem (I have only one record rejected).