IBM Support

JR34038: RUNTIME COLUMN PROPAGATION SETTING NOT WORKING

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The user has a job with Oracle Connector stage which reads data
    from a table. No columns are defined on the output link but the
    user has selected the Runtime column propagation checkbox on
    the Columns tab. The job however fails indicating that there
    are no columns on the output link. The connector should add the
    missing columns to the link automatically.
    

Local fix

  • Ensure that the selection of the Runtime column propagation
    checkbox is the last operation prior to compiling the job. Go
    to the Columns tab, select the Runtime column propagation
    checkbox, and if it was already selected, then
    unselect and select it again. click OK to close the stage and
    then compile the job.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Oracle Connector users who utilize Runtime Column Propagation
    functionality for output links.
    ****************************************************************
    PROBLEM DESCRIPTION:
    The Runtime Column Propagation setting for the output link was
    not honored by the Oracle Connector stage. Instead of adding
    field definitions to the link at runtime in this case, the
    connector would report error indicating that no columns are
    defined on the output link.
    ****************************************************************
    RECOMMENDATION:
    Install Connector Rollup Patch 2 (CCRP2).
    ****************************************************************
    

Problem conclusion

  • The connector and the connector client UI were fixed to take
    into account the output link setting for Runtime Column
    Propagation.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34038

  • 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-08-28

  • Last modified date

    2009-09-28

  • 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:
28 September 2009