Error : Null handling done on not nullable column

srinivas.nettalam · Post by **srinivas.nettalam** » Wed May 04, 2011 12:16 am

I have a lookup stage and I am pulling a flag that has value 'Y', from the reference and checking for NULLs for that field in the constraint of the transformer following lookup.
I am using IsNull(Flag) in the constraint.I am getting the error "Null Handling done on not nullable field" but in the output link of lookup stage that Flag column is set to NULL (yes).
Please suggest on this

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 1:06 am

Defined as not nullable on the reference input to the Lookup stage?

srinivas.nettalam · Post by **srinivas.nettalam** » Wed May 04, 2011 3:42 am

ray.wurlod wrote:Defined as not nullable on the reference input to the Lookup stage? ...

Yes Ray,but I wonder how does it matter to transformer..??

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 4:58 am

If you are on a version earlier than 8.5 it matters hugely to the Transformer stage - all functions in the Transformer stage other than the null-handling functions are intolerant of null.

srinivas.nettalam · Post by **srinivas.nettalam** » Wed May 04, 2011 5:44 am

ray.wurlod wrote:If you are on a version earlier than 8.5 it matters hugely to the Transformer stage - all functions in the Transformer stage other than the null-handling functions are intolerant of null. ...

I am confused, as I have been thinking that tranformer checks the field for nulls only on the output link of lookup/transformer's input link but I don't know that transformer checks for the input link of lookup stage as well.

greggknight · Post by **greggknight** » Wed May 04, 2011 7:50 am

First I am assuming that you are checking for nulls to determine if the lookup stage did not find a match.
If thats the case then put an output file off from the lookup stage and set the properties so that if a match is not found the record goes there otherwise the record goes through with the flag as 'Y'

Avoid transformation stages unless you really need to use them. They are the most costly object in PX as far as resources .......

chandra.shekhar@tcs.com · Wed May 04, 2011 7:56 am

Whats ur target stage?
Seq File or Database

jwiles · Post by **jwiles** » Wed May 04, 2011 8:22 am

Ur is an ancient middle-eastern city and currently has no target. The target stage is irrelevant to the problem at hand.

The transformer is not checking the nullability of the column on the input to the lookup stage...it is incapable of doing that.

More than likely, what is happening is the non-nullability of the column is being retained on output from the lookup stage. Make the flag column nullable on the input link to the transformer. You may need to insert a modify stage before the lookup with the make_null function to ensure that the nullable property is correctly set. For example:

Code: Select all

Flag = make_null(Flag,'N')

Regards,

chulett · Post by **chulett** » Wed May 04, 2011 9:19 am

jwiles wrote:Ur is an ancient middle-eastern city

Ray... is that you?

jwiles · Post by **jwiles** » Wed May 04, 2011 9:27 am

Oh no...don't tell me I'm channeling him!

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 3:35 pm