on 01-07-2014 10:56 AM
Hi All,
I am facing an critical issue in my production environment where all the critical production messages are stuck in queue and taking time to process.
Please suggest how to solve this issue within the SLA.
Thanks,
Suchi
Hi Suchi,
Can you please share some more below details.
Regards,
Abhi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suchi,
If it is warehouse messages I can understand your pain.In my last project these warehouse message made my life horrible .
Do one things if you are saying that no failed messages than just check is there any huge size messages approx.5 or 10 mb in the same queue.If it is there than as a workaround I will ask you to park that message in smq3 and process your critical messages manually.
Please note it is just a workaround.Once you processed all those messages than again moved back that parked message to its defined queue.
Regards,
Abhi
Hi Abhi,
thanks for sharing this approach.Yes,there are around 7 messages of huge size in the same (sorry actual size right now i cant tell you as message is taking time to open.But these message always flow in the system.
These are not critical but important.If I parked those messages,I am not sure what will be the impact.
Hi Suchi,
These messages are not getting processed only because of that huge size messages blocking this messages .Take the necessary approval from client/or just inform client that there will be some delay in this messages and start parking this messages and once you have parked all the messages start processing all the stuck warehouse messages manually.It will not take more than 30-45 min.
Regards,
Abhi
Issue is solved now.After I parked those messages in smq3.All the blocked messages are started getting processed now.
I would like to thanks all of you who helped me in solving this production issue.
I would like to appreciate Abhinav for providing the workaround and also Rsihi Das for his support
Thanks Guys!!!
Suchi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suchi,
If the queue have status SYSFAIL, reset its status from TA: SMQR and then execute the LUWs. The blocked messages will be processed.
Regards,
Reema
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suchi
As mentioned by Abhinav , if there are large messages getting processed , then you might need to park them in SMQ3 temporarily till the other queues get processed ,,,
Later on you can move them..
Also do you observe these long running processes often in SM66 for queue processing .. there might be long term issues to fix based on the observations !!
Thanks
Rishi
WHat is the status of the queue in the SMQ2 ?
If it's in sysfail check out this blog- /people/sap.user72/blog/2005/11/29/xi-how-to-re-process-failed-xi-messages-automatically
In other case, register the queue one more time (SMQR) or check SM12, if any entries are found..
Regards,
Carme.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suchi
Execute transaction SMQ1 and SMQ2.
Select the queue and click on unlock (F5) .Repeat the step until the message count goes to 0.
If there are any failed message which is blocking the queue, then cancel that failed message so that the other messages can get processed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suchi
Please provide following information :
a) Are they inbound / outbound messages ..( SMQ1 / SMQ2 ) ?
b) is there any error message you are seeing
c) Are you seeing the messages getting processed for long time ? This you can check in SM66 which will show processes running for long ...
d) Is this happening for all messages overall ? Can you check your System and DB overall if there is any issue..
Based on it - we can proceed ahead ...
Thanks
Rishi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sushi,
Go for SM12 check if WF-BATCH is stuck.
Check also SMQ2, SMQ1 if there is a msg with SYS-FAIL, try to stop/start the queue and renew the status.
Also check BD02 if the tablespace it´s full.
Kind regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.