on 11-12-2013 2:31 PM
Hi Dear Experience,
I have a 950 messages in the message monitoring about the XML responsible for update the system legacy using adapter JDBC , the direction Receiver.
But I don´t know how to reprocessing this messages with status "To Be Delivered" and Engine = Adapter Engine.
I´m using the button resend , but the number messages don´t change in message monitoring.
The version in PI its 7.0.
I found the report RSXMB_RESTART_MESSAGES , but when I fill the information about the interface in the selection screen and execute(F8) this program show the message: No XML messages exist for this selection.
In the SXMB_MONI , all the XML´s it´s processed sucessfully.
The last friday ,there was a lock adapter in JDBC in System Operational. The messages that have accumulated in the PI since then.
In this case , What I do for reprocessing this messages ?
Best Regards,
Diego
Hi Friends,
The problem was resolved after restart the instance Java from server PI.
All the messages with status To Be Delivered was processed sucessfully.
Thanks for all for the Help !!!
Regards,
Diego
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Friends,
My scenario its RFC to JDBC.
All interfaces its assincronous.
I talk to team basis and the answer is: Its impossible reprocessing this message.
It´s true this affirmative ?
I don´t believe that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
were you able to resend those messages??
if not -
you can even try checking it from
http://host:port/mdt/Systatus -> additional data -> messaging details ->
can you share the screenshot and also the message audit log if possible?
Hi,
Follow below procedure
http://host:port/mdt/Systatus -> additional data -> messaging details ->Messages in EOIO Sequences
you need to cancel or restart the message ID with sequential number 1 to release other messages(2 and 3) in the queue.
Hi Diego,
We cannot resend To Be Delivered messages, your basis team was right here.
Do you see the message count decreasing?
The table query in the message might be taking long time to execute on your database end.
If this is recurring issue, ask basis team to increase thread count of your JDBC adapter to 30 (this requires a system restart).
As a long term solution check the execution time of your query in table, and also check connectivity ping test to database. It might in different geographic location due to which there might be some security protocols which might be taking time for end to end process.
Regards,
Pranav
Hi Diego,
The report RSXMB_RESTART_MESSAGES is not applicable to restart messages in adapter engine.
You may need to look for the error message which is probably causing the rest of the messages to hold/waiting/to be delivered status in your AFW in RWB.
Please go through the Stefan Blog which will be useful in your scenario:
Also refer to the below blog under Errors in AE to restart your error msg:
Thanks,
Prasanthi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Diego,
Check the details of the messages. Perhaps there is an error in 1 of the messages holding up others.
Also, is the receiving database available? Connection parameters are still OK?
SXMB_MONI is on the integration engine side and indeed, all messages are processed successfully there. Your problem resides on the adapter engine side.
Kind regards
Dimitri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dimitri,
Thanks for the help.
The database it´s OK.
What happen its , the 950 last messages about day 11.11.2013 it´s are stuck .
In transaction SMQ1 and SMQ2 don´t show any registers from ECC and PI.
The parameters from communication channel it´s OK. The messages it´s ok in the moment.
I need reprocessing the messages with status = To Be Delivered in the Message Monitoring. The PI don´t reprocessing automatically that I know.
Regards,
Diego
As the messages are in adapter engine, you wont be able to find any errors in SMQ1/SMQ2.
Go to runtime workbench->message monitoring->adapter engine->database->
update the filters with valid details such as
date & time ; in the past one week/one month
message status : to be delivered
provide sender & reciever interface details.
it'll display all the messages in to be delivered status..
You have an option to select all and resend them at once.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.