IBM Support

JR31664: RDBMS CODE 7454: DATETIME FIELD OVERFLOW

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • in 8.0.1, job dly_float_pricing_debit_datetime_overflow fails
    with the wrong error, "RDBMS code 7454: DateTime field
    overflow".  In 8.1, it fails with the correct error, "Load
    failed due to a unique key violation".  The problem is that part
    of the fix for Ecase 119414 appears to be in the 8.1 branches
    but is missing from the 8.0.1 branches.  The 8.1 branches have
    the fix in all of the following methods:
    
    CC_TeraAdapter::selectTargetTable
    CC_TeraAdapter::selectLoadErrorTable2
    CC_TeraAdapter::selectUpdateErrorTable2
    
    In the 8.0.1 branches, the fix is only present in the following
    method:
    
    CC_TeraAdapter::selectTargetTable
    
    The fix is missing from the following methods:
    
    CC_TeraAdapter::selectLoadErrorTable2
    CC_TeraAdapter::selectUpdateErrorTable2
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    TDCC users usng "timestamp" columns.
    ****************************************************************
    PROBLEM DESCRIPTION:
    RDBMS CODE 7454: DATATIME field overflow error, in certain
    cases, on "timestamp" columns.
    ****************************************************************
    RECOMMENDATION:
    Install the patch.
    ****************************************************************
    

Problem conclusion

  • Issue fixed & patch provided.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31664

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-13

  • Closed date

    2009-03-05

  • Last modified date

    2009-03-05

  • 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

  • R801 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":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 March 2009