PI PRD & MQ Connection broken

[Former Member]

Hi,

We are facing some typical problem. We are using Cluster in PI Production server and there are two nodes Node A & Node B. and these nodes are connected individually with IBM MQ server. The issue is that the connection is getting broken between these two servers and it is happening every week. The error log says that, MQRC_CONNECTION_BROKEN with reason code '2009'. Can you pls guide to solve this?

Regards

Amarnath

[Former Member]

Hello, we have used clustered PI with IBM MQ series for 4 years and we haven't experienced this.

Is this happening consistently every week?

Is it at a particular time?

If yes, perhaps you can use Adapter Availability Time Scheduling in PI to stop / start your adapter during the window. Maybe your queues are being reset without your knowledge as part of regular maintenance?

How have you been recovering from the issue?

Is it causing data corruption, or just that you need to stop / start the channel?

[Former Member]

Hi Aaron,

Is this happening consistently every week? Yes..

Is it at a particular time? No.. At any time. Most probably during night time and rarely at day time..

Maybe your queues are being reset without your knowledge as part of regular maintenance? I checked with MQ team. They are saying it is not possible to automatic reset of channels or automatic server restart..

How have you been recovering from the issue? No.. Once restart the Server it is been recovered. But restarting server every week wont be a correct solution for this issue..

Is it causing data corruption, or just that you need to stop / start the channel? There is no data corruption. Inbound channels are stop & started manually. But it is taking time out error for Outbound channels.

We are having SAP PI 7.1 EHP 1 & SP 05. MQ version is 7.

Regards

Amarnath M

[Former Member]

So let me get this straight, for inbound channels you can reconnect OK after the error (PI channel start/stop). But for outbound channels, the MQ server must be restarted before you can reconnect?

[Former Member]

Hi Aaron,

for inbound channels you can reconnect OK after the error (PI channel start/stop).

Yes, after start / stop the channel connection is successful.

for outbound channels, the MQ server must be restarted before you can reconnect?

we need to restart either MQ or PI server.

How to resolve from getting the connection break error permanently?

Regards

Amarnath M

[Former Member]

Like Muniyappan suggests, to know how to fix permanently, you must find the root cause. Right now all you have are symptoms and one error message.

When our MQ server goes down for maintenance (or unexpected), the PI channels recover automatically.

Have you checked the NWA logs when the queues have disconnected? The NWA logs give more detail than what is in the RWB monitor.

Also, are you sure your MQ drivers match the version of MQ you are connecting to?

[Former Member]

Hi Aaron,

Let me check the NWA if the channel connection error occurs and let you know.

are you sure your MQ drivers match the version of MQ you are connecting to?

Is it mandatory to maintain the JMS drivers with MQ Version? In this case, say suppose if we have MQ version 7, what version of drivers we should need to maintain?

Regards

Amarnath M

[Former Member]

Check this blog from Bill Li, it may help you:

http://scn.sap.com/people/william.li/blog/2010/02/05/ibm-mq-53-60-70-interoperability-with-pi

[Former Member]

Hi,

Can anyone help us please? We are facing this every week.

Regards

Amarnath M

[Muniyappan]

Hi Amar,

can you please check this link?

http://www-01.ibm.com/support/docview.wss?uid=swg21197924

Are you using cluster for only production?

if the cluster is used in other environment ask your MQ team to check the other system and production system settings.

Regards,

Muniyappan.

[Former Member]

Hi Muni,

We are using Cluster only for Prod server. I have find this link already and checked the MQ team. But in the MQ server we cant able to find the qm.ini file as mentioned. The connection broken is happening only for particular inbound channels. In the outbound channel, Node A connection is success and Node B connection gets break and vice versa.

Thanks & Regards

Amarnath M

[Muniyappan]

Hi Amar,

in our project we are using the cluster. i did not come across this error.

you may check below one for finding qm.ini file.

http://publib.boulder.ibm.com/infocenter/wmqv6/v6r0/index.jsp?topic=%2Fcom.ibm.mq.amqzag.doc%2Ffa125...

you can also ask the MQ team to check any error logs they can find in the MQ system during your channel is getting disconnected. this can help to find the root cause.

Regards,

Muniyappan.

[Former Member]

Hi Muni,

I check with MQ team for error logs. It says nothing about disconnection of servers. It says only the file struck like that.

Please suggest me any solution, kindly.

Regards

Amarnath M