APAR status
Closed as program error.
Error description
After applying patch JR33242_aix_DS752.tar.Z, job extracting number column from Oracle fails meeting ORA-01406 error. With GA version operator, same job with same data runs fine. Item #: 130 Event ID: 129 Timestamp: 2009-08-14 17:00:35 Type: Fatal User Name: dsadm Message: S_01,0: (aptoci.C:449). Message: ORA-01406: fetched column value was truncated One other problem, the job does not abort even with above FATAL error.
Local fix
This fix is included in 8.0.1 fixpack 3
Problem summary
**************************************************************** USERS AFFECTED: queries reading NUMBER columns with large fractions. **************************************************************** PROBLEM DESCRIPTION: ORA-01406 ERROR IN READING NUMBER COLUMN BY ORACLE ENTERPRISE STAGE. This problem occurs as we read a NUMBER column defined without precision and scale associated with it. We read as (38,10) but as fraction has large no. of leading zeros causing the truncation error. **************************************************************** RECOMMENDATION: Apply the patch provided. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
This problem can be cured by using a real large bind buffer to read. But user's version of the read value can still suffer unless user overrides defaults with APT_ORA_DEFAULT_NUMBER_FORMAT
Temporary fix
Comments
APAR Information
APAR number
JR34111
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-09-01
Closed date
2009-09-11
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":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010