Delete XML from SXMSPMAST

[dhagigeorgiou]

Hello everyone,

I have the set the relevant background jobs for deletion which are running reguralrly.

I have set retention periods of 1 day and 7 days for hist.

Messages in SXMSPHIST are being deleted via background jobs.

But table SXMSPMAST is not being cleared. The number of entries are the same for over a weeek now (XI has been inactive for over 20 days, we are preparing for go live on the same system that developement was carried out).

I am also running in background the RSXMB_REFRESH_ADAPTER_STATUS everyday.

Any ideas ?

Thanks

Dimitris

[Former Member · Accepted solution]

Hi,

Do you have messages in error on your system (async) and did you checked for message in Schedule/Recorded status???

Because such messages can't be deleted by Jobs.

Please update then may be we can help.

Regards,

Gourav

[dhagigeorgiou · Accepted solution]

Hi Gourav,

No i do not have such messages.

They are all in messages status 003 and adapter status 001, 006, 007, 008.

Thanks,

Dimitris

[Former Member · Accepted solution]

It is strange!!

Can you do following:

- Transaction SE16 select any entry and copy message Id.

- Transaction SXI_MONITOR try to search message for given message id.

Check status of given message, if it is not successful then ( no checkered flag) then kindly update..

Regards,

Gourav

[dhagigeorgiou · Accepted solution]

Hi,

I get one message with a checkered flag in the status field

BUT with a green flag in outbound status column.

The message is then delivered to a BPM whose stauts is in Transfer to Process Engine.

I am afraid it has to do with a deletion of a queue.

Any ideas?

Dimitris

[Former Member · Accepted solution]

Here we are....

Yes.. this the cause message is only successful in integration engine but waiting/recorded in Business Process Engine.

Check inside SXMB_MONI_BPE with all dates... and try to process them... if unable to process then tell me (check design etc).

Normally you should not have any successful message in SXMB_MONI if your jobs are running fine. but if message is not complete for any reason then it will persist for later processing.

You can also check it in RWB->message monitoring and search for "Adapter Engine" messages.

regards,

Gourav

---

<i>Reward points if it helps</i>

[dhagigeorgiou · Accepted solution]

I cannot find anything in SXMB_MONI_BPE or in RWB since the begining of time.

I must tell you that i have been on a deleting spree using XI standard reports always never deleteing directly in db tables.

Thanks for you help.

Dimitris

[yiahwee_thyng]

Hi, i hv successfully performed a round of archival however i found that the entries hv not been deleted from SXMSPMAST. May I know what is missing? Thanks.

[yiahwee_thyng]

In addition, job SAP_BC_XMB_DELETE has been running however somehow it is not picking these archived records for deletion. (This archived records have ITFACTION = 'ARCH' and REORG = 'DEL'.)

[dhagigeorgiou]

It seems that our problem was that the archiving procedure was not working properly.

Once tahat was ok the backgroun delete job

worked like a charm.

Thank you all for your input.

DH