Skip to Content
Author's profile photo Antony R

Deleting DTP requests when the DTP step is hanged

This document would explain necessary steps to be taken when the DTP step gets hanged and it runs forever with its request in yellow state, doesn’t allow to delete the request.

Steps

When request in yellow status and unable to change/ delete the request that means the request is in psuedo status i.e it is not doing any activity but still in active state.

Whenever DTP is triggered its request sits in table: RSBKREQUEST with processing type: “5” in data elements “USTATE” and “TSTATE” which means the request is in active state.

          /wp-content/uploads/2013/10/f1_305020.png

Enter Request Id

     

                /wp-content/uploads/2013/10/f1_305020.png

The below screen shot displays “USTATE” and “TSTATE” values for active DTP request, when the DTP is hanged it would be with values “5” in “TSTATE” and “USTATE”

                 /wp-content/uploads/2013/10/f1_305020.png

In order to change the values of data elements “USTATE” and “TSTATE”, pls execute the Function Module: RSBM_GUI_CHANGE_USTATE by inputiing the DTP request number.

            /wp-content/uploads/2013/10/f1_305020.png

                /wp-content/uploads/2013/10/f1_305020.png

After the execution of above function values of “USTATE” and “TSTATE” gets changed to “3” in table: RSBKREQUEST, which signies that the request has been defined as erroneous and requests status gets enabled to be changed to “RED”.

   /wp-content/uploads/2013/10/f1_305020.png

Now the option to delete the DTP request gets enabled and after deletion of DTP request, the “USTATE” and “TSTATE” values  gets changed to “4” in the table: RSBKREQUEST.

         /wp-content/uploads/2013/10/f_305047.png

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Satendra Mishra
      Satendra Mishra

      nice document .... i faced this issue before and correct information.

      🙂

      Regards,

      SM

      Author's profile photo Former Member
      Former Member

      Nice one Antony...

      Regards,

      Purushotham.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Nice work around Antony 🙂

      Author's profile photo Former Member
      Former Member

      Good work

      Regards,

      Sushant

      Author's profile photo Antony R
      Antony R
      Blog Post Author

      Thanks all guys..

      Author's profile photo karthick Ravichandran
      karthick Ravichandran

      Hi Antony,

      very Useful Information. Thanks for Posting

      Regards

      karthick

      Author's profile photo Former Member
      Former Member

      nice document

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice document....... 🙂

      Regards,

      SM

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Very good information..Thanks for sharing 🙂 .