IBM Support

JR34045: ORA-01003 ORACLE ERROR WHEN READING FROM LONG COLUMNS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The user has configured Oracle Connector stage to read data
    from a table that contains columns of LONG data type. The
    number of records in the source table is smaller than the Array
    size property value of 2000. The job fails with the Oracle
    native error ORA-01003.
    

Local fix

  • Set Array size property value to 1.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users of Oracle Connector who are extracting data from Oracle
    tables that contain LONG and LONG RAW columns.
    ****************************************************************
    PROBLEM DESCRIPTION:
    The connector would return error in cases when the total number
    of rows that it fetched from the source table was smaller than
    the value specified for the array size to use for array reads.
    The connector was not properly distinguishing between the total
    size of the array and the count of records that were actually
    fetched from the table. This was happening in cases when the
    connector was reading from a table that contained columns of
    LONG or LONG RAW data types.
    ****************************************************************
    RECOMMENDATION:
    Install Connector Rollup Patch 2 (CCRP2).
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • The connector was fixed to correctly determine the number of
    rows that were fetched in the initial array from the table with
    LONG and LONG RAW columns and to handle the situation in which
    that number was smaller than the array size.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34045

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-18

  • Closed date

    2009-09-28

  • Last modified date

    2009-12-15

  • 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":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 December 2009