cancel
Showing results for 
Search instead for 
Did you mean: 

Urgent problem: Cannot delete master data of infoobject

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi ,

Just check out the thread:

[Delete master data of infoobject|]

Hope this helps!!

Reward if useful

Manish

Former Member
0 Kudos

Delete locks from tcode - SM12 and also check if there is any attribute change run scheduled in parallel.

Hope it Helps

Chetan

@CP..

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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..

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi all,

we had to delete another lock entry from table RSDCHABASDEL.

Problem solved.

P.

Former Member
0 Kudos

Thanks for the update