PJ40424: SOMETIMES THE FAILURE OF A BRANCH UNIT INSIDE ITERATOR OPERATOR DID NOT BREAK THE ITERATOR LOOP EXPECTEDLY

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Steps to reproduce:
    1. Put an iterator operator (from 0 to 3).
    2. Inside the iterator,
    2.1. Firstly check whether the current iterator var is 0
    (Variable_Comparison_A).
    If yes, linked to File_Wait_A - where we detect a not existing
    file. And link to a Continue operator on the failure output port
    (QUITE IMPORTANT!!!!)
    If no, linked to Variable_Comparison_B.
    2.2. In Variable_Comparison_B, check whether the current
    iterator var is 1
    If yes, linked to File_Wait_B - where we detect a not existing
    file, but link to nothing.
    If no, linked to the End Iterator.
    3. Link End Iterator to File_Write_SUCCESS operator on the
    success output port.
    4. Link End Iterator to File_Write_FAIL operator on the fail
    output port.
    
    Expected result: File_Wait_B failed, and break the iterator
    loop. Finally the logic went to the File_Write_Fail.
    Actual result: File_Wait_B failed but marked the iterator as
    successful. Finally the logic went to the File_Write_Success.
    

Local fix

  • Workaround : None.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All.                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SOMETIMES THE FAILURE OF A BRANCH UNIT INSIDE ITERATOR       *
    * OPERATOR                                                     *
    * DID NOT BREAK THE ITERATOR LOOP EXPECTEDLY                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to fix pack 9.7.7.                                   *
    ****************************************************************
    

Problem conclusion

  • Steps to reproduce:
    1. Put an iterator operator (from 0 to 3).
    2. Inside the iterator,
    2.1. Firstly check whether the current iterator var is 0
    (Variable_Comparison_A).
    If yes, linked to File_Wait_A - where we detect a not existing
    file. And link to a Continue operator on the failure output port
    If no, linked to Variable_Comparison_B.
    2.2. In Variable_Comparison_B, check whether the current
    iterator var is 1
    If yes, linked to File_Wait_B - where we detect a not existing
    file, but link to nothing.
    If not, linked to the End Iterator.
    3. Link End Iterator to File_Write_SUCCESS operator on the
    success output port.
    4. Link End Iterator to File_Write_FAIL operator on the fail
    output port.
    
    Expected result: File_Wait_B failed, and break the iterator
    loop. Finally the logic went to the File_Write_Fail.
    Actual result: File_Wait_B failed but marked the iterator as
    successful. Finally the logic went to the File_Write_Success.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PJ40424

  • Reported component name

    DWE SQL WHSE TO

  • Reported component ID

    5724DWESQ

  • Reported release

    973

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-18

  • Closed date

    2012-11-13

  • Last modified date

    2012-11-13

  • 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

    DWE SQL WHSE TO

  • Fixed component ID

    5724DWESQ

Applicable component levels

  • R973 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Warehouse
DWE - SQL Warehousing Tool

Software version:

973

Reference #:

PJ40424

Modified date:

2012-11-13

Translate my page

Machine Translation

Content navigation