on 07-30-2008 4:27 PM
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The error message is :
Cannot lock request DTPR* of table RSN* for deletion.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.