Skip to Content
0
Former Member
Dec 03, 2008 at 10:27 PM

data load from write optimized ODS failed

33 Views

Hi,

I am loading data from a write optimized ODS to a standard ODS.

It is a full load with DTP filter.

The load is failing It is giving the following error msg:

Duplicate data record detected (DS YF2IG012 , data package: 002702 , data record: 439 ) RSODSO_UPDATE 19 35 3R

What does it mean?

I am writing code in the routine where i am spliting the record into maximum 3 records based on some condition.

My source is at day level and my target at month level.

A record coming in with a date from the source should go into the corresponding months in that quarter. But not the completed months in that quarter.

I have reduced the data pakage size to 20000 and tried but no use.

In the error message you can see that it has loaded nearly 2702 datapakages.

How to debug the issue?

Please help me in solving the issue.

Thanks advance.

-Raghu