Receiver JDBC adapter issue

[Former Member]

Hi PI Experts,

We find a strange issue in SAP PI JDBC interface.Message flow is from ECC - PI -Third party system.

PI server has 4 clustered node.When the data received in node1 and node2 ,it gets processed and delivered to end system.

When the message picks node3 and node 4 ,we get the below error

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: Io exception: The Network Adapter could not establish the connection. : SQLException: Io exception: The Network Adapter could not establish the connection

Firewall is already opened between the 2 servers from all the nodes.

Ojdbc14..jar installed in PI(jdk 1.5).Target system is using Oracle 10g DB.

Did anyone faced the similar type of issue.

Regards,

Karthiga

[former_member183816]

We had faced similar issue, few weeks back in our PO server, We fixed it by adding following parameters in our channels in Advanced tab->Advanced Mode.

driver:oracle.jdbc.timezoneAsRegion          false

[Former Member]

Hi Ambuj,

Did you faced similar kind of node issue in receiver JDBC CC.

We are using PI 7.11 SP13.Messages processing successfully in 2 of the nodes.

When the message picks node3 and node 4,we are getting below network error in Prod system.

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: Io exception: The Network Adapter could not establish the connection. : SQLException: Io exception: The Network Adapter could not establish the connection.

Will this parameter fix the above issue?

driver:oracle.jdbc.timezoneAsRegion          false

Regards,

Karthiga

[former_member183816]

I think only node restart could fix that problem. Even after node restart, your issue is not getting resolved then try that parameter which i mentioned.

[Former Member]

Hi Ambuj,

I have added the above mentioned property in Communication channel.But still the issue has not resolved.Also a new driver ojdbc5.jar deployed in PI central instance.Messages processing successfully in first 2 of the nodes in Production.It failing with network adapter error in other 2 nodes.

Please suggest how to fix this issue.

Regards,

Karthiga

[ravicarpenter]

Have you done telnet with target ip and port from your PI server. Ask basis to do it for you and check whether its successful or not. Also, AFAIK same server can have both logical and physical ip i.e. same server can have both X as logical ip and Y as its actual ip. Check whether all appropriate both logical and physical ip telnet are successful

[iaki_vila]

Hi Khartiga,

Are you sure in the DB machine/system doesn't have any firewall rule and the have opened only for one PI node?. Talk with the PI and DB basis team, in order to assure that from the PI problematic nodes, PI can reach the DB system.

Pay attention the exception " The Network Adapter could not establish the connection", it is self explanatory to a networkissue, talk with the PI basis team to do a test with only the problematic nodes available and to use any sniffer program to check if any issue happens.

Regards.

[Former Member]

Hi,

We already verified the firewall connection.Firewall is open from all PI server nodes.Basis team checked it and telnet to DB host is working.

We are using the connection string in below format.

jdbc:oracle:thin:@hostname:1521:DB instance

Anything wrong with this connection string?

Regards,

Karthiga

[Former Member]

Hi All,

Does any one faced similar kind of node issue in JDBC receiver adapter.

Target system DB - Oracle 11g and OJDBC14 jar deployed in PI.

Regards,

Karthiga