Issues after Deleting master data

[Former Member]

Dear Experts

I have an infoobject with master data never used in any transaction data.

Initially, I used  other BI Abap program to delete the master data , I can still reload master data.

Now, after using Function module : RSDMD_DEL_MASTER_DATA, an error occurred during loading of DTP (full load) :

The error message in the DTP monitor is :

When processing the request at stage :

Updating attributes for InfoObject ZXXXXX : 1092 -> 1092 Data Records

  --- [red indicator] Master data deleted in background.

When I use RSD1 and click the 'maintain' button, it shows a message :

"

Deletion process for master data of ZXXXXXXX was

already started. Start again to query the status.

"

But there is no process running in SM50.

I even adjusted the S and Q tables for this infoobject using se14 to delete the data.

The errror persists.

Please kindly advise what is causing the message that deletion process is started when there is no such process visible.

regards

Pascal

[Former Member]

you need to delete the entry of your infoobejct on table RSDCHABASDEL.

this entry is populated when the data deletion is taking place to avoid any further modification by other processes on the same infoobject (works like locking the infoobject).

for some reason your program didnt delete the entry on table RSDCHABASDEL even after the data deletion had completed. My guess is because RSDCHABASDEL was locked by other process while your program was trying to remove the entry on table (to free the infoobject).

[former_member186445]

i'm looking at the different posts of you concerning this topic and i'm wondering...why don't you just delete the infoobject and then recreate from scratch? all the problems are then solved...

M.

[Former Member]

Dear Tibollo

Its seems like the master data is now scrxwed.

I ran via RSD1 "repair infoobject" which found nothing wrong with the infoobject.

I checked the runtime and database objects were ok using database utility.

I deleted data and adjusted the database also.

I reactivated the infoobject also.

There is no error found. But still unable to display the master data now , having the message.

I am unable to know the root cause and what SAP is trying to say.

Yes, its seems like I have no choice but to delete the infoobject and re-create.

Last but not least, kindly advise should the SID be deleted also if the master data is not used in any transaction data and basically no text loaded.

Using BI 7.0 context menu for infoobject, there is a feature to delete the master data.

What is the program so that I can schedule a regular job for this ? How to disable checking for where-used list?

I traced but found nothing.

Thanks you tremendously.

Pascal

[former_member223480]

Hi Pascal

Check if you have any lock entry in sm12.

Thank you

Yiannis

[former_member186445]

if the master data is not used in infoproviders, you can delete the sid's. else this will lead to problems with star schema of the cube.

i think in one of your previous posts you received a link to a blog that explains how to delete master data.

but again i think you're to far past the point of repair... if possible, just delete the infoobject, and then recreate the same.

M.

[Former Member]

Thanks to Tibollo and Yiannis

I have checked there is no locked entries.

Yup, its a gonner. 

Thanks to all.

regards

Pascal