on 08-02-2007 5:10 AM
i have some scenarios runnnig in my system, some scenarios are failing due to queue STOP,
when i click the queue name from the MONI, it shows that three queues namely XBTI007, XBTI003, XBTI004 are in SYSFAIL status,
when i cllick those queues, i find some 1000 entries in each of the queue,
the topmost entry shows that qRFC SXMS_ASYNC_EXEC failed due to
reason: COMMIT/ROLLBACK error on "DEFAULT" database connection...
there are many scenarios getiing stuck but i could find that the a particular scenarios qRFC execution lead to the error,
but since all the scenarios are getting stuck ....
wat action can i take....
if i select the entry with sysfail status and activate the queue, will it hamper something...
will data loss happen??
pls help...its in production system
Hello Sudeep,
qRFC - Exactly Once in Order..
So that is why if theres an error in a message all the message which comes after that will be stuck.
If you activate the queue - data loss wont happen .
Moreover only activating the queue might not solve the problem.
Regards,
Sumit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dhar,
SMQ2 is for outbound queue and SMQ1 is inbound queue. If you are getting the messages into XI then check in SMQ1 for any errors in XI and if you are sending out from XI then see SMQ2. Check this help for some more information on this:
http://help.sap.com/saphelp_nw04/helpdata/en/76/e12041c877f623e10000000a155106/content.htm
Regards,
---Satish
Dhar,
If you are using JDBC receiver communication channel then try enabling Database Auto-Commit and give a try. Also please check this weblog:
/people/sap.user72/blog/2005/11/29/xi-how-to-re-process-failed-xi-messages-automatically
After enabling this property try to restart all this messages and give a try.
Regards,
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.