Unable To Resolve Timeout Issue For BRM JCA Adapter In Weblogic Due to Firewall Even Keepalive Is Set (Doc ID 1560617.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.
***Checked for relevance on 4-MAR-2015***

Goal

Qn: In an UAT environment, noticed the connections between BRM JCA Adapter and BRM server being dropped by the firewall due to inactivity. Would like to know if there is a solution for this issue.

There is a F5 load balancer and a Firewall in between SOA/AIA/WebLogic/JCA and BRM. The timeout on F5 and Firewall is currently set to 30 mins.  The firewall cannot be removed.

Also tcp keep alive properties at the OS level (Linux) are set to the below values:
 # cat /proc/sys/net/ipv4/tcp_keepalive_time
 1200
 # cat /proc/sys/net/ipv4/tcp_keepalive_intvl
 60
 # cat /proc/sys/net/ipv4/tcp_keepalive_probes
 9

It is believed that because of the firewall, the bad connection pool happened.

Also, tried to increase the F5 and the Firewall timeout to 24 hrs. Keepalive properties are implemented in OS level and weblogic is running on IPv4. JCA adapter is deployed on the SOA server with WebLogic. 

However inspite of the keepalive parameters, frequently the connection pool error occurs (ERR_BAD_READ). It is noticed that the keepalive timers are working on BRM but not on the SOA box.

Unless the JCA adapter requests for the keepalive on the SOA Server, the keepalive timer will not be set on the SOA Server and without this there will not be any keepalive packet transmission from the SOA Server.

Would want to know how can the JCA adapter be allowed to call the keepalive.

Below is the netstat output from SOA and BRM servers.

SOA Server:

[glaw@kstllsoau01 ~]$ netstat -ao |grep -i 119
tcp 0 0 kstllsoau01:44311 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44310 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44304 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44301 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44300 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44303 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44302 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44297 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44299 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:44298 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36380 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36378 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36379 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36376 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36377 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36375 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36373 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36388 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36386 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)
tcp 0 0 kstllsoau01:36387 brm-uat.xxx:11960 ESTABLISHED off (0.00/0/0)

BRM Server:

tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:60075 ESTABLISHED keepalive (696.35/0/0)
tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:59307 ESTABLISHED keepalive (520.87/0/0)
tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:60069 ESTABLISHED keepalive (696.03/0/0)
tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:60070 ESTABLISHED keepalive (646.70/0/0)
tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:34780 ESTABLISHED keepalive (83.04/0/0)
tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:34781 ESTABLISHED keepalive (817.56/0/0)
tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:34774 ESTABLISHED keepalive (183.28/0/0)
tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:34764 ESTABLISHED keepalive (68.93/0/0)
tcp 0 0 kstllbrmu01:11960 192.168.xx.xx:43514 ESTABLISHED keepalive (746.85/0/0)
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms