cancel
Showing results for 
Search instead for 
Did you mean: 

Reprocessing message status to be delivered - Adapter JDBC Receiver

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

former_member184720
Active Contributor
0 Kudos

you opted universal solution good to know that

Former Member
0 Kudos

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.

former_member184720
Active Contributor
0 Kudos

you can definetly process the messages which are in to be delivered status..

did you try the above mentioned process?

Former Member
0 Kudos

Hi Hareesh,

I analyzed the problem via message monitoring.

Regards,

Diego

former_member184720
Active Contributor
0 Kudos

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?

Former Member
0 Kudos

Hi Hareesh,

Below follow the prints about the subject required.

Thanks for the attention.

Best Regards,

Diego

Former Member
0 Kudos

Hi Diego,

Is there are any messages stuck in holding also?

and please confirm QOS (EO or EOIO).

If these messages belong to EOIO, u need to first cancel or restart the message based on sequential ID.

Regards,

Mastan

Former Member
0 Kudos

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.

former_member184720
Active Contributor
0 Kudos

i dont think they are EOIO. if that is the case messages should be in holding status i believe.

What about new messages? i mean are the fresh messages getting processed by PI to Database?

what is the channel state when you are resending these messages?

Former Member
0 Kudos

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

prasanthi_chavala
Active Contributor
0 Kudos

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:

http://scn.sap.com/people/stefan.grube/blog/2006/04/27/how-to-deal-with-stuck-eoio-messages-in-the-x...

Also refer to the below blog under Errors in AE to restart your error msg:

http://scn.sap.com/people/community.user/blog/2005/11/29/xi-how-to-re-process-failed-xi-messages-aut...

Thanks,

Prasanthi

Dimitri
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member184720
Active Contributor
0 Kudos

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.

agasthuri_doss
Active Contributor
0 Kudos

Hi Diego,

Can you check the OSS note 937159, might help..

Cheers

Agasthuri