IBM Support

JR32956: CHARACTER TRUNCATION IN NVARCHAR DATATYPE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • While writing data into a column of Datatype NVARCHAR in the SQL
    Server Database, we are getting data truncation error.
    Remaining data is getting truncated.
    
    In the target table, the datatype is nvarchar(50).
    
    Product Name and Version - DataStage 7.5.2
    Operating System  -LINUX
    Database:SQL Server 2000/2005
    
    Unix Command :cat /proc/version
    
    the output of the above command is shown below.
    
    Linux version 2.4.21-47.EL_GL2x_1204 (
    <mailto:builder@vmtest-n-d00009>
    builder@vmtest-n-d00009) (gcc version 3.2.3 20030502 (Red Hat
    Linux
    3.2.3-56)) #1 SMP Tue Oct 3 12:04:12 CEST 2006
    

Local fix

  • The same scenario I have tested in one of my friends DataStage
    environment 7.5.1a/UNIX Platform over the weekend.
    It worked fine.
    
    In our environment,
    
    I have tried changing the different NLS Mapping at the job
    level.
    I always use to get some data truncation or data loaded as junk
    characters.
    
    This fix is included in 8.0.1 fixpack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Data truncated when written to nvarchar column in the SQL
    ServerDatabase with server odbc stage using DataDirect SQLServer
         driver on UNIX
    ****************************************************************
    PROBLEM DESCRIPTION:
    Data are not written correctly into a column of data type
    nvarchar in the SQL Server Database with server odbc stage
    usingDataDirect SQLServer driver on UNIX. If the data type is
        nvarchar(50), it allows only data of length 25, the rest
    gets   truncated.
    ****************************************************************
    RECOMMENDATION:
    Apply patch JR32956
    This fix is included in 8.1 FP1.
    ****************************************************************
    

Problem conclusion

  • Resolution was to fix a mapping issue in server module.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32956

  • 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-05-12

  • Closed date

    2009-06-01

  • 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:

Modules/Macros

  • SERVER
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R752 PSY

       UP

  • R753 PSY

       UP

  • R801 PSY

       UP

  • R810 PSY

       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