Sequential File Import warning

phanikumar · Post by **phanikumar** » 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

SURA · Post by **SURA** » Wed Nov 23, 2011 5:51 pm

Select the option Null field value = '' might work

DS User

chulett · Post by **chulett** » 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...

phanikumar · Post by **phanikumar** » 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

karthikdsexchange · Post by **karthikdsexchange** » Wed Nov 23, 2011 6:11 pm

Is the first line in the file has column names?

phanikumar · Post by **phanikumar** » 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

karthikdsexchange · Post by **karthikdsexchange** » Wed Nov 23, 2011 6:14 pm

So is it working now or still issue?

phanikumar · Post by **phanikumar** » Wed Nov 23, 2011 6:15 pm

Still an issue.

Regards

kumar

ray.wurlod · Post by **ray.wurlod** » 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