APAR status
Closed as change to accomodate OEM Vendor's code.
Error description
The actual values in the error message will depend on the type of the database column being describe after the incremented column. For example DatabaseException BIP2322E: Database error: SQL State ''07006''; Native Error Code '0'; Error Text ''[IBM][ODBC Oracle Wire Protocol driver]Unable to convert parameter 1. Cannot convert from C type 93 to SQL type 3.''.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: All users of IBM Integration Bus Version 10 or App Connect Enterprise Version 11 or Version 12 who use an Oracle database where an incremented column is used in a database statement. Platforms affected: AIX, HP-UX PA-RISC platform, 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: The DataDirect Oracle ODBC driver incorrectly described the columns that followed an incremented column in a database statement. For example in this update statement the database column 'MyColumn3' would be incorrectly described. UPDATE Database.MyTable AS Z SET MyColumn1 = CURRENT_TIMESTAMP, MyColumn2 = Z.MyColumn2 + 1, MyColumn3 = MyNameVariable;
Problem conclusion
A new DataDirect Oracle ODBC driver that fixes the error is now supplied with App Connect Enterprise.
Temporary fix
Comments
APAR Information
APAR number
IT41949
Reported component name
INTEGRATION BUS
Reported component ID
5724J0540
Reported release
A00
Status
CLOSED OEM
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-09-05
Closed date
2022-09-08
Last modified date
2022-09-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
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:
09 September 2022