APAR status
Closed as change to accomodate OEM Vendor's code.
Error description
The error occurs with the first TIMESTAMP column in a query following some form of string processing, such as REVERSE or SUBSTR. If no string processing is performed in the query then there is no error reported from the TIMESTAMP column. There is no error reported from TIMETAMP columns that precede the string processing in the query.
Local fix
It may be possible to work around this issue by reordering the database query so that no TIMESTAMP columns follow the string processing.
Problem summary
**************************************************************** USERS AFFECTED: All Users of IBM Integration Bus V10 and AppConnect Enterprise Versions 11 and 12 access an Oracle database using ODBC. 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: An ORA-01841 error message is returned when a database query that performs some form of string processing then attempts to also use a TIMESTAMP column. The error occurs with the first TIMESTAMP column in a query that follows the string processing. The full oracle error message is "ORA-01841: (full) year must be between -4713 and +9999, and not be 0"
Problem conclusion
An update DataDirect Oracle ODBC driver has been supplied to correct the error.
Temporary fix
Comments
APAR Information
APAR number
IT41086
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-05-31
Closed date
2022-06-14
Last modified date
2022-06-14
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
[{"Line of Business":{"code":"LOB45","label":"Automation"},"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"}]
Document Information
Modified date:
15 June 2022