WARNING ::APT_CombinedOperatorController(0),0:

[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

[ShaneMuir]

Firstly I'd do a search here on APT_Combined. These errors are discussed at length.

[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

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)

[bart12872]

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