odbcPopulate,1: Fatal Error: Null value on the accessor inte

sri_vin · Post by **sri_vin** » Tue Mar 15, 2011 9:22 pm

Hi

I have field contract_beneficiary_nomination_comment that has data type varchar and length 8000. I set this field to "NULL" using setnull() function.

When i run the job, I am getting following error.

Can anyone help me?

If I assign a blank instead of null then it works fine.

Thanks
Sri

ray.wurlod · Post by **ray.wurlod** » Tue Mar 15, 2011 10:04 pm

Can you please show the full error? It was truncated when you used it as your subject line.

sri_vin · Post by **sri_vin** » Tue Mar 15, 2011 10:46 pm

The error is

odbcPopulate,0: Fatal Error: Null value on the accessor interfacing to field "contract_beneficiary_nomination_comment".

ray.wurlod · Post by **ray.wurlod** » Tue Mar 15, 2011 11:16 pm

The message suggests that, on the output link, column contract_beneficiary_nomination_comment is marked not nullable. The error occurs when you try to pass a null to it.