on 06-05-2008 1:40 PM
Hi all,
I'd like to aks you for help with deleting of infoobject master data.
I have infoprovider created from an infoobject and filled with some data.
Now I need to delete the master data from this infoprovider.
But when I choose delete action from context menu (in RSA1) I get warning with message:
Last Deletion of Master Data Terminated
The last deletion process for this characteristic did not finish successfully.
Then I have two options how to delete master data: Restart of Continue in previous deletion, but both ends with the same error message:
Lock NOT set for: Deleting transaction data selectively
Message no. RSENQ002
Previously I used this process many times, but now it doesn't work. I tried to follow oss note RSMASD and delete entry for my infoprovider, but after another delete the entry is created again.
It seems there is some another lock from previous master data deletions, but I don't know how to remove it. Also I checked that no jobs are running. When I try to load data into infoprovider I get error message Master data deleted in background.
I would appreciate any help with this issue, it's quite urgent.
Many thanks,
Pavel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Delete locks from tcode - SM12 and also check if there is any attribute change run scheduled in parallel.
Hope it Helps
Chetan
@CP..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check is there any Lock in SM12 or in RS12 whether u can multiple entries on ur Master data...
And also check is there any deletion job is running in Sm37..
If the deletion job is running or any load is happening to this MD then u need to wait for this to finish or cancel the same as u dont want that MD..
And then proceed with ur activities.... Or u can cancel that process and check if the lock is released in SM12.. if not try to delete that lock and then proceed with ur steps..
U can even try SE14 to delete ur Master data based on different tables level...
thanks
hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Murali, Chetan,
thanks for your advices.
I already checked locks in SM12/RS12 but there are no entries for my object.
Only one "lock" that I found is entry in the table RSMASD. But deletion of the entry doesn't solve the problem.
Regarding background jobs, I found only few canceled jobs with the same error message as I get while master data are being deleted (Lock NOT set ...). There are no active jobs unfortunately.
I also checked attribute/change run settings and there are two change runs ready to be executed, but not related to my infoobject.
Main problem is that I need to load data into the infoprovider and I can't because of mentioned error (Master data deleted in background). So there has to be some another lock or running process that I'm not able to localize.
Many thanks,
Pavel
can you paste all the details of the error here for investigation..
Also can you run this manually for the object its giving error or you think is causing problems
"RSDMD_DEL_BACKGROUND", run this program in back ground with the input parameters as mentioned below.
P_IOBJNM - Infoobject name.
P_CHABNM - Infoobject name.
P_DELSID - X
P_DELTXT - X
P_OBJ - RSDMD
P_SUB - MD_DEL
P_EXT - MDDEL_Infoobject name_BG
You can verify in system log, which records got dleted and which are not deleted.
Hope it Helps
Chetan
@CP..
Hi Chetan,
thanks for your help.
I executed program RSDMD_DEL_BACKGROUND with specified parameters and it ends with success. I can see how many entries have been removed or not.
Nevertheless the main problem still remains, I'm not able to load data into the infoprovider because of running master data deletion.
Unfortunately I've found only these error messages:
Error during master data load:
Master data deleted in background
Message no. RSDMD114
Job log from manual master data deletion:
Job started
Step 001 started (program RSDMDD_DELETE_KERNEL, variant &0000000000003, user ID PC02CZPL)
Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIMDCK_4A1S5WPILSAAWLB87C0U6WUUF with ID 11390100
Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIMDCK_4A1S5WPILSAAWLB87C0U6WUUF with ID 11390101
Lock NOT set for: Deleting transaction data selectively
Job cancelled after system exception ERROR_MESSAGE
Unfortunately there is no short dump or detail information is system log. I also tried to trace delete and load processes, but I haven't found any error in logs (for lock operations).
Do you have any other ideas where the problem could be or where could I obtain more information about the errors?
Many thanks,
Pavel
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.