DTP Problem

[aditya_bakshi]

DTP stays in yellow all the time.The transformation has over 100 lines of code in it is that the reason it is not going through.Not one record is added.Data packet stays in yellow all the time.

Please help.

Unable to add screen.It says content not allowed.

[former_member186399 · Accepted solution]

Dear Aditya

When you run load, try to check in SM50 which table or process the workprocess is hitting. if it is related to one of the codes it would show the same. Also in the DTP monitor it will tell you which step is running.

Another approach is to reduce the data package size, make it as low as possible (may be 1000) and then do the loading. If that doesn't work then you have to optimize the code.

Regards

Gajesh

[aditya_bakshi · Accepted solution]

yes in  sm50 it is hitting one of the update and insert statements in the code to a table.Stuck at end routine.Will try to reduce the data package size.

[RamanKorrapati]

Hi,

Are you sure about Code and transformations are in active?

Can you reactivate your transformations and re run your dtp.

please check your dtp back end job at SM37.

Before this load, have you done changes or transports are moved to prod regarding your dtp/dataflow?

Thanks

[aditya_bakshi]

I checked the Job in SM37

it says "Processing started for batch ID DTPR_12345_1 process 3"

Nothing after that.