Fatal error

[hargun]

Hi,

i am getting the follwoing error.
I had check the null and it is not null in target and source but still i am getting this error.


APT_CombinedOperatorController,0: Null in field "JOB_BATCH_GK "; the result is non-nullable
and there is no handle_null to specify a default value. [api/interface_rep.C:1823]


i have also used IF isnull else even then getting the same error.
My job design


db2 connector
,
,
file,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,lookup,,,,,,,,,,,,,,,,,,,,xfm,,,,,,,,,,,db2 connector

[synsog]

If lookup fails, I think you kept to Continue. Then if the field "JOB_BATCH_GK" is non-nullalbe, then obvisouly for the lookup failed records, "nothing" will carry to transformer stage. So.. in the after part of the Lookup... make JOB_BATCH_GK Nullable and handle in the transformer.