XML Messages in "Scheduled" status

[Former Member]

Hi all,

The case is at ERP side running transaction SXMB_MONI, some XML messages from XI to ERP are found in "Scheduled" status. Around the same time, siimilar messages using same receiver interface are processed successfully. When we manual restart the "Scheduled" message, there will be an entry in READY status at inbound queue and we have to unlock the queue. After that, the message will be processed successfully.

Here are my questions:

(1) Why some messages in "Scheduled" status but similar messages are processed successfully?

(2) Is there any alert or notification mechanism that we can setup instead of running transaction SXMB_MONI manually?

(3) Is manual restart XML message a proper way to handle those scheduled message? Any way to automatically handle this message in ERP side?

Thanks in advance.

[prateek · Accepted solution]

1) This may be due to high loads of messages.

2) The message in this case are not stuck in sxmb_moni. They are actually stuck in queues which could be seen in smq1 and smq2. The only way to raise alert for messages stuck in queue is to setup CCMS. You may find the related documents on SDN.

3) You may compare your restart configuration here

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

Regards,

Prateek

[Former Member · Accepted solution]

Thanks all for your valuabe feedback.

I read the blog about how to re-process failed XML message, it mentioned in SXMB_ADM "To be able to initiate processing of messages stuck in the queue, make sure to set following IS configuration parameter: MONITOR QRFC_RESTART_ALLOWED to value 1". May I know after setup this parameter, what can be done to restart the stuck message?

[Former Member · Accepted solution]

Hi,

after doing the above configuration in SXMB_ADM, then if you go to SMQ2 and see some entries stuck in queue, then you can manually restart the queue entries by selecting them and clicking on execute button........then your these stuck queue entries will be processed.

Regards,

Rajeev Gupta

[Former Member · Accepted solution]

Thank you all once again. Before I close this post, I would like to summarize:

(1) Why some messages in "Scheduled" status but similar messages are processed successfully?

After study OSS note 527481 and run SMQR (Goto -> QRFC resource), it show that the resource status is "Not OK". Therefore, the possible cause is resource shortage. We will add more WP to qRFC.

(2) Is there any alert or notification mechanism that we can setup instead of running transaction SXMB_MONI manually?

Will schedule a program to check table TRFCQIN if messages waiting for long time (e.g. an hour)

(3) Is manual restart XML message a proper way to handle those scheduled message? Any way to automatically handle this message in ERP side?

Actually, SAP will restart to process the scheduled message after clean up the message which causing the queue stuck and unlock/activate the qRFC queue.

[Former Member · Accepted solution]

hi

from the problem description it looks like the messages go to different queues and some of these queues maybe busy or in error. To find out see which queue the "schedulled" message is using from SXMB_MONI and double click on the queue name to see all the entries queued inside that queue. Then you can click on the first pending item to see if it has any error. When required, you may need to re-activate the queue after fixing the problem.

[Former Member]

Donald,

Here are the answers to ur questions.

(1) Why some messages in "Scheduled" status but similar messages are processed successfully?

Some times the queues get stuck for various reasons. one msg will cause bottleneck for all other msgs behind it. there is no proper reason why this happens, however if it happens regularly then u will have to give it a thought.

(2) Is there any alert or notification mechanism that we can setup instead of running transaction SXMB_MONI manually?

Well, if the msgs r in the scheduled state then NO.

(3) Is manual restart XML message a proper way to handle those scheduled message? Any way to automatically handle this message in ERP side?

Manual restart is not the best way to handle msgs bcause you might loose track/ some msgs might error out together causing issues. (that has happend to us). its tough to keep track if that is the case and if its critical from business point of view.

If it is going out of R/3 then may be you can configure jobs to push the data periodically.

Regards,

Pavan

[Former Member]

check DBSTATISTIC ...

[Former Member]

Hi Donald,

Go to SXMB_MONI and click on the Schedule messages.

Select the message and there you will find the corresponding queue name. Unlock the queue and again check the SXMB_MONI . Here you will see the message gets successfully processed.

regards

Ashwin Kumar Dhakne