Skip to Content
0
Former Member
Apr 29, 2014 at 09:28 AM

Loading problem from standard dso to write optimized

136 Views

loading data from standard dso to write optimised dso.

Write optimized dso settings:
Allow Duplicate data records ( Not checked)
Check Delta Consistency ( Not checked)

Both the source and target have the same key fields and data fields. Trasnformation is set to overwite for amount fields.

DTP Settings :

Extraction mode : Delta
No Filter and No semantic groups


In the first load there is one record in standard dso and it went well into write optimised,

In the second load there is a change for the same record in stadard dso say revenue changed from 20 to 10.

So now the change log has formed 2 records ie one is before image ie rev = -20 and after image ie rev = 10.

When we load this data to the write optimiz dso , it is throwing an error. I dont understand why it is bringing two records from source ie before image and after image?

Error message :

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

The problematic (newly loaded) data record has the following properties:

o DataStore object: YSALESREV

o Request: DTPR_8XOIEHP3K2LDIEKL6MROUUX1M

o Data package: 000001

o Data record number: 1

Kindly throw some light on this issue.