Problem in output file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
wuruima
Participant
Posts: 65
Joined: Mon Nov 04, 2013 10:15 pm

Problem in output file

Post by wuruima »

Dear all,
How are you!
Our DS job output a file contains a strange record!
This is the output file detail:
1VAA,29660,VN05020642,29660,300073,65011,IFRS,2141200001,,USD,1463347,1VA,*ITL XLN143429999TDG 042,001,AL,1VA,3260,300073,65011,,FN, 00005436495060.000000, 00000000000000.000000, 00005436495060.000000, 00005436495060.000000, 00005436495060.000000, 00007070497664.000000
0,-00000443375760.000000,-00000017814205.000000
1VAA,29660,VN05040001,29660,500017,65011,IFRS,6021110001,,EUR,1463347,1VA,*ITL FWD142559993WSH 921,001,AL,ALR,3260,500017,65011,,FN,-00019928603794.000000, 00000000000000.000000,-00019928603794.000000,-00019928603794.000000,-00019928603794.000000,-00006614292004.000000
You can see that the second record is not correct, some characters are 'cut', all other records in the file are normal.
Any one has experience on this problem? Any hint to resolve this problem?

We simply rerun the job , the output file resume normal, what's the problem?
wuruimao
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's impossible to tell from what you've provided. It might be a glitch in your I/O subsystem, maybe a badspot on the disk. Can you reproduce it? What precisely do you mean by "cut"?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
wuruima
Participant
Posts: 65
Joined: Mon Nov 04, 2013 10:15 pm

Post by wuruima »

ray.wurlod wrote:It's impossible to tell from what you've provided. It might be a glitch in your I/O subsystem, maybe a badspot on the disk. Can you reproduce it? What precisely do you mean by "cut"? ...
Hi Ray,

Please refer to below detail. I didn't change anything, just rerun the job, but the result are not the same. I cannot sync the error again.

This is the first run, the second line was incorrect.
1VAA,29660,VN05020102,29660,500017,65011,IFRS,1121120001,,USD,1463347,1VA,*ITL FWD142239997FEX 002,001,AL,ALR,3260,500017,65011,,FN, 00000443375760.000000, 00000000000000.000000, 00000443375760.000000, 00000443375760.000000, 00000443375760.000000, 00000017814205.000000
0,-00000443375760.000000,-00000017814205.000000

This is the second run, the record is correct now.
1VAA,29660,VN05020102,29660,500017,65011,IFRS,1121120001,,USD,1463347,1VA,*ITL FWD142239997FEX 002,001,AL,ALR,3260,500017,65011,,FN, 00000443375760.000000, 00000000000000.000000, 00000443375760.000000, 00000443375760.000000, 00000443375760.000000, 00000017814205.000000
1VAA,29660,VN05040001,29660,500017,65011,IFRS,2054120001,,USD,1463347,1VA,*ITL FWD142239997WSH 921,001,AL,ALR,3260,500017,65011,,FN,-00000443375760.000000, 00000000000000.000000,-00000443375760.000000,-00000443375760.000000,-00000443375760.000000,-00000017814205.000000
wuruimao
Post Reply