on 09-11-2014 1:23 PM
Hi Gurus,
As a part of one of my scenario i had created a OHD with type 3rd party tool.Till yesterday it worked fine.Today PC got failed with exception DTP req locked.I understand that earlier DTP req failed and pc triggered the DTP again it causes the issue.Now i would like to know that is there any way to delete the failed req.I'm using IBM Data stage as a target the OHD.
Regards,
Rambabu
You need to delete from OHD using this Program: RSBK_DEL_DTP_REQ_FROM_OHD
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mates,
I already tried all the options mentioned by you from morning onwards.But didn't helped out.
@Nanreshsing: i had followed the note it says to run the report RSBK_DEL_DTP_REQ_FROM_OHD as suggested by Suman too
@Ramanjaneyulu: My first action after getting the error was checking the thread which you mentioned in the reply.
I tried to go to db tables and checked for the req and then changing the status,and to another table etc and then a fm and then a report mentioned above.
After performing all the actions i got the message that no req was deleted from the OHD from the above report.
Regards,
Rambabu
Hi,
Issue resolved by myself.Moreover the the same steps as mentioned by Guys but the order of execution matters.
step1: Table RSBREQUID3RD->then make the status of the req to G.
Stpe2: Then to RSBKREQUEST-> then make the Ustate & Tstate of the req to 2
Step3: then to se38->RSBK_DEL_DTP_REQ_FROM_OHD->Mention the OHD and req then deleted.
Regards,
Rambabu
Hi,
You two options here.
1. You may need to delete the failed request.
2: You may need to change status of your previous load to green or successful.You can do this thru using
Function module - RSBM_GUI_CHANGE_USTATE
About request, you can try to check table RSBKREQUEST and see the which is related to your dtp.
from dtp monitor you can find request number.
There is one post which have similar kind.
please search on Google by using search term "Open Hub - 3rd Party -- Delete Requests".
Hope it helps.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
can table RSBKREQEST be of any help please check
do you know the request Id.
i think you need to clear the table entries at open hub and reload the data again.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thota,
SAP Note 1328418 might help you.
Please also refer to the document below:
Regards,
Ashvin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.