Question Re: Unable to delete request from DSO in Technology Q&A

Unable to delete request from DSO

former_member182470 — Thu, 30 Dec 2010 08:31:14 GMT

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

Re: Unable to delete request from DSO

Former Member — Thu, 30 Dec 2010 08:38:33 GMT

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

rgds, Ghuru

Re: Unable to delete request from DSO

Former Member — Thu, 30 Dec 2010 09:03:33 GMT

check if there is any dump in st22

Re: Unable to delete request from DSO

Former Member — Thu, 30 Dec 2010 09:18:12 GMT

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

Re: Unable to delete request from DSO

Former Member — Thu, 30 Dec 2010 09:23:17 GMT

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

Re: Unable to delete request from DSO

Former Member — Thu, 30 Dec 2010 10:09:29 GMT

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

Re: Unable to delete request from DSO

Former Member — Thu, 30 Dec 2010 10:13:47 GMT

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

Re: Unable to delete request from DSO

former_member182470 — Thu, 30 Dec 2010 10:37:28 GMT

Hi Friend,

I have tried in the same way what u told me , I am able to see my unwanted requests in the list. But the delete option is disabled under Table entry.

So shat should i do?

Regards,

Suman

Re: Unable to delete request from DSO

Former Member — Thu, 30 Dec 2010 10:47:52 GMT

Please check whether you have authorization to do so.

Re: Unable to delete request from DSO

Former Member — Thu, 30 Dec 2010 11:26:28 GMT

Hi Suman,

Looks like you do not have authorizations to delete entry from the table.

check if you have authorization to delete request from that particular DSO.

If it the first time you are facing this issue ? contact Basis and ask them to delete the request from the DSO using the fire fighter id.

Regards

Re: Unable to delete request from DSO

former_member182537 — Sun, 02 Jan 2011 12:08:59 GMT

hi,

in case u want to avoid this PSA character data prolem pls see below link

and for DSO req deletion authorization pls contact your seurity team i guess some roless might be mising from your id in su01d.

hope it helps

thanks

nilesh

Re: Unable to delete request from DSO

Former Member — Mon, 03 Jan 2011 02:57:24 GMT

Hi ,

Looks like an authorization issue .Your system log should point to this issue check sm21 and update.

Selective deletion on period can help to resolve at times with loading downtime again .

Goodday..

Re: Unable to delete request from DSO

Former Member — Mon, 03 Jan 2011 06:55:34 GMT

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

Re: Unable to delete request from DSO

former_member182470 — Wed, 22 Jun 2011 04:48:43 GMT

THANKS

Re: Unable to delete request from DSO

Former Member — Wed, 22 Jun 2011 07:14:17 GMT

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

Re: Unable to delete request from DSO

Former Member — Thu, 27 Jun 2013 06:34:11 GMT

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

Re: Unable to delete request from DSO

harshil_joshi — Fri, 23 Aug 2013 07:41:36 GMT

Hello Prashanth,

If request is still in process(Yellow) then we can not delete right? then what we can do first we have to make red then can do it?

Re: Unable to delete request from DSO

RamanKorrapati — Fri, 23 Aug 2013 07:44:38 GMT

yes, we can make QM status to red and then we can delete it.

Re: Unable to delete request from DSO

Former Member — Mon, 26 Aug 2013 10:24:09 GMT

Hi all,

I am also facing same issue so I performed same as above but it got deleted form table (RSREQICODS) but its is still reflecting in D.S.O. request tab.

Please help me for the same.

Thanks

Praveen.

Re: Unable to delete request from DSO

former_member182470 — Mon, 26 Aug 2013 10:37:55 GMT

It must be lying in other tables like RSICCONT, RSODSACTREQ tables. Please delete from them too..