How to delete message queue in "Hold" status.

[former_member230666]

Hi Experts,

May i know how to delete the message with "HOLD" status in the message queue of the DAE. I've checked in the message monitor, there is no error messages but all the messages of the same interface were stuck in the "Scheduled" queue. I tried to cancel the messages but were not able to and i also can tried to resend those messages in the scheduled queue. I ran out of idea on where to check. Can you please help me? Thanks in advance.

Regards,

Shawn

[Former Member]

Dear Swan,

When messages are in hold or schedule in SXI_MONITOR.

1. First check any error messages in SXI_MONITOR of that Queue. 

2. Process that error message and check whether the queue is in ready state.

3. If the queue in ready state , unlock queue.

4. If the message still in running state , kindly delete that message and process other messages.

5. Re-start the deleted message after processing all messages of that queue.

Regards,

Karunakar

[udo_martens]

Hi Shawn,

I guess it is the modus (or qos) EOIO, that means processing only in sequence. You need to reprocess the stopping message or cancel it. Then the queue will be released. EOIO is always tricky, should be only used if urgently required.

/Udo

[Snavi]

Hi Shawn,

you need to cancel the ERROR messages stuck in the queue before you delete or re-process the messages in HOLD status.

nwa -> monitoring -> message monitor -> database. select your adapter engine and filter based on your interface