SAP BW DTP Long Time running

[Former Member]

Hi team,

While DTP executed the status is in yellow and the job log is not changing from the step RSBATCH_EXECUTE_PROZESS, variant and running more than 48 hours.The records are also very less and DTP status in yellow and Iforced the status of DTP to red.But still the job is running in sm37.I Deleted the locks in SM12. Could you a please sugest any solution.

Thanks and Regards,

Umakanth

[Former Member]

Hi Uma,

Make sure all notes implemented from this collective note:

1827854 - Enqueue/Lock during parallel data loads

And suggested ST12 trace or transaction SM66 is also useful to analyze further.

Best regards, Andras

[former_member231709]

Also for detail explanation see note 2356627 - Initial DTP analysis in a nutshell [VIDEO]

[Former Member]

Hi Uma,

please check what is workprocess which you can find in SM37 t-code doing at the moment? You can check it in t-code SM50

Kind regards,

Andrey