null handling error
Moderators: chulett, rschirm, roy
null handling error
hi all,
could any one please through some light to solve my problem:
error is:
Fatal Error: Null value on the accessor interfacing to field "XXX".
i checked source and target(xxx)fields length and nullable-yes options.
but still i am getting error.
please help me on this.
tx in advance.
could any one please through some light to solve my problem:
error is:
Fatal Error: Null value on the accessor interfacing to field "XXX".
i checked source and target(xxx)fields length and nullable-yes options.
but still i am getting error.
please help me on this.
tx in advance.
Thanx&Regards
scorpion
scorpion
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
Following are the error messages i am getting,when i run my job:
1)Transformer_145,0: Failure during execution of operator logic.
2)Transformer_145,0: Fatal Error: Null value on the accessor interfacing to field "xxx".
3)node_node1: Player 27 terminated unexpectedly.
This job basically extract the data from sybase tables and load the data into dataset,after looking up some sybase tables.
I am getting this error in one of the transformer stages.
In the transformer stage(Transformer_145) i am using derivation for one of the target field (yyy)like:
If IsNull(DSLink147.xxx) Or Trim(DSLink147.xxx) = "" Then "" Else (DSLink147.yyy)
for 'xxx' field,i am getting this error message.
Please help me on this.
thanks in advance.
Following are the error messages i am getting,when i run my job:
1)Transformer_145,0: Failure during execution of operator logic.
2)Transformer_145,0: Fatal Error: Null value on the accessor interfacing to field "xxx".
3)node_node1: Player 27 terminated unexpectedly.
This job basically extract the data from sybase tables and load the data into dataset,after looking up some sybase tables.
I am getting this error in one of the transformer stages.
In the transformer stage(Transformer_145) i am using derivation for one of the target field (yyy)like:
If IsNull(DSLink147.xxx) Or Trim(DSLink147.xxx) = "" Then "" Else (DSLink147.yyy)
for 'xxx' field,i am getting this error message.
Please help me on this.
thanks in advance.
Thanx&Regards
scorpion
scorpion
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you have any null values in your input column xxx?
This could be your problem if you have null values in your input column.
This could be your problem if you have null values in your input column.
Code: Select all
Trim(DSLink147.xxx)
You need to change your derivation to something like this:
You cannot trim a null value.
Code: Select all
If IsNull(DSLink147.xxx) then "" else if Trim(DSLink147.xxx) = "" then "" else DSLink147.yyy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: