Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers