How to clear a hung message from the SFM queue?
There is a message ID that is hung in the SFM/XNP_MSG queue. If we start the SFM event manager service then rest of the messages in the queue are going through and new messages getting picked up a for while. Then the same hung message is holding up the queue.
The hung message is in Ready Status in XNP_MSG table and also present xnp.xnp_in_evt_qtab
This is impacting our production environment. Any idea how to move the message out the queue so that rest of the transactions go through without any delay.