DSXchange

Posted: **Sun Mar 20, 2011 11:16 pm**

Hi

I have all the columns non -nullable throughout the job .and they are set as nullable No through out
still I am getting this warning..
Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.

This warning is generated for an aggregrator stage..

can any one explain why..

Posted: **Mon Mar 21, 2011 1:10 am**

Hi,

Could You please explain wat function that you using in Aggregator stage

Thanks,
Manoj

Posted: **Mon Mar 21, 2011 1:13 am**

I am using a simple sum function ..adding salary of employees..

Posted: **Mon Mar 21, 2011 5:37 am**

Plese check in source any null value is there for salary field.

Posted: **Mon Mar 21, 2011 10:25 am**

One thing may works.Disable the RCP

Posted: **Mon Mar 21, 2011 10:57 am**

What is the source of your data? A sequential file? A database? Something else?

If it's a database, go ahead and insert a modify stage after the database stage and use the handle_null() function. This will ensure that the column is truly converted to a non-nullable status.

Regards,

DSXchange

Null handling warning generated :all columns are nonnullable

Null handling warning generated :all columns are nonnullable

Re: Null handling warning generated :all columns are nonnull