on 03-01-2016 12:42 PM
Hi Experts
We have multiple interfaces between 3rd party system which are running on oracle,SQL and my SQL database.
In our production system we are facing jdbc sender channel locking frequently at least a single channel gets locked in a day.we are manually removing the locks from visual admin.
May I know the reason why these channels are getting locked?
What is the best approach to be followed in order to get rid of these lock?
This is happening from past one week.
Regards
Nagur
Hello Nagur,
You may wish to check the note #1510659 Improvement in Locking Logging and Monitoring in JDBC.
Regards
Eoin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nagur,
Set the additional parameter clusterSyncMode to lock as per this sap note 801367 - XI 3.0 JDBC Adapter: Additional Parameters
"lock": This option will ensure that there is only one instance of the channel running across server node. When this option is set, JDBC adapter acquires an enqueue service lock on the server node. Lock is taken on channel object and it is exclusive and non-cumulative such that no second instance (even it is from the same channel) can fetch the data from configured Database tables unless and until first instance has completed (success/fail) it’s processing. Another key aspect of this setting is that, the polling is submitted to all the server nodes. Therefore, the processing happens at all server nodes depending on the lock acquired by the instance.
Regards,
Praveen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Inaki and praveen
I have checked disconnect the database after each transaction.
It was not happening previously we are facing the issue from past one week.
The only problem is we have around 250 sender JDBC channels setting the parameter in all the channels is complex.
For now i have created a copy of the channel and replace in the sender agreement.
Regards
Nagur
Hi Nagur,
I use the option of Disconnect from Database After Processing Each Message to avoid the session can be keep hang, however if you have a little poll time, this could affect to the performance. Have you talked with the DB team in order to know if they have an huge number of connections opened?
If you talk with the SAP guys the probably will recommend to you to recollect traces with the XPI inspector.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nagur,
Please collect data, which channels are getting locked, when they are getting locked, are they getting locked in lower environments. Collect this information over a period of time (3-4 days). Once there is pattern, it would be easy to find root cause.
Usually JDBC channel get locked when multiple PI node or channel try to access same table OR due to network issues.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Nagur,
Refer the note-821267,should be helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.