Incomplete record read from file

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

Incomplete record read from file

Post by bala_135 »

Hi,

I am getting the following Error when i try investigating a word.

NV(608):9/9/2000 11:48:30 AM (MSG_vio.c:12; vio.c:1526) ERROR: Incomplete record read from file C:\Projects\WINNCRM\Data\CUSTOMER
INV(608):9/9/2000 11:48:30 AM (MSG_vio.c:13; vio.c:1528) ERROR: len=462, BufCnt=249, BufSize=102400, HaveCnt=249, readCnt=0, readRtn=0
INV(608):9/9/2000 11:48:30 AM (MSG_investc.c:83; investc.c:2443) ERROR: Unable to process investigation
INV(608):9/9/2000 11:48:30 AM (MSG_vutils.c:13; vutils.c:1287) ERROR: vexit status=25

I have tried the following
Checked the source file for any empty lines with spaces found none.
Anyting i need to do to solve this problem.

Regards,
Bala.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Check if you have any header record.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ashok
Participant
Posts: 43
Joined: Tue Jun 22, 2004 3:04 pm

Re: Incomplete record read from file

Post by ashok »

bala_135 wrote:Hi,

I am getting the following Error when i try investigating a word.

NV(608):9/9/2000 11:48:30 AM (MSG_vio.c:12; vio.c:1526) ERROR: Incomplete record read from file C:\Projects\WINNCRM\Data\CUSTOMER
INV(608):9/9/2000 11:48:30 AM (MSG_vio.c:13; vio.c:1528) ERROR: len=462, BufCnt=249, BufSize=102400, HaveCnt=249, readCnt=0, readRtn=0
INV(608):9/9/2000 11:48:30 AM (MSG_investc.c:83; investc.c:2443) ERROR: Unable to process investigation
INV(608):9/9/2000 11:48:30 AM (MSG_vutils.c:13; vutils.c:1287) ERROR: vexit status=25

I have tried the following
Checked the source file for any empty lines with spaces found none.
Anyting i need to do to solve this problem.

Regards,
Bala.
It might me the field lenght of data fields not consistent with the file you are trying to read in quality stage, check them in datafile definitions and it should solve this problem.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

This error message can also occur if the file has an empty line at the end. Search the forum; it has been discussed previously.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Alexander
Participant
Posts: 17
Joined: Fri May 12, 2006 10:10 am
Location: Europe

Re: Incomplete record read from file

Post by Alexander »

Hi,

You should check your file again, here is a bunch of questions a make when that happens in my jobs.
- Have you check every line len in your input file?
- Is the same len in QS file definition?
- In Windows every line have a carriage return at end. So you must have an empty line at the bottom of your file with no character in it. Is this true?
- Check your file for low-values. If exists one '00' in you file, your line will be cut in half during execution. Open the file in hex mode.

If I remember more i'll tell you.
vsi
Premium Member
Premium Member
Posts: 507
Joined: Wed Mar 15, 2006 1:44 pm

One of the reason

Post by vsi »

Hi guys
i got the same problem and resolved it by just entering a carriage return at the end of the last line.
Post Reply