on 12-27-2010 7:38 PM
Hello all,
I d like to know how can I CANCEL or RESEND messages with status error SYSTEM ERROR in adapter framework.
Messages failed because of receiver system un-availability. Now, we have more than 50.000 messages stuck, waiting for being resent or cancelled.
But from the Message Monitoring Tool at Runtime Workbench Monitoring, I can only process up to 200 messages each time.
So, its practically imposible to do it manually.
My question is how can I deal with that amount of messages? Is there a way to process them in bulk and get them cancelled in only one step/action?
Many Thanks in advance.
Thanks for all your support.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
IN RWB you have the option to filter based on the message status & the date selection.
in addition to that you have the max number 10,000 said in previous post.
Make sure if you have canceled it is not possible to resend the message again.
check activate the queue in SXMB_ADM, check the message status, short dump, user lock.
Edited by: Prabhu Rajesh Janardanan on Dec 28, 2010 3:25 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In the Adapter engine message monitoring, adjacent to Resend and cancel buttons, you have "multiple selection on" button too.
Once you click on it, check box functionality would be switched on and you would have an option to select multiple messages.
Select all the messages requires and you can resend / cancel them in bulk.
Thank you.
Regards,
Subbu
Jorge Thanks for your help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, I hope you are doing fine!!
The most common way to cancel these messages is through the Runtime Workbench as you have mentioned youu2019ve tried.
Just one note: Once you are on the Message Monitoring screen -> Filter (where you can select the dates, message status, etcu2026), there is a Dropdown box menu at center of the screen called u201Cmaximum Numberu201D where I believe you said you can only see 200 messages.
You may try to select u201C10.000u201D there and then cancel these messages from there.
However, if you prefer doing this in one go, you can do this by changing the status of the messages from u201Cerroru201D to status u201Cdeliveredu201D by executing following SQL statement at the database level:
UPDATE <DB Schema>.XI_AF_MSG SET STATUS='DLVD' WHERE MSG_ID='<MSG ID>
AND DIRECTION='<INBOUND OUTBOUND>'
Cheers,
Jorge Eidelwein
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.