IBM Support

JR31960: PROBLEM WITH IS 8.0.1 AIX LOOKUP STAGE NULL HANDLING

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Incorrect warning EXAMPLE: When binding input interface field
    "FIELD"
    to field "FIELD": Converting a nullable source to a non-nullable
    result; a fatal runtime error could occur;
    use a modify operator to specify the value to which the null
    should be converted.
    
    This warning is wrong because the field definition in the lookup
    stage is nullable on both sides (input and output). It seems
    that the error results from the Lookup-stream where the matched
    field is defined NOT
    NULL
    

Local fix

  • This fix is included in 8.0.1 fixpack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users of parallel lookup in any version of IS
    ****************************************************************
    PROBLEM DESCRIPTION:
    by the user when an input key column in  nullable and the
    matching lookup key column is not.
    ****************************************************************
    RECOMMENDATION:
    Install patch JR31960
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • Fixed lookup to handle this correctly as there should be no
    warning in this case.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31960

  • Reported component name

    INFO SRVR PLATF

  • Reported component ID

    5724Q3612

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-02-10

  • Closed date

    2009-03-12

  • Last modified date

    2010-12-09

  • 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 PLATF

  • Fixed component ID

    5724Q3612

Applicable component levels

  • R801 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 December 2010