Import Error while reading a tab delimited text file

vimali balakrishnan · Fri Sep 15, 2006 11:50 am

We have developed a parallel job to load a tab delimited text file to an oracle table.There are few numeric columns in the text file with null values.

Due to this the file is not getting loaded to the database.The following are the warnings we get,

Seq_Pbip_Line_Utl_Dtl,0: Field "LINE_UTL_IN_PER" has import error and no default value; data: <empty>, at offset: 89

Seq_Pbip_Line_Utl_Dtl,0: Import warning at record 172.

Seq_Pbip_Line_Utl_Dtl,0: Import unsuccessful at record 172.

Could you please help us out in resolving this issue ?

thumsup9 · Post by **thumsup9** » Fri Sep 15, 2006 1:27 pm

In the format tab of the Oracle Stage and under Field Defaults property and set the Null field value property to the default you want. You have to handle nullable fields.

vimali balakrishnan · Post by **vimali balakrishnan** » Fri Sep 15, 2006 2:23 pm

I tried setting default values for the null fields,but still the same error.

thumsup9 · Post by **thumsup9** » Fri Sep 15, 2006 2:32 pm

Did you set the same on the source side too. It shows import error. Whats the NullFieldvalue you set on the source side..can you set this to \1 and check what happens...

vimali balakrishnan · Post by **vimali balakrishnan** » Fri Sep 15, 2006 2:48 pm

I tried that too..but still the same error...

ray.wurlod · Post by **ray.wurlod** » Fri Sep 15, 2006 5:25 pm

It seems likely that you have been insufficiently diligent in accurately setting null field values. You have an empty field at column position 90 (the figure 89 is zero-based numbering) which is the field LINE_UTL_IN_PER; has this field's Null Field Value property been set to ""? Can you see the NULL when you View Data (set skip to 170 and rows to 5 in View Data)?