IBM Support

JR36170: READING LARGE XMLTYPE VALUES FAILS WHEN RUNTIME COLUMN PROPAGATI ON IS USED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Oracle Connector and DB2 Connector are used to replicate data
    from Oracle 10 DB to DB2 9.5 DB.
    User implemented a generic job with RCP but have a problem with
    tables with Oracle XMLTYPE columns.
    
    The error message is :
    
    ORA_READ_Table,0: [IIS-CONN-ORA-001003] The OCI function
    
    OCIStmtFetch
    returned status -1. Error code: 19.011, Error message:
    
    ORA-19011:
    Character string buffer too small. (CC_OraStatement::fetch,
    file
    CC_OraStatement.cpp, line 1.009)
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    DataStage users who are using Oracle Connector stage in their
    jobs
    ****************************************************************
    PROBLEM DESCRIPTION:
    Oracle Connector is configured to read data from a table that
    contains a column of XMLTYPE data type. Some of the values in
    this column are larger than 4000 bytes. The output link of the
    Oracle Connector stage does not contain any columns and the
    stage is configured to use Runtime Column Propagation. The job
    fails with the Oracle error: ORA-19011: Character string buffer
    too small.
    
    ****************************************************************
    RECOMMENDATION:
    Install the patch (JR36170).
    ****************************************************************
    

Problem conclusion

  • The code for generating SELECT statement was updated. Instead of
    generating the generic "SELECT * FROM table_name" statement,
    the connector provides the select list of columns that are
    defined in the table and specifies this list instead of the *
    wildcard. For any XMLTYPE column, rather than including the
    column name in the select list, the connector includes the
    XMLTYPE.GETCLOBVAL() or XMLTYPE.GETBLOBVAL() function call for
    that column, depending on the XML storage type that was
    specified in the XMLTYPE column definition. This in turn allows
    for fetching values from that column that are larger than 4000
    bytes.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR36170

  • 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-04-07

  • Closed date

    2010-05-20

  • Last modified date

    2010-05-20

  • 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

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

Document Information

Modified date:
07 October 2021