on 01-07-2016 3:52 PM
Hello,
We have 5 different interfaces using 5 receiving JDBC communication channels (all pointing to one database). We are using PI 7.31 dual stack.
The issue is when we send products and customers in mass from ERP, receiving JDBC adapter takes the messages in FIFO basis and not EOIO basis. e.g. if we have sent 20K products and 10k customers, JDBC first processes all products and later starts with customers.
I have gone through couple of blogs and review the messaging system parameters. Are there any paramters which makes JDBC adapter processing parallel?
Thanks and regards,
Sunil Joyous
Hi Sunil,
I am assuming you triggered the 20K products first, then the 10K customers.
Since the number of products is quite huge at one time, product interface may end up occupying all threads available for JDBC adapter, and the following messages(customer) with the same adapter will have to wait until products get processed.
To avoid this issue, you can set queueParallelism.maxReceivers for the Send queue of JDBC adapter with value less than max threads available, which prevents one interface consuming all threads and other interface pending with the same adapter.
Details for configuring threads per adapter and set max threads(maxReceivers above) per interface can consume, refer part "Parameters relevant for MS Queue tuning" in this blog.
Regards,
Hailong.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil,
Maybe you have already figured out the answer, just to make the conversation complete.
queueParallelism.maxReceivers is applied for the receive queue for all adapters, you can't set it up particularly for JDBC adapter.
And also if you are on at least PI 7.31 SP11, you can configure parallelism on interface level, details check SAP note 1916598 and this material.
Regards,
Hailong.
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 | |
11 | |
9 | |
7 | |
6 | |
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.