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 number
JR37243
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-07-19
Closed date
2010-08-16
Last modified date
2011-06-12
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 June 2011