IBM Support

JR34486: ORA-01406 ERROR IN READING LITERAL BY ORACLE ENTERPRISE STAGE.

Subscribe

You can track all active APARs for this component.

 

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