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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.