Window XP Error Accessing File

[Juan Alonso]

Ok. Here is something new.

I am having a problem with very large tables.

The error I get is "File Read Error... Path and File Name".

I am performing a simple replace on a numeric field.

Eg.: Replace All "numeric field" with "Numeric Value"

I use VFP 8 Plus all service packs and hotfixes.

The table is about 23 million records.

I tryed it with several different commands.

Like Scan...Endscan, Do While !EOF()....EndDo, and of course the
above REPLACE ALL command.

They all give me the same problem after 999,5xx records.

I don't know why it gives me this problem. It id not do this when I created
the 23 million original records and I have not changed anything in this
table.

By the way.. the table contains every single combination you can play in the
Florida Lottery.

The fields are POS1, POS2, POS3, POS4, POS5, POS6, MACBALL, DESTINY

All fields are character type except MACBALL and DESTINY.

I am replacing MACBALL with
VAL(POS1)+VAL(POS2)+VAL(POS3)+VAL(POS4)+VAL(POS5)+VAL(POS6).

The record stays locked if I suspend.

I did notice that in a browse window the bahavior happens if I PageUP or
PageDown while holding the button so it goes fast.

Any Ideas??????

Anyone???

The file is 941 megs. in size.

The VFP Help on the error says the system gave me that problem.

I don't know what else to do.

My OS is Windows XP with all updates and service packs on a IBM NetVista
Computer.

Its a pritty nice PC, never gives me problems. Well until now.

But other than this happening it works fine with other programs I have
created and won't crash.

Ok.. let me know if you can figure something out.

Thank you all in advance,

Juan.

 

[LVTravel]

Ok. Here is something new.

I am having a problem with very large tables.

The error I get is "File Read Error... Path and File Name".

I am performing a simple replace on a numeric field.

Eg.: Replace All "numeric field" with "Numeric Value"

I use VFP 8 Plus all service packs and hotfixes.

The table is about 23 million records.

I tryed it with several different commands.

Like Scan...Endscan, Do While !EOF()....EndDo, and of course the
above REPLACE ALL command.

They all give me the same problem after 999,5xx records.

I don't know why it gives me this problem. It id not do this when I
created
the 23 million original records and I have not changed anything in this
table.

By the way.. the table contains every single combination you can play in
the
Florida Lottery.

The fields are POS1, POS2, POS3, POS4, POS5, POS6, MACBALL, DESTINY

All fields are character type except MACBALL and DESTINY.

I am replacing MACBALL with
VAL(POS1)+VAL(POS2)+VAL(POS3)+VAL(POS4)+VAL(POS5)+VAL(POS6).

The record stays locked if I suspend.

I did notice that in a browse window the bahavior happens if I PageUP or
PageDown while holding the button so it goes fast.

Any Ideas??????

Anyone???

The file is 941 megs. in size.

The VFP Help on the error says the system gave me that problem.

I don't know what else to do.

My OS is Windows XP with all updates and service packs on a IBM NetVista
Computer.

Its a pritty nice PC, never gives me problems. Well until now.

But other than this happening it works fine with other programs I have
created and won't crash.

Ok.. let me know if you can figure something out.

Thank you all in advance,

Juan.

What is the format type of the hard drive (FAT32 or NTFS)? If FAT 32 you
may be getting a file size limitation of 4 GB on the replace.

Do you have at least 4 times (my estimate) the free space on the hard drive
over what the file size is when it just sits on the hard drive (941 MB)?

What program are you using?

 

[Juan Alonso]

It is Widnows XP NTFS.

My free space is: 11.5 Gigs.

 

[Juan Alonso]

Ok .. this sucks..

Has anyone any kind of encounter with this.

I have tried this stupid file many different ways.

I even get an error moving the freakin through a normal copy command from
the command prompt and even get an error when I try a windows drag and drop.

I mean it just gives me a problem no matter what I do after I get the first
read error.

