Skip to Content

DTP from DSO to CUBE is taking unusual time for huge records

Mar 23, 2017 at 03:59 PM


avatar image
Former Member

Hi Experts,

I am loading huge amount of data (11M) in a DTP from DSO to CUBE in prod in delta mode.(Version 7.4)

Checking the history of runs could see every year in the beginning days it pulls huge amount of records.Every year it runs fine but this year year its taking long time more than 20 days.(No changes recently)

I have tried deleting the cube index before triggering the load.

I have tried Increasing background processes to 6 and reducing the DP size to 20K but still not fast enough.

I have check for inconsistencies in RSRV but found none.

It gets stuck in Error handling step while processing so changed that from Cancel request,Track error records first,No update to Request red,Write error stack,Update valid records but still the same.

In sm37 logs could see its takes time to progress in Deriving PC logID steps ,the time increases gradually with dp's.

There is enough background work processes in SM50 for running this.

Kindly suggest what may be the issue.

Thanks in advance.

10 |10000 characters needed characters left characters exceeded

Hi Ekant,

Did you get solution for this issue? I am facing the same issue.



* Please Login or Register to Answer, Follow or Comment.

0 Answers