APAR status
Closed as program error.
Error description
IIB execution group process hangs after some days e.g 2-3 days also while processing a message which needs to connect to DB using DataDriver. Stack trace of hung thread #3 0x00002ab9c781ad10 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #4 0x00002ab9c781a8a8 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #5 0x00002ab9c781a913 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #6 0x00002ab9c7860864 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #7 0x00002ab9c7821985 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #8 0x00002ab9c77e2b37 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #9 0x00002ab9c77e273e in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #10 0x00002ab9c782242d in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #11 0x00002ab9c77549ad in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #12 0x00002ab9c774f290 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #13 0x00002ab9c7749d30 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #14 0x00002ab9c76c3402 in SQLConnectW () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so #15 0x00002ab9c343758d in SQLConnect () from /opt/IBM/iib-10.0.0.18/ie02/lib/libodbc.so #16 0x00002ab9c32140e8 in SQLConnect () from /opt/IBM/iib-10.0.0.18/ie02/lib/libodbcinterface.so #17 0x00002ab921cd41d1 in ImbOdbcConnection::connectInner(ImbOdbcDriverManagerWrapper*, void*&, bool, ImbWstring const&, ImbWstring const&, ImbWstring const&, bool) () from /opt/IBM/iib-10.0.0.18/server/lib/libMessageServices.so
Local fix
Restart of EG
Problem summary
**************************************************************** USERS AFFECTED: All Users of IBM Integration Bus v10.0 and App Connect Enterprise V11.0 using DataDirect Oracle ODBC driver. Platforms affected: MultiPlatform **************************************************************** PROBLEM DESCRIPTION: Integration Server intermittently hangs while interacting with the database using DataDirect Oracle ODBC driver. The stack of hung thread shows that the odbc driver hung in SQLConnectW() call. For example : 0x00002ab9c7749d30 in ?? () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so 0x00002ab9c76c3402 in SQLConnectW () from /opt/IBM/iib/server/ODBC/drivers/lib/UKora95.so 0x00002ab9c343758d in SQLConnect () from /opt/IBM/iib-10.0.0.18/ie02/lib/libodbc.so
Problem conclusion
The product now includes an updated level of the DataDirect Oracle ODBC driver that resolves the problem. --------------------------------------------------------------- The fix is targeted for delivery in the following PTFs: Version Maintenance Level v10.0 10.0.0.23 v11.0 11.0.0.11 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
IT34035
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
2020-08-28
Closed date
2020-12-13
Last modified date
2020-12-13
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
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0"}]
Document Information
Modified date:
14 December 2020