Question Re: Message getting stuck in Queue in Technology Q&A

Message getting stuck in Queue

Former Member — Thu, 02 Oct 2008 10:24:09 GMT

Dear Freinds,

One of our interface is from Asyn JDBC -> Asyn Proxy. During execution we found the messages are getting stuck in R/3 side. Even we tried deleting those and again activated, but still the problem persits.

How to resolve . Reply ASAP.

Thanks & Regards

K.Ramesh

Re: Message getting stuck in Queue

aashish_sinha — Thu, 02 Oct 2008 10:27:55 GMT

Hi,

You can use the transactions SMQ1 and SMQ2 to clear the inbound and outbound messages in the ABAP stack. You can run this transactions in your XI server and clear the stuck up messages.

but you have registred the queues ?

TCODE -> SXMB_ADM -> register queues

regards

Aashish Sinha

Re: Message getting stuck in Queue

Former Member — Thu, 02 Oct 2008 10:32:51 GMT

Hi,

We have done whatever you have mentioned above. But still the issue persists.

Need soultions friends.

Thanks

Ramesh

Re: Message getting stuck in Queue

Former Member — Thu, 02 Oct 2008 10:36:57 GMT

1. Goto sxmb_adm

2. De-activate the Queues

3. Activate the Queues

4. Register the Queues

Regards,

Krishna

Re: Message getting stuck in Queue

Former Member — Thu, 02 Oct 2008 10:39:49 GMT

Hi Rames,

Can you see your message in any place of your R3?

I mean, if you can see the message in SXMB_MONI, post the error.

If you see your message stuck in SMQ1 or SMQ2 (it should be

SMQ2 as your message is proccessed in inbound queue) post the error displayed in qRFC monitor.

Carlos

Re: Message getting stuck in Queue

Former Member — Thu, 02 Oct 2008 17:35:54 GMT

Hi Ramesh,

I too got the same problem recently.

you can solve it by

1) restrict the size of the paylaod by breaking it to smaller chunks

2) If you are pickiing all records in to payload, check with your business people if they support delta run.

so that for intial run you will load whole file containing all records, after that you will run interface only with changed/update values.

Let me know how it goes.

Re: Message getting stuck in Queue

Former Member — Thu, 02 Oct 2008 23:44:35 GMT

Remember in production use

RSXMB_RESTART_MESSAGES - Restart Messages with Errors

Re: Message getting stuck in Queue

kkram — Fri, 03 Oct 2008 03:49:43 GMT

Ramesh

You may want to cancel the concerned messages in SXMB_MONI instead of deleting the queue entries. And yes, you may also want to resolve the source of the issue but for the problem of yours, cancel the messages in SXMB_MONI .

Thanks

Re: Message getting stuck in Queue

Former Member — Fri, 03 Oct 2008 04:08:18 GMT

Hello Ramesh,

Can you post the StatusText of the Queue Entry.

Double Click on the QueueEntry present in SMQ2 you can the Status Text.

regards

Gangaprasad

Re: Message getting stuck in Queue

Former Member — Fri, 03 Oct 2008 04:15:52 GMT

Hi Ramesh,

Just make sure that you have deleted all the Messages those strucked in the queues before activating the Queues.

1)Just goto SMQ2 and delete all the entries if u dont require these messages

2)Goto SMQR and select all and Delete all the queues

3)Goto SXMB_ADM ~~-Manage Queues~~-Just Register and dont say any Activation and all

Now trigger the message angain and check whether it is strucked or not

Regards

Seshagiri

Re: Message getting stuck in Queue

Former Member — Fri, 03 Oct 2008 04:31:26 GMT

Hi Ramesh,

There is some reasons message is struck in queues.

1)First find out the error in queue.what is the error? If u delete and again u can push it same problem will be occured.

2)check ur payload in XI monitoring, If data is correct and transforamtion is correct or not.

Regards,

Sateesh

Re: Message getting stuck in Queue

Former Member — Fri, 03 Oct 2008 15:12:38 GMT

Hi Sheshagiri,

We have followed the steps mentioned steps but still we are getting the same error. Please tell us how to solve this issue.

Thanks

Ramesh

Re: Message getting stuck in Queue

dharamveer_gaur2 — Mon, 06 Oct 2008 05:09:09 GMT

Same problem faced by me,every thing was ok. atlast i refresh SLD and CPA cache.

Now scenario working fine.

Re: Message getting stuck in Queue

Former Member — Mon, 06 Oct 2008 06:17:07 GMT

Hi Ramesh,

Can u tell me whats the error in queue?

Regards,

sateesh

Re: Message getting stuck in Queue

Former Member — Mon, 06 Oct 2008 07:57:06 GMT

Hi Ramesh

Use QOS as EOIO in JDBC sender adapter. Provide the queue name so that it will not stuck XML messages generated in a single queue.

Thanks

Gaurav

Re: Message getting stuck in Queue

Former Member — Mon, 06 Oct 2008 09:05:10 GMT

please check tcode SMICM there status should be active

it will definately help you IF NOT ask your basis person to check ICM SETTINGS

after that u go to smq1 or smq2 ,first deregister the ques and again register the queues your problem will be solved immediately

WITH REGARDS,

srinivas

Re: Message getting stuck in Queue

Former Member — Mon, 06 Oct 2008 09:23:08 GMT

please check tcode SMICM there status should be active

it will definately help you IF NOT ask your basis person to check ICM SETTINGS

after that u go to smq1 or smq2 ,first deregister the ques and again register the queues your problem will be solved immediately

WITH REGARDS,

srinivas

Re: Message getting stuck in Queue

Former Member — Mon, 06 Oct 2008 09:37:15 GMT

you have to check your ICM settings, both in r/3 and xi systems and after makking settings to icm in tcode SMICM take the help of your basis

go to smq2 and deregister the queues first and then again register the queues and just click on refresh

your problem will be solved immediatly

in case it is not solved let me know

with regards,

srinivas