Error while deleting a request

[Former Member]

Hi All,

When trying to delete a request from a master data object an error appears which says:

Cannot delete request DTPR_* of table RSN* for deletion.

Please let me know what needs to be done here so that request is deleted.

This is urgently required..thanks..

[Former Member]

Hi All,

I found a link to this note

The request is deleted now.

Thank you all for your help.

[Former Member]

Hi,

The request is still loading the data.Its in In Process(Yellow).

I have checked and there is no background job running.

Could you please tell me how to make the process red?

[Former Member]

try this function module RSS2_SET_QMACTION to set the status red/green however you gotta be on SP-14

Hope it Helps

Chetan

@CP..

[Former Member]

Hi Chetan,

Thanks for your answer.

But we are not trying to delete a master data object.

We are trying to delete a data load request on the master data object.

The data load request is in process from a long time, so we are trying to delete that.

And then it is giving the error message

Cannot lock request *** of table ** for deletion.

Could you please help?

[Former Member]

Hi,

That's probably because the data load is still going on and locking the table. Check if the job or process is still active, or if some other activity is going on for that object.

Also have basis check if there is any process that's locking the object even though the job is finished.

Cheers,

Kedar

[Former Member]

Hi Sir,

Is the request still loading data? If it is in yellow status, mark it red and try deleting it. Also make sure the Background job has been stopped.

Let us know if you still cant fix the issue.

Arun

Assign pts if useful.

[Former Member]

Hi,

Check in SM12 if your object is being locked by any process...

(then you can decide if you want to delete locks if any on your object)

Rgrds,

Habeeb

[Former Member]

The error message is :

Cannot lock request DTPR* of table RSN* for deletion.

[Former Member]

For deleting any master data

Need to delete first where its referenced to ,so check the where used list for the infoobject and delete the places where that master data is referenced

Typically - Attributes,Hierarchies,Texts,Transaction data,in Query - Hardcoded master data

Lots of ways around ,even using database utility ;however that leads to inconsistencies and requires sounds knowledge so wont advocate those steps.

You can follow below steps -

R-Click Delete master data ,it wont delete all if its referenced,so now go to

Tcode - SLG1

Object = RSDMD

Subobject = MD_DEL

Hit execute button

it will fetch you the log showing all the places(references) where you need to delete the data in order to delete the actual master data.

After deleting the data from referenced places you can completely delete the master data.

Hope it Helps

Chetan

@CP..