on 10-02-2009 11:57 AM
HI,
In OUR production system, we have 38 Sender communication channel with JDBC Adapter and com.microsoft.sqlserver.jdbc.SQLServerDriver to access to multiple databases with 5 minutes polling.
All these channels work correctly since this night, when five of this channels seems to became inconsistent. They don't execute any store procedure and don't return any error. Monitoring SQL sessions, we don't find any access of our XI system.
In channel monitor I can see only:
10/2/09 10:56:31 AM Processing started
10/2/09 10:46:25 AM Processing started
10/2/09 10:36:34 AM Processing started
10/2/09 10:26:34 AM Processing started
10/2/09 10:16:39 AM Processing started
10/2/09 10:06:21 AM Processing started
10/2/09 9:57:08 AM Processing started
10/2/09 9:46:21 AM Processing started
10/2/09 9:36:23 AM Processing started
10/2/09 9:26:28 AM Processing started
I stop and restart this five channels but nothing has changed.
Any input, please? Thanks,
Carme
Hi Carme,
We have faced this type of issue in our JDBC landscape and when we set the option Disconnect from Database After Processing Each Message in communication channel the problem was solved
Check this help.sap page http://help.sap.com/saphelp_nw04/helpdata/EN/7e/5df96381ec72468a00815dd80f8b63/content.htm
Also check note Note 831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter
point 7
Regards
suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for your replies.
Suraj, i have this parameter (Disconnect from Database after processing each message) checked in all this channels.
I think this parameter can minimize this issue but as i can see, it doesn't solve.
Ninad, the restart our production system with a great volum of message and channels is not a good solution of this problem because i need to avoid it could be reproduced.
Any other input?
Camre.
Please add Pool waiting time and Task Time Out parameter in advanced mode parameters of JDBC Channel.
Check is there any lock in Adapter Locking Services in Visual Admin when the issue is occouring.
Is your production system HA? If yes, is this issue happening for any particular server node? Have u used cluster synch mode = lock?
What is the driver version that you are using and corresponding DB version for which problem occours?
Warm Regards,
Gouri
thanks for your replies.
To avoid this issue from happening again i hve set the tasktimeout as described in note
1083488 - XI FTP/JDBC sender channel stop polling indefinitely
Carme
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.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.