APAR status
Closed as program error.
Error description
When interacting with Oracle the following database errors are received for some transactions BIP2322E: Database error: SQL State 'HY000'; Native Error Code '11606'; Error Text '[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-22288: file or LOB operation failed'. BIP2322E: Database error: SQL State 'HY000'; Native Error Code '-1'; Error Text '[IBM][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.'. BIP2322E: Database error: SQL State 'HY000'; Native Error Code '-1'; Error Text '[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-12656: Cryptographic checksum mismatch'.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: All users of IBM Integration Bus v10 and AppConnect Enterprise v11 and v12 who access an Oracle database. Platforms affected: AIX, HP-UX Itanium platform, Linux on Power platform, Linux on x86-64 platform, Linux on zSeries platform, Solaris x86-64 platform, Solaris SPARC platform, Windows on x86-64 platform **************************************************************** PROBLEM DESCRIPTION: When interacting with Oracle the following database errors may be received for some transactions BIP2322E: Database error: SQL State 'HY000'; Native Error Code '11606'; Error Text '[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-22288: file or LOB operation failed'. BIP2322E: Database error: SQL State 'HY000'; Native Error Code '-1'; Error Text '[IBM][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.'. BIP2322E: Database error: SQL State 'HY000'; Native Error Code '-1'; Error Text '[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-12656: Cryptographic checksum mismatch'.
Problem conclusion
A new DataDirect Oracle ODBC driver that fixes the error is now supplied with IBM Integration Bus and App Connect Enterprise. --------------------------------------------------------------- The fix is targeted for delivery in the following PTFs: Version Maintenance Level v11.0 11.0.0.19 v12.0 12.0.6.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
IT42414
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
2022-11-08
Closed date
2023-02-03
Last modified date
2023-02-03
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
08 February 2023