IBM Support

JR61578: DATARULES FAIL WHEN RULE LOGIC INVOLVES JOINS AND VIRTUAL TABLES ARE ON THE RIGHT SIDE OF THE JOIN.

 

APAR status

  • Closed as program error.

Error description

  • below are the scenarios where data rule is failing
    
        data rule involving 6 joins where only on VT (normal) is
    involved , VT doesnt have base tables in the rule
    
    changing position to left helps them
    
    2 data rule where advanced user defined tables are involved not
    VT here rule never works  but throws same  error
    
    advance userdefined tables are generated using rules where
    only single VT is involved
    

Local fix

  • debug jar
    

Problem summary

  • Data Rules fail when joining with virtual tables
    

Problem conclusion

  • Fixed in 1171 FP1
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR61578

  • Reported component name

    WIS INFORM ANAL

  • Reported component ID

    5724Q36IA

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-08

  • Closed date

    2020-03-26

  • Last modified date

    2020-03-26

  • 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 INFORM ANAL

  • Fixed component ID

    5724Q36IA

Applicable component levels

  • RB71 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50"}]

Document Information

Modified date:
15 October 2021