JR37243: In Information Server 8.1, Error "KEY FIELD xxxx WAS NOT FOUND I THE INPUT SCHEMA" occurs in job with transformer and repartion.

APAR status

• Closed as program error.

Error description

• Error when checking operator: Key field "Z_MAP_CHARTFLD_5" was
  not found in the input schema".
  
  job with symptom below failed with the error:
  
  1. key field defined as nullable before transtormer;
  2.. using IsNull function to handle nullable key field in
  transformer;
  3. repartition occurred before/after transformer.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IS DataStage 8.1FP1
  ****************************************************************
  PROBLEM DESCRIPTION:
  The error occurs if the sorted merge collector is inserted by
  the parallel engine in front of an operator that has an adapter
  for one or more of the fields that are used as a key field for
  the sort.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR37243.
  ****************************************************************
  

Problem conclusion

• Fixed sort merge collector to get the concrete schema that
  contains the original input fields which make up the keys to the
  sort.
  

Temporary fix

• 1. use same partition type before and after transformer;
  2. run the job in single node mode.
  

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

• R810 PSN

     UP