Skip to Content
avatar image
Former Member

DTP Problem

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 13, 2015 at 11:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.


  • avatar image
    Former Member
    Jan 13, 2015 at 11:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I checked the Job in SM37

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

      Nothing after that.