DSXchange

Hi

After job execution, we are getting following warnings -

APT_CombinedOperatorController,3: Field '<fieldname>' from input dataset '0' is NULL. Record dropped.


In my job I have following sequence -

Db2 EE Stage -> Transformer -> Seq File

As the number of logs exceed the view limit, there is no indication which stage is raising these warnings.

How can I be able to get rid of these warnings, with the identification of from which stage it has originated ?

videsh77 wrote:

How can I be able to get rid of these warnings, with the identification of from which stage it has originated ?

Set APT_DISABLE_COMBINATION to True

Set Warning limit to No limit while running the job.,else you can use message handler!

My guess - it is coming from the transformer.

Handle nulls properly to avoid the warning. Never suppress them.

This is definitely because of the lack of the proper null handling in the transformer stage.go to the transformer stage , in the column metadata and double click on the column number,a new windows pops out where you can set the null field value.

ideally these should be done for all the columns having nullibility='yes'.

or you can use reject link from the transformer to catch the null values.

I have handled the nulls after retrieved from the database. While running a select, whichever columns were nullable, I have applies coalesce (db2 function) & replaced it with a space.
This suppressed the warning we received.

Thanks all for your valuable comments.

Are you aware of how you could have handled them in the job itself?