Skip to Content

Unable to delete request from DSO

Hi,

Our process chain got failed today showing an errors of invalid charcters. I maintained in RSKC transactio for those invalid charcters. But still my request in DSO is in red status only. When I try to delete from DSO, I could not delete the request. I am able to delete from PSA and reload agin. But iam unable to delete from DSO. I really don't understand the reason behind this........

Can anyone help me...........?

Suman

Add a comment
10|10000 characters needed characters exceeded

Related questions

14 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 22, 2011 at 07:14 AM

    You can delete your bad request as follows

    1. Make your request red marked

    2. Then go to DTP--> click on monitor

    3. Select appropriat date (In your case selct today date)

    4. There you will find Delete sign at top righ hand side. Use taht to delete your request.

    Regards,

    Sushant

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 30, 2010 at 09:23 AM

    Hi,

    Goto Se11 -- enter table "RSICCONT" Monitor: Saving of the updated IC and ODS per request.

    Enter DSO name in infocube name.

    execute

    it will display the requests present in the DSO. -->select the request and from the menu "table entry" -->select delete(SHFT+F2).

    the request will be deleted from the DSO.

    Regards

    KP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2010 at 10:09 AM

    Hi Suman,

    Goto Se11 trans > ENter the table name RSBKREQUEST > Goto Contents >Under TGT enter your DSO(DataTarget name) > Execute--> You will be able to see the requests under that particular DataTarget

    In the column USTATE > Check if the number is 3, then it is the request processed with Errors(If its 2 Processed Successful) > Select that particular request & delete it.

    Hope it helps!

    Regards,

    Pavan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2010 at 09:18 AM

    Please check whether you have authorization to delete the request. Check in su53 transaction for the same.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2010 at 10:13 AM

    You need not to delete the request in red in DSO. Once you finish the changes of your data in PSA or by allowing sp characters in RSKC, just repeat that process (via context menu --> select Repair if it is DSO). In BI 7.0, you need to to delete bad request from any target. Selecting Repair will re-trigger the instance that was failed due to any reason. For your confirmation, note down the red request number and after repairing, you see the same request number.

    Hope this will help you.

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

    • Abhijit Gaikwad

      I raised this post to address my issue. How can you say that some others in future who looks at this thread may come to a different conclusion. If they take it in a different way, What I can do? It's their problem. To avoid all such confusions, I made the blog. Have you gone through it?

      I don't think anybody will take this decision to delete entries without consulting their BW team. No such irresponsible guys will be there.

      Regards,

      Suman

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2011 at 06:55 AM

    Hi Suman,

    Go to Table RSREQICODS,Click on diapaly (F7) -> Contents > Execute there you can Select your request number in the Menu Bar delete the entry.When you delete the entry from table automaticcally request will delete from DSO.

    Hope its help you

    Regards,

    Jayapal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2013 at 06:11 AM

    Hi,suman ,

    Please to check the background job for this request,many be the bg jod is blocked and can't stop and finished,

    Best,

    Leno

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Suman,

      I know you solved this problem long ago but here I am explaining error which I am facing for the same.

      Please consider it.

      I received a MESSAGE_TYPE_X error while activating DSO.

      As per SAP Note Number: 671562 I have to delete unwanted requests. I found one of my request no. 52835.

      Steps followed by me:

      DSO --> Right Click --> Manage that request.

      I have also delete this request from the provided tables by you all in this thread.

      But still that request is available in DSO --> Manage and facing same MESSAGE_TYPE_X error.

      Please help to solve this error.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2010 at 08:38 AM

    What is the error you are getting while you are trying to delete the rquest from DSO..??

    rgds, Ghuru

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 22, 2011 at 04:48 AM

    THANKS

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 27, 2013 at 06:34 AM

    Hello Suman,

    Please don't follow the above comments which guide you to delete entries from table, even you have the authorization, Since I did the same way before, but it make a very serious data inconsistency.

    Later i asked our Basis team, after investigation from them, our system support pacakge needs to be upgrade to 10 in SAP BW 7.3.

    Then the issue solved,

    Therefore, i strongly suggest you to reach the Basis team.

    Best Regards!

    Lee

    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.