DSXchange

Posted: **Wed Nov 23, 2011 5:33 pm**

Hi,

I am facing with the following warning when I try to run my job

Sequential_File_75,0: Field "Field008" has import error and no default value; data: {20 20 20 20 20 20 20 20}, at offset: 78

Looking at the log I can understand that there is an import error for field008,
can somebody explain how to fix this issue.

Regards

Kumar

Posted: **Wed Nov 23, 2011 5:51 pm**

Select the option Null field value = '' might work

DS User

Posted: **Wed Nov 23, 2011 5:51 pm**

What is the data type of "field008"? The hex data shows that there are 8 spaces in that field...

Posted: **Wed Nov 23, 2011 6:04 pm**

Hi,

I tried running the job with null field value = '' but still the warnings are coming.

The data type is integer(10)

Regards

Kumar

Posted: **Wed Nov 23, 2011 6:11 pm**

Is the first line in the file has column names?

Posted: **Wed Nov 23, 2011 6:12 pm**

Hi,

I did replace that field names with column names and defined first line as column names.

Regards

Kumar

Posted: **Wed Nov 23, 2011 6:14 pm**

So is it working now or still issue?

Posted: **Wed Nov 23, 2011 6:15 pm**

Still an issue.

Regards

kumar

Posted: **Wed Nov 23, 2011 7:53 pm**

The data type is integer but you have spaces. Spaces is not a valid integer.

DSXchange

Sequential File Import warning

Sequential File Import warning

Re: Sequential File Import warning

Re: Sequential File Import warning