Page 1 of 1
WARNING ::APT_CombinedOperatorController(0),0:
Posted: Thu Apr 23, 2009 2:09 am
by deesh
Hi Friends
Below warning is giving problem to my job can any one give suggestion
"""APT_CombinedOperatorController(0),0: Field 'MBPUIT' from input dataset '0' is NULL. Record dropped.""
but this field have data and lookup field also have data
Posted: Thu Apr 23, 2009 2:49 am
by ShaneMuir
Firstly I'd do a search here on APT_Combined. These errors are discussed at length.
Re: WARNING ::APT_CombinedOperatorController(0),0:
Posted: Thu Apr 23, 2009 2:54 am
by deesh
deesh wrote:Hi Friends
Below warning is giving problem to my job can any one give suggestion
"""APT_CombinedOperatorController(0),0: Field 'MBPUIT' from input dataset '0' is NULL. Record dropped.""
but this field have data and lookup field also have data
I given this condition in Transformer ===>If (LKP3_2_TR.MBPUIT)=2 Then LKP3_2_TR.MBLEA1 else ''
MBPUIT DECIMAL(1,0)
MBLEA1 DECIMAL(3,0)
Re: WARNING ::APT_CombinedOperatorController(0),0:
Posted: Thu Apr 23, 2009 4:02 am
by bart12872
deesh wrote:deesh wrote:Hi Friends
Below warning is giving problem to my job can any one give suggestion
"""APT_CombinedOperatorController(0),0: Field 'MBPUIT' from input dataset '0' is NULL. Record dropped.""
but this field have data and lookup field also have data
I given this condition in Transformer ===>If (LKP3_2_TR.MBPUIT)=2 Then LKP3_2_TR.MBLEA1 else ''
MBPUIT DECIMAL(1,0)
MBLEA1 DECIMAL(3,0)
LKP3_2_TR.MBPUIT is null, you must catch the exception. try
If IsNull(LKP3_2_TR.MBPUIT) Then SetNull() Else If (LKP3_2_TR.MBPUIT)=2 Then LKP3_2_TR.MBLEA1 else SetNull