Error message : Not enough memory for file map

[FoxEgg]

Error message : Not enough memory for file map !!!

I have XP Pro 2 GHz 384 RAM.... 80GB drive with 55G free

and i get this error at the end of this routine ... the procedure just tidies up data before getting the app to run definitively...


PROCEDURE CLEANUP

USE GC_DATAPATH+"patient0.dbf" ALIAS patient0 exclusive
SELECT patient0
PACK
USE

USE GC_DATAPATH+"patient1.dbf" ALIAS patient1 exclusive
SELECT patient1
PACK
USE

USE GC_DATAPATH+"patient2.dbf" ALIAS patient2 EXCLUSIVE
SELECT patient2
PACK
USE

RETURN

It is a problem because it hangs on the last PACK step and trashes the indexes

It is not a huge database 70000 record or so...

Can anyone spot my error or tip me off the correction..

Thanks


John Fox

 

[Mike Gagnon]

FoxEgg

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/err1150.asp

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

FoxEgg,

I can't see anything wrong with your code.

I suspect that this is not a memory problem. It is more likely to be some configuration issue, or perhaps even a bug in VFP.

Which version / service pack are you using?

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[FoxEgg]

McMike I am using VFP 7.0 SP1

MapleMike.. thanks for the reference which states...

Visual FoxPro Reference

Not enough memory for file map (Error 1150)
There is not enough memory for Visual FoxPro to allocate memory for a Visual FoxPro internal resource.

Available memory is extremely limited.
Add memory or remove memory-resident programs to give Visual FoxPro more working memory


I would have thought that I had enough memory
I cleared everything (at least everything obvious)

I ran one copy of Internet Explorer CODE WORKS
I ran two copies of Internet Explorer CODE WORKS
I ran three copies of Internet Explorer CODE CRASHES

Its a worry... that is not a lot of extra resource utilization.

I better read more about XP Pro and Memory

John Fox

 

[Mike Gagnon]

John

Bring it up to 512?



Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[AirCon]

John Fox

I ran one copy of Internet Explorer CODE WORKS
I ran two copies of Internet Explorer CODE WORKS
I ran three copies of Internet Explorer CODE CRASHES


To know how much memory allocated to VFP, look at sys(3050) each time you run IE

?sys(3050,1), sys(3050,2)

-- AirCon --

 

[AirCon]

Forgot one, also try to remove any unused program from startup

-- AirCon --

 

[Mike Lewis]

FoxEgg,

I just checked the Microsoft Knowledge Base. There is nothing there about this error as far as VFP 7.0 is concerned.

Have you tried reproducing the error on another computer?

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[Mike Gagnon]

Mike

I just checked the Microsoft Knowledge Base. There is nothing there about this error as far as VFP 7.0 is concerned.

I'm surprised that would say that, when the link I suggested is for VFP7.0.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Mike,

I'm surprised that would say that, when the link I suggested is for VFP7.0.

I think your link was to the VFP Help File. I checked the MS Knowledge Base, which is not the same thing.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[FoxEgg]

OK so moving right along here down in the Southern Hemisphere where it is Winter and Warm....and the Beer is COLD

I tried moving the app to another machine... It has more memory (again XPPro) BUT compare the differences,,,,


NEW M/c ORIGINAL Machine
Total Physical Memory 512 MB 384 MB
Available Physical Memory 319.56 MB 89.73 MB
Total Virtual Memory 1.72 GB 1.84 GB
Available Virtual Memory 1.21 GB 169.72 MB
Page File Space 1.22 GB 1.46 GB


I guess there is a message here... !!! But after all the same database would index and PACK on a Win98 Machine without need for 512MB


John

 

[FoxEgg]

EUREKA !!! I found the answer...

Answer = VALIDATE DATABASE

It fixed the 'memory' problem.

I am not sure how I stubled on this but while I was fiddling around the word 'VALIDATE' came to mind and after a bit of reading in the Help File.... and getting it to run... It now indexes without a problem with 5, 8 or 10 copies of IE running in the background...

Mike, I didn't need to buy 512M of memory, that leaves more money for wine ....


I also found this in my favourites: This expands on what AirCon was going on about.... very useful clue...

http://www.pinnaclepublishing.com/FT/FTmag.nsf/0/7AA27E67F86353B1852568E8007A53F1

Thanks to everyone


John Fox