Skip to Content
avatar image
Former Member

Long Running DTP using Process Chain in BW

We have a process chain scheduled to run only on Sunday.

One of the DTP step loads Forecast data from DSO to CUBE which is running for 13 hours to complete the load and the record count is approximately 90 million. If i run the same DTP manually (by cancelling the process chain DTP step and trigger it manually) its taking maximum 3 hours to complete the same record counts.

Due to this long running load system occupies more memory which is affecting the PROD system sometimes for other parallel processing. We raised an incident to my Basis team and they confirmed there is no issue in the system level and system ID level.

Note : Process chain is running using the System ID (CB**) and we are running manually using our SAP logon ID.

Please suggest what will be the root cause for this issue and how to put a permenant fix. Regards, Karthik.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers