Skip to Content

DIFFERENT SCENORIOS FOR CHANGING THE STATUS OF A REQUEST

Error Description:

Sometimes there arises a situation, wherein you need to change the status of a request that is getting loaded via a DTP. This article describes the solution for this scenario.

Generally we will be facing this issue when DTP load for DSO is running more than its due time i.e. (taking more time to load data) and hence stays in yellow state for a long time and you want to stop the load to the DSO by changing the status of the loading request.

  • Below screen shot shows the overall status as ‘yellow’. It means that “Load successfully finished but background work process got stuck”.

   For Example: – If we consider the below screen shot, Here the DTP request got stuck in processing State, need to apply trial and error methods for this scenario to make the status to be successful.

 

  • The above error refers that the previous request still processing / Already being processed.
  • To confirm the error check the DTP logs.

Note: – We need to analyze the situation in different scenarios.

DIFFERENT METHODS FOR CHANGING THE STASTUS OF  A REQUST

Scenario 1: Changing the Overall Status Manually

Scenario 2: Changing the status using RSBM_GUI_CHANGE_USTATE

Scenario 3: Changing Overall Status Manually at Process Chain Level

Scenario 4: Changing Status at Target Level

Scenario 5: Changing Status using RSBK REQUEST

Scenario1: Changing the Overall Status Manually

  • Change the Overall status manually in Monitor.
  • Click the overall status at Header tab, then following popup will be displayed, Here select the appropriate status and click on continue.

        

Finally: After completion of the above steps the status will be changed to Green or Red as per changes made.

Scenario2: Changing the status using FM – RSBM_GUI_CHAGE_USTATE

To change the status use FM “RSBM_GUI_CHANGE_USTATE”

                    

  • Enter the Request number as below to change the status.

          

  • Change the status to green as shown below and then click on continue.

          

Finally After completion of the above steps the status will be changed to Green or Red as per changes made.

Scenario3: Changing Overall Status Manually at Process Chain Level

  • Right click on the DTP and then click on DISPLAY VARIANT  à
  • Click on the ‘CHANGE’ option then the options will highlight.
  • Select the option “Set over All Status Manually”.
  • Then Click on ‘Activate’ to activate the DTP.

  • After the above process click on Monitor tab and change the appropriate status.

Finally: After completion of the above steps the status will be changed to Green or Red as per changes made.

            Scenario4: Changing status at Target Level

    

  • Go to the Data Target ZCSDSO01 (For E.g.) by RSA1 then Click on Manage.
  • Select the Request that need to be delete , then change status to RED.

  • After completion of above process the request status changed to RED.
  • Then Repeat the failed DTP to reload the data.

   Finally: After completion of the above steps the status will be changed to Green or Red as per changes made.

Scenario5:  Changing status using RSBK REQUEST

  • When old request in Scenario 1 & 2 is in yellow status and you are not able to change / delete the request, it’s actually in a pseudo status. This request sits in table RSBKREQUEST with processing type as 5 in data elements USTATE, TSTATE and this 5 is actually “Active” status which is obviously wrong. One of the possible solutions is to ask a basis person to change the status to 3 in both USTATE and TSTATE and then it allows reloading the data. Once the data is successfully loaded, you can delete the previous bad request even though it is still in yellow. Once the request is deleted, the request status gets updated as “4” in table RSBKREQUEST.

  • If all the above methods didn’t give the exact solution for this issue.

  • Then check out the entries in the table as following the below steps.
  • Go to SE16 T-Code, And enter the table name as “RSBKREQUEST”, Click on “Table Contents” tool.

             

  • As shown in the below screen shot provide the request which is pseudo state, and click on Execute.

  • Now select the request and then click on DISPLAY to see the contents of the table.

  • If the UState and Tstate are in 2 (Processed successfully), Then there are no issues in the Request table.
  • If it is belonging to any other number except 2 then make it as 2 and SAVE it.

   Finally: After completion of the above steps the status will be changed to Green or Red as per changes made.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply