IBM Support

JR30793: WHEN FAST TRACK HAS LOOKUP DEFINITION WITH TWO SOURCE TABLES ANDONE LOOKUP TABLE WIHT MULTIPLE KEYS, JOB WILL NOT COMPILE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When the lookup definition has two source tables and one lookup
    table. The lookup join key definition involves both source
    tables. One of the key definition carries multiple key
    columns will cause job not to be compiled.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Any FastTrack Server component on any environment will have the
    issue with lookup tables that are joined with 2 or more sources.
    ****************************************************************
    PROBLEM DESCRIPTION:
    Generated job that has at minimum a binary join between 2
    sources and a lookup that involves both sources and
    an additional lookup source result in wrong transformation
    functions.
    ****************************************************************
    RECOMMENDATION:
    Apply patch JR30793.
    Fixed in Information Server 81 FP1.
    ****************************************************************
    

Problem conclusion

  • Problem was fixed within DS Job generation code that prevents
    the described defect and creates the correct transformations
    after the lookup container. Columns can be mapped from 1or more
    sources and additionally with one or more columns from the
    lookup table.
    Fixed in Information Server 81 FP1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30793

  • Reported component name

    INFO SRVR FASTT

  • Reported component ID

    5724Q36FT

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-10-16

  • Closed date

    2008-11-01

  • Last modified date

    2009-12-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • SERVER
    

Fix information

  • Fixed component name

    INFO SRVR FASTT

  • Fixed component ID

    5724Q36FT

Applicable component levels

  • R801 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSX3EG","label":"InfoSphere FastTrack"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 December 2009