archive/delete table SXMSPMAST with MSGSTATE = 1 or 23

[Former Member]

Hi experts,

In table SXMSPMAST how to change the Message Status(MSGSTATE) 1 & 23 to 3?

Because Archive/delete job is not cleaning messages from table SXMSPMAST with Message Status(MSGSTATE) = 1 & 23.

I already tried using RSWF_XI_UNUSED_MSGS.

Regards

[KennethEriksen]

Hi,

Here are a few tips on how to delete messages, and also enable messages for deletion which are not in final state.

To release messages in unarchivable statuses: http://host:port/MessagingSystem/archiving/reorgdb.jsp

Schedule following reports weekly (depending on your error handling and reporting procedures for your system this might not be possible in your production system):

RSXMB_CANCEL_MESSAGES

RSXMB_CANCEL_NO_COMMIT_MSG

RSXMB_CANCEL_NOT_REST_MESSAGES

RSXMB_CHECK_ITFACTION

RSWF_XI_INSTANCES_DELETE

SXMS_REFRESH_ADAPTER_STATUS

In addition you have the following reports dealing with enabling messages for archiving deletion

u2022 RSWI_REGENERATE_WI2OBJ (uncheck u201CDisplay modeu201D and set for relevant dates)

u2022 SXMS_REFRESH_ADAPTER_STATUS - Success: all msg with adapter status 001 changed to 006 (archivable)

u2022 RSWF_XI_UNUSED_MSGS (recommended not to run in production to avoid loosing data)

RSXMB_SHOW_REORG_STATUS shows number of messages scheduled for archiving/deletion

RSXMB_SHOW_STATUS shows number of messages per message status, and adapter status for messages with message status = 003 (Processed successfully)

RSXMB_CHECK_MSG_QUEUE fixes inconsistencies by changing the message statuses 001, 009, 012 and 016 to 014/021.

Hope this helps!

Br,

Kenneth