DSXchange

Hi folks,

Iam getting the warnigs,when I was trying to extract the data from the sequential file to Oracle table via copy stage.

the following are the warnigns:
1)FF_ECO_EXT_SRC_REJ,0: Data string 'WMI,7,MES028
2010-1' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.


2)FF_ECO_EXT_SRC_REJ,0: Field "PROCESS_DATE" delimiter not seen, at offset: 39

3)FF_ECO_EXT_SRC_REJ,0: Input buffer overrun at field "PROCESS_DATE"

4)FF_ECO_EXT_SRC_REJ,0: Data string 'TVV,8,MESO28
2010-1' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.

but I need to execute the job without warnings...

please help me if any one of you know.
Immediate help is more appreciable..

harivasireddy wrote: I need to execute the job without warnings...

That's easy enough. All you have to do is to prevent the warnings from being generated, by constructing your job design correctly.

For example, "WMI,7,MES028\n2010-1" is clearly not a date, but you have attempted to do some kind of date processing (or at least formatting) on this column.

It's also apparent that your data do not match your metadata.

These are the things you need to correct.

Starting two threads for a same problem won't speed up resolution of your problem.

Moreover if your previous post Unable to read the dataset is resolved then mark it as resolved with the solution implemented so that could be useful later for other guys as well, else respond to that.

Don't leave them unattended and incomplete.

Clearly there is , missing 'TVV,8,MESO28
2010-1'