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 ?
Want to suppress warnings for a job.
Moderators: chulett, rschirm, roy
Want to suppress warnings for a job.
Thanks with regards,
videsh.
videsh.
Re: Want to suppress warnings for a job.
Set APT_DISABLE_COMBINATION to Truevidesh77 wrote:
How can I be able to get rid of these warnings, with the identification of from which stage it has originated ?
Set Warning limit to No limit while running the job.,else you can use message handler!
RAJ
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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.
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.
Probal