Oracle error - input dataset '0' is NULL

[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

[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.

[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

[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.

[samsuf2002]

Try this

If IsNull(Col1)= 1 then SetNull() Else Trim(Col1).

[DS_MJ]

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.

[samsuf2002]

Are you getting any warnings ? Can you send me your date format ,is it a date or time stamp field?

[DS_MJ]

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.

[asorrell]

Ray - I modified the original topic to be a bit more descriptive (per your comment above). Apparently the thread is still active...