Skip to Content
0
Former Member
Aug 07, 2009 at 09:59 AM

DTP Error: Duplicate data record detected

1127 Views

Hi experts,

I have a problem with loading data from DataSource to standart DSO.

In DS there are master data attr. which have a key containing id_field.

In End routine I make some operations which multiple lines in result package and fill new date field - defined in DSO ( and also in result_package definition )

I.E.

Result_package before End routine:

__ Id_field ____ attra1 ____ attr_b ...___ attr_x ____ date_field

____1________ a1______ b1_________ x1

____2________ a2______ b2_________ x2

Result_package after End routine:

__ Id_field ____ attra1 ____ attr_b ..___ attr_x ____ date_field

____1________ a1______ b1_________ x1______d1

____2________ a1______ b1_________ x1______d2

____3________ a2______ b2_________ x2______d1

____4________ a2______ b2_________ x2______d2

The date_field (date type) is in a key fields in DSO

When I execute DTP I have an error in section Update to DataStore Object: "Duplicate data record detected "

"During loading, there was a key violation. You tried to save more than one data record with the same semantic key."

As I know the result_package key contains all fields except fields type i, p, f.

In simulate mode (debuging) everything is correct and the status is green.

In DSO I have uncheched checkbox "Unique Data Records"

Any ideas?

Thanks in advance.

MG