Orphaned records in SXMSPMAST

[former_member216506]

Dear colleagues

In SE16 in SXMSPMAST table  I found records with old dates with values in ITFACTION field ARCH, DEL.

Could you please help me resolve this issue? How to check the consistency of the queue?

Thanks a lot,

Alexander

,

[ravicarpenter]

Hi Alexander,

Could you please elaborate your question ? You might have already done this but could you please check the report RSXMB_SHOW_STATUS report in SE38 which will give you a bifurcation of status wise messages ? Probably the ITFACTION has status ARCH/DEL, however the messages might not have a final status due to various reasons (queue failed/deleted etc.)

Maybe you can use RSXMB_CANCEL_MESSAGES to set those messages to final state if you want the relevant ARCH/DEL action to be carried out

[former_member216506]

Dear Ravi,

I tried to use RSXMB_CANCEL_MESSAGES but received message

[vadimklimov]

Hi Alexander,

Messages having value ARCH in field ITFACTION of a table SXMSPMAST are subject for archiving, those having value DEL in that field are subject for deletion. Please check following:

• Retention periods for archiving and deletion of messages in Integration Engine - transaction SXMB_ITFACTION. If retention period is too high, messages will remain in database for long time even if corresponding housekeeping jobs (see next point) are executed regularly;
• If archiving and deletion jobs are scheduled and periodically successfully executed - transaction SXMS_MONI_JOB. If they are not executed or are failing, messages will be kept in database forever (even if their retention period has already expired). You may schedule them using transactions SXMS_ADMI_ARCH (for messages archiving job) and SXMS_ADMI_DEL (for messages deletion job). Please note that both jobs are client specific.

All transactions mentioned above can also be accessed from transaction SXMB_ADMIN.

In order to get brief outlook at overall statistics of persisted messages in Integration Engine and figure out how many of them can already be archived/deleted (based on their status and configured retention periods), you may want to execute an ABAP program RSXMB_SHOW_REORG_STATUS.

Please have a look at SAP Note 872388, it contains a lot of useful and detailed information regarding housekeeping in PI systems.

Regards,

Vadim