A fix is available
APAR status
Closed as program error.
Error description
After applying patch JR34111_aix_DS752.tar.Z, job extracting constant Hangul literal from Oracle fails meeting ORA-01406 error. Item #: 54 Event ID: 53 Timestamp: 2009-09-30 11:51:55 Type: Fatal User Name: dsadm Message: S_M00,0: (aptoci.C:460). Message: ORA-01406: fetched column value was truncated Item #: 55 Event ID: 54 Timestamp: 2009-09-30 11:51:55 Type: Fatal User Name: dsadm Message: S_M00,0: The runLocally() of the operator failed.
Local fix
This fix is included in 8.0.1 fixpack 3
Problem summary
**************************************************************** USERS AFFECTED: Jobs reading multi byte literals in select lists. **************************************************************** PROBLEM DESCRIPTION: Fetching multi-byte literal string from Oracle fails meeting ORA-01406 error. Message: ORA-01406: fetched column value was truncated. **************************************************************** RECOMMENDATION: Apply provided patch. ****************************************************************
Problem conclusion
If a multi- byte Oracle client is using the server character set, then -use_strings option awards literal with wrong schema. This results in ORA-01406 error in reading literal by Oracle Enterprise stage. Resolution is to change the conditional so that we enable expansion factor on columns/literals whenever byte length and code-point length values differ.
Temporary fix
Comments
APAR Information
APAR number
JR34486
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
752
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-10-08
Closed date
2009-10-16
Last modified date
2010-12-09
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
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R752 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.2","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 October 2021