I have a project build on Vality, and I have migrated it to Quality stage, and I manged to deploy all the jobs successfuly, but when I tried to run the job in QS I got the following error
:/Projects/OMPDWCZ/Logs/OMUDCCCP.Step001.log:GTF(2740):1/06/2007 6:11:04 PM (MSG_vio.c:12; vio.c:1526) ERROR: Incomplete record read from file D:\Projects\OMPDWCZ\Data\OMCCB0NS
D:/Projects/OMPDWCZ/Logs/OMUDCCCP.Step001.log:GTF(2740):1/06/2007 6:11:04 PM (MSG_vio.c:13; vio.c:1528) ERROR: len=545, BufCnt=55, BufSize=102400, HaveCnt=55, readCnt=0, readRtn=0
D:/Projects/OMPDWCZ/Logs/OMUDCCCP.Step001.log:GTF(2740):1/06/2007 6:11:04 PM (MSG_vutils.c:13; vutils.c:1287) ERROR: vexit status=1
the following is all the contents for the log file, can any one please give me an idea where should I start with my investigation??
GTF(2740):06/01/07 18:11:04 LOG: $Build: (SINGLE)RELEASE gtf.exe_7_5_0_8_050218_12:43:58 $
GTF(2740):1/06/2007 6:11:04 PM LOG: Start
GTF(2740):1/06/2007 6:11:04 PM LOG: LOCALE is: English_Australia.1252
D:\Ascential\QualityStageServer75\GTF -i D:/Projects/OMPDWCZ/Data/OMCCB0NS -o D:/Projects/OMPDWCZ/Data/OMDCC100 -f D:/Projects/OMPDWCZ/Controls/OM0CC10G -E OMCCB0NS -O OMDCC100 -s 543 -S 550
GTF(2740):1/06/2007 6:11:04 PM LOG: LC_COLLATE is English_Australia.1252
============ reading ADP FIELDS FROM: OMCCB0NS ============
GTF(2740):1/06/2007 6:11:04 PM
GTF(2740):1/06/2007 6:11:04 PM LOG: ioOpenFile D:\Projects\OMPDWCZ\Data\OMCCB0NS(IORead)
GTF(2740):1/06/2007 6:11:04 PM LOG: file D:\Projects\OMPDWCZ\Data\OMCCB0NS open
GTF(2740):1/06/2007 6:11:04 PM LOG: Using BufSize = 102400, AllocSize = 102400, kind = 3, encoding = native for D:\Projects\OMPDWCZ\Data\OMCCB0NS
============ reading ADP FIELDS TO: OMDCC100 ============
GTF(2740):1/06/2007 6:11:04 PM
GTF(2740):1/06/2007 6:11:04 PM LOG: ioOpenFile D:\Projects\OMPDWCZ\Data\OMDCC100(IOWrite)
GTF(2740):1/06/2007 6:11:04 PM LOG: file D:\Projects\OMPDWCZ\Data\OMDCC100 open
GTF(2740):1/06/2007 6:11:04 PM LOG: Using BufSize = 102400, AllocSize = 102400, kind = 3, encoding = native for D:\Projects\OMPDWCZ\Data\OMDCC100
GTF(2740):1/06/2007 6:11:04 PM LOG: input record size is 545, output record size is 552
GTF(2740):1/06/2007 6:11:04 PM LOG: process 3 commands
GTF(2740):1/06/2007 6:11:04 PM (MSG_vio.c:12; vio.c:1526) ERROR: Incomplete record read from file D:\Projects\OMPDWCZ\Data\OMCCB0NS
GTF(2740):1/06/2007 6:11:04 PM (MSG_vio.c:13; vio.c:1528) ERROR: len=545, BufCnt=55, BufSize=102400, HaveCnt=55, readCnt=0, readRtn=0
GTF(2740):1/06/2007 6:11:04 PM LOG: 7167 RECORDS READ
GTF(2740):1/06/2007 6:11:04 PM LOG: 7167 RECORDS WRITTEN
GTF(2740):1/06/2007 6:11:04 PM (MSG_vutils.c:13; vutils.c:1287) ERROR: vexit status=1
GTF(2740):1/06/2007 6:11:04 PM LOG: End
Thanks,
a problem with the Run
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"Incomplete record read from file" suggests that at least one record in the file was short. Perhaps you have an extra newline at the end, because the job read and wrote the same number of records.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could check for short records in D:\Projects\OMPDWCZ\Data\OMCCB0NS with a DataStage job that reads each row as a single string and reports its length. "Eyeballing" doesn't always work, it can be confused by tabs and non-printing characters.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I don't have datastage installed on my PC and I have never used Data stage . the way how I knew that there is no short record is by using UltraEdit and show the spaces and tabs, so that would show me if there is any record shorter.. also I'm only running the job for the files with 3 records .. just to minimize the the number of records I'm looking at .