Message getting stuck in Queue

[Former Member]

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

[aashish_sinha · Accepted solution]

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

[Former Member · Accepted solution]

Hi,

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

Need soultions friends.

Thanks

Ramesh

[Former Member · Accepted solution]

Hi

1. Goto sxmb_adm

2. De-activate the Queues

3. Activate the Queues

4. Register the Queues

Regards,

Krishna

[Former Member · Accepted solution]

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

or

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

hi

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

[Former Member]

hi

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

[Former Member]

hi

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

[Former Member]

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

[Former Member]

Hi Ramesh,

Can u tell me whats the error in queue?

Regards,

sateesh

[dharamveer_gaur2]

hi

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

Now scenario working fine.

[Former Member]

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

[Former Member]

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

[kkram]

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

KK

[Former Member]

Remember in production use

RSXMB_RESTART_MESSAGES - Restart Messages with Errors

[Former Member]

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