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 number
IT37695
Reported component name
APP CONNECT ENT
Reported component ID
5724J0550
Reported release
B00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-07-20
Closed date
2021-08-19
Last modified date
2021-10-06
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
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSDR5J","label":"IBM App Connect Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B00"}]
Document Information
Modified date:
13 October 2021