JR41455: A virtual column used in an outer join or in a in_reference_column test leads to a job failure

APAR status

• Closed as program error.

Error description

• Rule execution fails with an invalid datetime format error if
  non-nullable timestamp columns are in a joined table such that
  the join returns null values. A similar failure occurs if a
  virtual column is used in an outer join or in an
  in_reference_column test.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Information Analyzer 8.5 and 8.7 users of Data Rules.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Rule execution fails  with an invalid datetime format error if
  non-nullable timestamp columns are in a joined table such that
  the join returns null values
  ****************************************************************
  RECOMMENDATION:
  Upgrade to Information Analyzer 8.5 Rollup Patch 6, or 8.7
  Rollup Patch 1.
  ****************************************************************
  

Problem conclusion

• Code was changed to detect if non-nullable columns were involved
  in an outer join of the data rule, and if so the generated osh
  is changed to nullable data types.
  

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

• Fixed component ID

  5724Q36IA

Applicable component levels

• R850 PSY

     UP

• R870 PSY

     UP