Skip to Content
avatar image
Former Member

Receiver JDBC adapter issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 29, 2015 at 12:26 PM


    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 29, 2015 at 01:38 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Nov 01, 2015 at 04:36 PM

    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


    driver.jpg (9.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • 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