RSXMB_DELETE_MESSAGES failed

[Former Member]

I tried to delete away messages from the persistence layer. However, each time when i tried to run the job, it fails immediately and came up with the error "Complete unfinished copy job first" and i went to Job Overview (in SXMB_ADMIN) and click on "rerun copy job" but it seems to be taking forever to complete. It has been running for 70k+ seconds (i.e. >12 hrs).

Could someone advise if this is normal? Did i miss out something or didn't do anything?

[Former Member]

Hi,

In this case you should try to manually confirm the messages (in SXMB_MONI - Cancel Processing of messages with Error CTRL F8) and then run all the deletion jobs again. Sometimes this helps - but I also have several messages that wouldn't disappear after that treatment.

You have to cancel them first, either manually or via a report. Please see Note 872388 and 820149 for details.

Thanks

Swarup