IBM Support

JR35680: STP-ORACLE PLUGIN ABORTS :"ORA-01480: TRAILING NULL MISSING FROM STR BIND" INSERTING EXACTLY 4000 CHARS INPUT DATA

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A Stored Procedure Plugin job connecting to Oracle database
    fails with "ORA-01480: trailing null missing from STR bind
    value" error message when the input to the VARCHAR2(4000) field
    contains data of exactly 4000 chars. It works when the data is
    less than 4000 characters.
    

Local fix

  • Insert a smaller value (up to 3999 chars)
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of Stored Procedure stage connecting to Oracle
    database, having a varchar2 field and sending exactly 4000
    characters of input data.
    ****************************************************************
    PROBLEM DESCRIPTION:
    STP Stage connecting to Oracle database and trying to insert
    data
    into a varchar field of size exactly 4000 characters fails with
    the following error message:
    PMR_VARCHAR2_4000..Stored_Procedure: ORA-01480: trailing null
    missing from STR bind value
    ****************************************************************
    RECOMMENDATION:
    Apply APAR: JR35680
    ****************************************************************
    

Problem conclusion

  • Code has been corrected to handle exactly 4000 characters of
    input data for varchar2 field.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR35680

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-17

  • Closed date

    2010-03-04

  • Last modified date

    2010-03-04

  • 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

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

Document Information

Modified date:
11 October 2021