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

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

• The product now includes an updated DataDirect ODBC Oracle
  driver that resolves the problem.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.17
  v11.0      11.0.0.5
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

Temporary fix

Comments

APAR Information

• 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