Messages are in to be delivered state and slows down the message processing

[Former Member]

Hello,

Messages are in to be delivered state and slows down the message processing.

this happenens in case of DB2 on some machine where the issue about high load on DB2 is caused by standard programming in SAP XI that executes a statement, where it uses the condition 'where 1<0' prio to the original SQL statement configured in the channel configuration,

Can you please help me out in solving this issue?

Thanks,

Soorya

[GabrielSagaya]

Status: TO_BE_DELIVERED

Which means that the message was successfully delivered from Integration Server point of view and it states that the messages is initially handed over to the Messaging System.

TO_BE_DELIVERED occurs while the message is put into the Messaging System receive queue.

Solution:

This is done via the Messaging System receive servlet:

http://<Host>:<PORT>/MessagingSystem/receive/<CONNECTION>;

/<PROTOCOL>

Only if this was executed successfully the Messaging System returns HTTP 200 to the Integration Server and the Status TO_BE_DELIVERED moves to DELIVERING

1. Try logging into Sap GUI with two users: XIAPPLUSER & XIAFUSER

to see if they are blocked

2. We can check the messages:

AdapterFramework

com.sap.aii.adapterframework.serviceuser.language

com.sap.aii.adapterframework.serviceuser.name = XIAFUSER

com.sap.aii.adapterframework.serviceuser.pwd

ApplicationSystem

com.sap.aii.applicationsystem.serviceuser.language

com.sap.aii.applicationsystem.serviceuser.name = XIAPPLUSER

com.sap.aii.applicationsystem.serviceuser.pwd

in the exchange profile to make sure the right passwords

[GabrielSagaya]

Message to be deliver means that the message is sitting in the queue waiting to be processed.

In most situations, when this happens and stays there for a long time is because 1st message is the queue is being held up by an error.

What you can do is in SXI_MONITOR, scroll to the left until you see the queue name. Double-click on the queue name, which will take you to the queue where the message resides. You should see the number of messages in the queue and the status of the 1st message. You can restart the error'd message or delete it

/people/sap.user72/blog/2005/11/29/xi-how-to-re-process-failed-xi-messages-automatically