Skip to Content

Orphaned records in SXMSPMAST

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

,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 28, 2015 at 12:57 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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