DSXchange

Hello,

I'm trying to execute a very simple job :
OCI oracle ->transformer -> sort -> OCI Oracle
But during the execution, the process returned a very weird error :
"Null value on accessor interfacing to field"
i was thinking that DS PX was able to handle itself the "null" value for the sort stage, so i'm wondering where this error came from ?

thanks in advance

Chanthou

One place you can get into problems with null fields is within the Transformer. Find out what source field has nulls in it and then add null handling for that field (such as NullToValue) in the Transformer. Do not try to use that field in any derivation function until it has been null handled.

chanthou_2000 wrote: i was thinking that DS PX was able to handle itself the "null" value for the sort stage, so i'm wondering where this error came from ?

If you were the Sort stage, how would you handle null? Can you be more specific about how you think that the Sort stage can handle null?

don't know if this is relevant in your case, but I got this error in a different situation:
I've created a lookupfile with a field as nullable. When reading from this file the field was set to non-nullable, and I got this error from the lookup-stage.
So : maybe it's just mismatch in column-definition between stages.

Just Try out by null handling with the nullable YES input fields.

Source : Nullable YES
If Isnull(ColumnA)
then ' ' or 0 (depends on your requirement, usually for sting Spaces and for numeric 0)
Else
ColumnA.

Target : Nullable ( Yes/No)