Page 1 of 1
Oracle error - input dataset '0' is NULL
Posted: Fri Jun 30, 2006 1:13 am
by sudhakar_viswa
Hi,
I am getting the Following error while processing data from oracle to oracle.
APT_CombinedOperatorController,0: Field 'UDF_057' from input dataset '0' is NULL. Record dropped.
The column name is UDF_057
It contains NULL value.And Nullable option is Yes.
Thanks,
sudhakar
Posted: Fri Jun 30, 2006 1:24 am
by ray.wurlod
Not a particularly useful subject line for future Search users!
Make sure that Field 'UDF_057' from input dataset is nullable everywhere it is used - including downstream operator(s) that might be combined with the one that generated the warning.
Set APT_DISABLE_COMBINATION to True to find out exactly where the null value is being dropped; you are almost certain to find a Not Null specification thereabouts.
Use reject-handling links wherever possible to trap rows that do not conform to the main link's record schema.
Posted: Sat Jul 01, 2006 12:59 am
by kris007
If you are using any transformation functions on these nullable fields make sure you check for Nulls before you perform
Code: Select all
e.g. If IsNull(Col1) then SetNull() Else Trim(Col1).
HTH
Posted: Thu Jun 07, 2007 8:38 am
by DS_MJ
Hello:
I am getting the same error. The Job Flow is as follows:
Code: Select all
DB2
|
\|/
Lookup --------->Transformer -------->MSSQL Tbl
/|\ |
| Agg
| |
|
Dataset(s) Dataset
Verified:
On the Metatable Table COL_DT is Type = Date, Length = 10 and Nullable = Y.
My source Table for COL_DT Type = Date, Length = 10 and Nullable = Y.
When I look at the data in source table for COL_DT there are some blank rows.
My Target Table for COL_DT is Type = Timestamp, Length = 23 Scale = 3, Nullable = Y.
In the transformer I am using DatetoString to convert the Date to Timestamp.
Code: Select all
DateToString(Opportunity_Product_lkp.COL_DT,"%yyyy-%mm-%dd"):' 00:00:00.000'
When I run this job get the following error.
Code: Select all
APT_CombinedOperatorController,1: Field 'COL_DT' from input dataset '0' is NULL. Record dropped.
So I try to resolve the Null Issue first using the following code:
Code: Select all
If IsNull(Opportunity_Product_lkp.COL_DT) then SetNull() Else DateToString(Opportunity_Product_lkp.COL_DT,"%yyyy-%mm-%dd"):' 00:00:00.000'
The job aborts with:
Code: Select all
Transformer_stage,1: Failure during execution of operator logic.
Would appreciate a guiding hand with this error.
Posted: Thu Jun 07, 2007 8:41 am
by samsuf2002
Try this
If IsNull(Col1)= 1 then SetNull() Else Trim(Col1).
Posted: Thu Jun 07, 2007 8:51 am
by DS_MJ
samsuf2002 wrote:Try this
If IsNull(Col1)= 1 then SetNull() Else Trim(Col1).
Hello samsuf2002:
Thanks for your quick response. I tried the following:
If IsNull(Opportunity_Product_lkp.COL_DT) = 1 then SetNull() Else Trim(DateToString(Opportunity_Product_lkp.COL_DT,"%yyyy-%mm-%dd"):' 00:00:00.000')
The job aborts and gives
Code: Select all
Transofrmer_stage_trn,0: Failure during execution of operator logic.
Posted: Thu Jun 07, 2007 8:59 am
by samsuf2002
Are you getting any warnings ? Can you send me your date format ,is it a date or time stamp field?
Posted: Thu Jun 07, 2007 9:32 am
by DS_MJ
samsuf2002 wrote:Are you getting any warnings ? Can you send me your date format ,is it a date or time stamp field?
My source Table for COL_DT Type = Date, Length = 10 and Nullable = Y.
My Target Table for COL_DT is Type = Timestamp, Length = 23 Scale = 3, Nullable = Y.
I am doing DateToString conversion.
Yes I am getting warnings see above I have pasted the warnings.
Posted: Thu Jun 07, 2007 12:44 pm
by asorrell
Ray - I modified the original topic to be a bit more descriptive (per your comment above). Apparently the thread is still active...