JR44502: MULTIPLE LOOKUP TABLES ALLOW DUPLICATE ENTRIES

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• When a link is moved it retains the AllowDups setting, which is
  not easily reset from the GUI.
  There are some other issues with the decisions made about which
  link is used for the "Multiple rows returned from link:" setting
  in the Lookup Contraints dialog - we think that the first
  reference link with an AllowDups setting should be used, not the
  last one.
  i.e. if you add further reference links that had an AllowDups
  setting from a previous attachment, why would it change which
  link was used for this setting ?
  And the compiler should default to using any AllowDups setting
  from the first link with that setting (to match the GUI), and
  clear AllowDups from subsequent links.
  

Local fix

• The workaround the issue is to use an additional Lookup stage,
  so  each Lookup stage will have 1 reference link.
  
  Another workaround for this customer seems to be that if the
  "Multiple rows returned from link:" setting is cleared, the
  Stage closed,
  then re-opened and the correct link chosen (or left empty if
  that is what is required), then the AllowDups generated in Osh
  is correct.
  

Problem summary

• *************************************************************
  USERS AFFECTED:
  Users of PXLookup stages who have been chaning links
  between different Pxlookup stages and have corrupted their
  AllowMultiRow settings.
  *************************************************************
  PROBLEM DESCRIPTION:
  PxLookup stages with multiple input links incorrectly marked
  as AllowMultiRow result in incorrect Osh generated with
  multiple allow_dups options.
  *************************************************************
  RECOMMENDATION:
  Apply patch JR44502.
  *************************************************************
  

Problem conclusion

• Apply patch JR44502.
  To fix generated OSH for affected jobs, they must be recompiled.
  

Temporary fix

Comments

APAR Information

• 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

• R870 PSY

     UP