problem with message deletion

[Former Member]

Hi Gurus,

I have a some doubts about messages deletion in XI.

Recently we executed the jobs SAP_BC_XMB_DELETE_001,

SAP_BC_XMB_HIST_DELETE_001 for deleting the messages with a retention period of 180 days( ie 6 months) and the jobs were successfully finished.

Now the problem is we can able to see all the 6 months before messages ( it means from before FEB ) in RWB as well as in sxi_monitor.

one more thing our database team confrim that around 25 GB

data was cleared due to this activity ( That means we have 25 GB of free space in our database)

So please clarify my doubt!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Former Member]

Hi ram,

only messages are deleted that are marked as deleteable.

So if you customized your setting for e.g. 3 month ago, all messages that are older than 3 month will nocht be deleted, because they are not marked as deleteable.

To delete the, you have to update the database-table and set the flag "deleteable"

Regards Mario

[Former Member]

Hi Mario,

Thanks for your reply.

Which database table we need to check out,colud you please tell me the table name and also tell the procedure( step by step) how to check it out.

Regards,

Pavan

[former_member181962]

Check this guide..

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/402fae48-0601-0010-3088-85c...