Issue with PI picking messages from Websphere MQ

[Former Member]

Hi All,

We have an issue with our interfaces in SAP PI (version 7.0, SP 19) which connect to Websphere MQ (version 5.3) using JMS adapter (having deployed JMS drivers version 5.3) to pick messages from its queues. We have only One Queue Manager(other connections with this Queue manager have no issues reported) and 4 queues from which our 4 PI interfaces pick messages from . These interfaces were running fine from past six months and suddenly it was observed that the Messages greater than 10KB are not being picked up from MQ. Messages with Size upto 5KB are received by SAP PI. Messages with size 7 KB are coming into PI with much delay (nearly 1-2 hrs) . No changes have been done at MQ and at PI configurations from past six months. Earlier we used to pick messages of size upto 4 MB from the MQ with no issues.

The only change could be the Kernel Upgrade in PI at that time before the issue just came up.

Observed Behaviour at PI :

Communication Channel shows no error logs. All Channels have status as successfully connected to Queues. Found server logs : u201Ccom.ibm.mq.MQException: MQJE001: Completion Code 2, Reason 2019u201D.

Observed Behaviour at MQ :

Messages from MQ disappear ( looks like being picked up) and queues have uncommitted status however after few minutes the messages appear again on the original queues, status changes back to committed.

We have done every check like :

Stopped the PI Channels and started, deleted queues on MQ and recreated, Restarted PI instance. u2013 No results.

We have applied the SAP note : 1086303 which talks about parameter with name 'activateExceptionListener'. But no results.

The MQException: MQJE001: Completion Code 2, Reason 2019 u2013 guides to IBM TechNote : http://www-01.ibm.com/support/docview.wss?uid=swg21229508. This was not implemented in MQ server as there was no such settings available on the server. ( We donu2019t have WAS for MQ).

Even the network team has confirmed its not a issue with Network/Firewall. (There are 2 Firewalls between PI and MQ servers. There was no change on the Firewall Rule as confirmed by the Network Team).

Please suggest if you have faced this kind of issue. We are facing this issue in Production environment. Hence any response will be much help.

[Former Member]

Thanks for all your replies.

The issue got resolved due to change in Network configuration. The issue was nothing to do with PI configuration. It was a problem in Network Switch between the PI and MQ server. When the Switch mode was changed to Full Duplex, the messages started getting picked up from MQ. Apologies for the late post.

[former_member187339]

Hi Prasanna,

Since you have done all the initial check and workarounds. I will suggest you to raise a OSS message as this looks like some standard issue with the kernel path. Let SAP have a look at the issue and provide you with a solution

Regards

Suraj

[baskar_gopalakrishnan2]

PI optimum message size handlling is upto 5 mb. More than 5 MB could cause performance issues. We had this issue..

a) Increase the tuning parameter in SXMB_ADM as follows

Category: TUNING

Parameter: EO_MSG_SIZE_LIMIT

Current value: 20480 (or some require value)

default value:0

b) Scheduled this message interface in the off peak time likei n the early morning

The above things might help for some extent.

[Former Member]

Hi Basker,

We have exactly the same tuning parameter in SXMB_ADM as you mentioned.

Category: TUNING

Parameter: EO_MSG_SIZE_LIMIT

Current value: 20480 (or some require value)

default value:0

The problem is that the message is not entering in the adapter engine itself if its >= 10KB.

We have tried replicating the scenario in Quality system and its working fine .. No issues at all.

Regards,

Prasanna

[Former Member]

Hi Prasanna ,

I will not able to tell you the exact solution of this issue but want to share some input with you .

your problem is : message size greater than 10 Mb is not being picked up from queues and bigger message <7 MB its taking lot of time .

1 This is at all not related with PI server(integration server) so first make it clear nothing is needed/could be done in PI to resolve this issue .

2 .Tell your MQ counterpart that increase depth of their channel there is a parameter in MQ which decide how much size message can be handled by MQ in our project it was 7 MB so we get it increased to 15 MB after that till 15 MB we are able to process but if message bigger than it comes again the same issue . Moreover for extra time being taken for transferring message should also be looked by MQ team they have to ensure enough process are available to transfer the message .

Regards,

Saurabh

[Former Member]

Hi Saurabh,

The size of file PI is not able to pick up is 10 KB itself.. and yes we have already checked the MQ Queue parameter (MaxLength) - its set to maximum (around 90 MB).

Regards,

Prasanna.

[Former Member]

Hi Prasanna ,

have you checked on the SAP server on which queue is installed .are you getting any error log there .Just view the trace file of communication channel you might get some error log which will give you more insight in the issue .

Regards,

Saurabh