IT37695: ODBC DATA SOURCE NAMES ARE INCORRECTLY TREATED AS CASE SENSITIVE

APAR status

• Closed as program error.

Error description

• ODBC data source names are incorrectly treated as case sensitive
  in App Connect Enterprise.
  This can lead to a failure to connect to a database due to no
  matching user name or password being located.
  If no matching user name and password are found then App Connect
  Enterprise will default to trying to user the mqsiUser user name
  instead.
  
  A typical error messages are
  BIP2348E: Error detected while attempting to obtain a connection
  to data source 'MY_DSN' of type 'ODBC' using userid 'mqsiUser'.
  
  BIP2322E: Database error: SQL State '28000'; Native Error Code
  '1017'; Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol
  driver][Oracle]ORA-01017: invalid username/password; logon
  denied'."
  

Local fix

• It is possible to work around this issue by ensuring that UPPER
  case
  is used for the data source name in
  (1) your message flow,
  (2) in the mqsisetdbparms '-n'  argument and
  (3) in the matching stanza in your ODBCINI file.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM App Connect Enterprise Versions 11 and 12.
  
  
  Platforms affected:
  Windows on x86-64 platform, Linux on x86-64 platform, Linux on
  zSeries platform, AIX, Linux on Power platform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  If an entry for a data source name is created in mqsisetdbparms
  or mqsicredentials using a different case to that used in the
  message flow then you may fail to connect to your data source.
  You may also see an attempt to connect to the data source using
  the the default ACE database user name of 'mqsiUser' instead.
  

Problem conclusion

• The differing cases meant that the associated user name and
  password for database access was not located. The code has been
  changed so that a data source name is now case insensitive.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v11.0      11.0.0.14
  v12.0      12.0.2.0
  
  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

  APP CONNECT ENT

• Fixed component ID

  5724J0550

Applicable component levels