VFP reports its my OS.. my OS says its the file.. but yet, I created the
file using VFP append blank and replace and never had a problem while
creating it.

I don't know what else to do. I think there is a glitch in Window XP we
don't know about...

Any way, please if anyone has any clue..

Thanks in advance,

Juan.

 

[Twayne]

What size is the hard drive? We know you have 11.5 Gig free, but that
is occasionally a phoney number under some circumstances. Many things
can infringe on the amount of free space, especially with large drives.
e.g. Restore points, indexing and several others. Each one often wants
up to 10% of the drive for its sandboxen.

Is this XP Home or XP Pro?

You're always getting to about the same point when it errors out, so I
think at this point I'd find a way to get it onto a drive that has at
least 25% free space, in addition to say 5 Gig for the database
scratchers. Perhaps a backup or disk image is in order so you can clear
off a monstrous amount of space if you only have the one drive
available.
If nothing else, I would find a way to free up say at least 5 more
Gig and try running your dB again: See if the error point moves beyond
the current point where you're getting errors. If so, then it's
definitely a disk space problem.

Can you move the dB to another physical drive and try using it from
there? 900 Meg is large, but not so large it can't be copied reasonable
easily. BE SURE TO BACK IT UP IF YOU HAVEN'T ALREADY! TSing can cause
worse problems.

Since it's a dB, have you done a Compact on it recently? Even if it
automatically compacts, run a manul compact anyway. I know nothing of
WFP or how it works.

Any chance you know anyone with Ashton Tate's dBase II or IV? Can you
export it to a .dbf file? See if dBase can work with it. Be sure you
work on a copy, not the original.
Access is another possibility but it's incredibly slow IME.
Have you tried to re-index it?
Is it a relational database? Or flat? What kind of database is it?
If relational, how many tables? How many indexes?

When I have problems I suspec of file corruption:
You could have simple file corruption within the databse itself. Try
using the "rule of halves" on it. Crack it in half, into two
same-sized pieces. Does one piece have the problem but not the other
one? Then take the piece that has the problem and cut it in half again:
Find which half has the problema nd which doesn't; repeat. Repeat until
it gets down to a size that's easily manageable, or, if you have to,
until there's only one or two records left that could contain the
corruption.

I'm no guru by any means; these are just some things off the top of my
head dug from memory. Might now help any but I figured it can't hurt at
least.
If I were you I think I'd look for a forum/newsgroup for yor product.
AFAIK the numbers you give don't match any trouble-points in XP but I do
suspect it's "system" in nature and corruption is the most likely
culprit if that's so. Even if it's a proprietary database format and
can't export to .dbf etc., some of the above might still help.

HTH

Twayne

 

[Juan Alonso]

The OS is Windows XP Pro w/all service packs and hotfixes and updates.

The drive is 20gigs 11.5 is more than half of the drive of free space.

I can copy from the original DBF to the one I am going to manipulate as many
times as I want without having a problem.

I think the problem is when I am searching in the copy or when I am going
record by record replacing a field.

The problem has moved. Sometimes it will give me one record where it stops
and won't read any more and then another record.

Once I get the error, I can not browse the DBF or search in it or anything.
Won't let me use any DOS commands on it either. It will give me a read
problem.. like the CRC is not correct.

I thought it was my hard drive, but I have other programs and they don't
give me this kind of problem.

I am going to try and break the records up into shorter tables.

I will let you know how that went.

Thanks and sorry I don't have any more information other than what I already
have.

Juan.

 

[Juan Alonso]

Ok.. just for the record.

IT IS DEFFINATELY SOMETHING WRONG IN WINDOWS XP PRO.

I uninstalled VFP8 and used VFP9 and I get the same file error.

I guess MS is going to have to find this one out.

Later world.. back to slaving the fox..

Juan.

 

[Juan Alonso]

This problem was a VFP8 problem.

VFP9 can handle the table just fine.

Thank you all.