a problem with the Run

aya_r · Post by **aya_r** » Fri Jun 01, 2007 2:52 am

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,

ray.wurlod · Post by **ray.wurlod** » Fri Jun 01, 2007 4:57 am

"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.

aya_r · Post by **aya_r** » Mon Jun 04, 2007 6:41 pm

Thanks ray, but I can't see any recoord that's short and there is no extra new line at the end. can you please advise if there is anything else I should look at .

Thank you.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 04, 2007 9:13 pm

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.

aya_r · Post by **aya_r** » Mon Jun 04, 2007 11:29 pm

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 .