IBM Support

IT28567: ORACLE ODBC CONNECTION FAILS WITH UNEXPECTED NETWORK ERROR AFTERA LONG IDLE PERIOD

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • At IBM Integration Bus v10 Fix Pack 12 and later, if an Oracle
    ODBC connection remains idle for a long period of time then the
    following error may be reported when the connection is next
    used:
    
    BIP2322E: Database error: SQL State 'HY000'; Native Error Code
    '-5'; Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol
    driver][Oracle]Unexpected Network Error.'.
    
    This was seen when the connection had been idle for longer than
    30 minutes. The problem did not occur at Fix Pack 6.
    

Local fix

  • 1. Set SQLNET.EXPIRE_TIME=0 in the Oracle server sqlnet.ora to
    disable the sending of probes to verify that client/server
    connections are active.
    
    or
    
    2. Use the command
    
    mqsichangeproperties myIntegrationNode -e myIntegrationServer -o
    ComIbmDatabaseConnectionManager -n maxConnectionAge -v
    timeInSeconds
    
    to specify a shorter 'timeInSeconds' period that connections can
    remain idle before being released by the message flow.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users if IBM Integration Bus V10 and IBM App Connect
    Enterprise V11 using ODBC connections to Oracle database server.
    
    
    Platforms affected:
    MultiPlatform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    At IBM Integration Bus v10 Fix Pack 12 and later, if an Oracle
    ODBC connection remains idle for a long period of time then the
    following error may be reported when the connection is next
    used:
    
    BIP2322E: Database error: SQL State 'HY000'; Native Error Code
    '-5';
    Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol
    driver][Oracle]Unexpected Network Error.'.
    
    This was seen when the connection had been idle for longer than
    30 minutes. The default maximum connection age that an ODBC
    connection can remain idle before being closed by the
    integration server is 60 seconds, so this problem will only be
    seen if the maxConnectionAge property on the resource manager
    ComIbmDatabaseConnectionManager has been greatly increased by
    the user.
    The problem did not occur at Fix Pack 6.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT28567

  • Reported component name

    INTEGRATION BUS

  • Reported component ID

    5724J0540

  • Reported release

    A00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-03-25

  • Closed date

    2019-06-25

  • Last modified date

    2019-06-25

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INTEGRATION BUS

  • Fixed component ID

    5724J0540

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
25 June 2019