Skip to Content
author's profile photo Former Member
Former Member

Open Hub - 3rd Party -- Delete Requests

Hello,

I am working on a project to get data out of SAP BW via 3rd party open hub destination. Where do I go to delete failed/pending requests?

When setting up the OHD initially, we didn't have the program id registered properly on our server. Using SQL Server SSIS, I was able to connect to the SAP system and start the OHD process chain. The DTP started processing data but was unable to send it back across to the SSIS instance due to the program registration issue. After awhile the SSIS connection timed out and left the request orphaned.

Later, after the program was registered properly and I was able to get data out of a different source table/OHD destination, I attempted to retry the first OHD from above. The job immediately failed telling me that the previous request was still running and locked. I was unable to set either of the requests to red/green and retry. I also tried to delete the OHD source but the locked request won't allow that either. Now any DTP that is attached to the DataStore fails as well.

Thanks in advance for anything that could help.

JW

Edited by: J W on Jan 8, 2010 7:58 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Oct 20, 2014 at 03:56 PM

    1) Double click on the DTP

    2) Click on "Last Request"

    3) Click on "Where-used List"

    4) Delete the failed (RED) Request.

    Now re-run your job and it shold work without any issues.

    Thanks,

    Sundeep Chalasani

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 12, 2011 at 07:42 PM

    Looks like this message was from quite a while back and I never saw a response. Don't know if you can remember back that far but did you ever get this resolved? I am running into almost the exact same issue.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2011 at 08:36 AM

    Hello,

    Can't you see your running request using the DTP monitor (after double clicking on dtp)?

    Otherwise check out in SM37 if any job BIDTPR_* is running and cancel it.

    I hope this helps

    Rgds,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.