Can't open one particular .DBF

[TheBlainer]

Hi,
I have one weird problem now and that's that I can't open the file having the name choixass.dbf (it was working fine before)

To see the errors I have see :

http://www.freeimagehosting.net/0f626

If I rename the file any other name like why_error.dbf, I can open it. But this particular name cause errors. Hopefully, I can use it in my application without no problem (insert,update and delete reccord,etc), but I can't just open it. I cleared my temp folder and restart my computer to be sure that it's not open somewhere, but with no success.

So if anyone had this kind of error before and fixed it. It would be nice to tell me how you did it.

Thanks

TheBlainer

 

[Mike Lewis]

Well, there's nothing special about that particular name. I just created a table with that name and it worked OK.

It could be some sort of corruption in the directory entry. It might be worth deleting the file and then re-creating it. Can't think of anything else off-hand.

By the way, you've got to admire the FoxPro team for coming up with the message "Fatal error 182 while attempting to report error 182".

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[TheBlainer]

I have created this table there's few months and there was no problem with it. But today, for no reason it gives me this.

Where I work, this file is copied on any computer, so my supervisor who has the same file and was able to open it copied it on my computer, and I deleted my choixass.dbf before he did that. So now I should have a non-corrupted file, but I still can't open the file!

This file must be opened somewhere and causing me troubles.

TheBlainer

 

[Mike Lewis]

If the file is open somewhere else, that would give a simple "File is in use" error (asuming you are trying to open it exclusively). It wouldn't cause the messages you saw.

Also, if has been working for several months and only stopped working today, you have to ask yourself what has changed. As you know, thngs don't happen at random. Something must have changed in your system or environment that caused this behaviour. If you can figure out what that is, you will have solved the problem.

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[TheBlainer]

i will try to figure what would have I changed to cause that.

Thanks Mike for your help.

TheBlainer

 

[JRB-Bldr]

This file must be opened somewhere and causing me troubles.

I use a tool called WhoHasNT (

http://www.gadgetfactory.com/whohasnt.shtml

) which allows me to see who has any file in use.

That allows me to run-down these types of problems.

Good Luck,
JRB-Bldr

 

[CEMrob]

I note from your error messages that as well as the "error 182 while reporting 182" you got an "insufficient memory" message. The problem may be some sort of memory leak or stack issue, rather than a straightforward coding problem. (Though admittedly you have restarted your machine which usually cures that). Are you running any other Apps at the same time?

You might also look at

http://kbalertz.com/315064/Fatal-Exception-Error-ResetToDefault-Empty-Method.aspx

(Presumably, once you can fix the Error 182, VFP will be able to report that you are experiencing an Error 182 )

Rob

 

[Mike Lewis]

Rob,

You might possibly be right about the memory leak, but in my experience, when VFP says there is insufficient memory, it often means that the problem is anything but insufficient memory.

Still, it's worth keeping it in mind.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[DSummZZZ]

There's a good chance that you have a .tmp file laying around somewhere that fox sees. See if cleaning up .tmp files - and also, any .dbf or .cdx files that have random generated file names. Like, 12345678.dbf or such.
That scenario has caused me issues in the past.



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[Dan Freeman]

in my experience, when VFP says there is insufficient memory

Yep. In fact, in one specific circumstance that exact error message means there's TOO MUCH memory.

 

[TheBlainer]

You were right DSummZZZ about the .tmp file hidden somewhere.

Because what I have done is that I uninstalled Visual FoxPro and reinstalled it right away. But it did nothing.
So I uninstalled it once again and went to the appdata/roaming and appdata/local and deleted all directory and files associated with FoxPro. After, I reinstalled FoxPro again and I was able to open the file!!! Hourray!

Buuuuuut, when I closed it and opened it again after to show to my collegues that my problem was gone, the errors were back!!!! (arrrrrrg)

So now I'm a bit angry and I really don't know what to do.

TheBlainer

 

[Olaf Doschke]

I actually have seen the out of memory error in case of insufficent memory more than not, but I don't disagree, though. I also know the case of legacy fopro having the problem with too much RAM and too fast CPUs.

Off topic: One case where you actually can get a low memory issue even though of plenty of RAM and disk space is when reindexing with a too low setting of SYS(3050), I remember a case where sys(3050,1,0x7FFFFFFF) solved enabling a reindex on a very large dbf, in that case it was even a binary index, which is small by itself, nevertheless vfp choked on it, and retried repeatedly to reindex, not extending the allocated memory during that operation.

Bye, Olaf.

 

[Olaf Doschke]

PS: I can reproduce the reindexing problem, but it will just loop endlessly, not giving any error, so that's surely not related to the problem.

Bye, Olaf.

 

[Dan Freeman]

Your experience uninstalling (and deleting files) points to something environmental here.

Mike asked earlier: what changed? Did someone turn on UAC? Did your network admin impose some new policy or make changes to user accounts?

This is decidedly not normal behavior.

What changed?

 

[TheBlainer]

danfreeman,

My supersivor (who is the network administrator) didn't change anything and this is definitely something wrong on my computer, because we did some tests :

- He logged on his computer with my username (that's working)
- He logged himself on my computer and opened my choixass.dbf that I copied on my C: that I wasn't able to open (also working)

But if I open it with my account on my computer, it doesn't work. My supervisor don't understand how this is possible.

TheBlainer

 

[TheBlainer]

Now another problem happened :

The "autocomplete" isn't working anymore when I'm coding. I mean that when I write thisform and after I put a dot after, nothing happen. So I don't have my list of controls to choose. It's like in earlier version of FoxPro.

I search all over the options and I didn't find anything to put it back. It was there before I uninstalled and reinstalled FoxPro.

TheBlainer

 

[Olaf Doschke]

Menu: Tools->Intellisense Manager. Look, if "Enable Intellisense" is checked. If it is, there might be something wrong with foxcode.dbf, which is the central data for intellisense. This and some more system tables are stored in a users profile, so your problem may be related to that, and you don't delete and reinstall that part of foxpro, if you reinstall foxpro.

Windows also stores cdx or dbf without the co-file, if UAC is turend on and either dbf or cdx in the foxpro home() folder is changed within the VirtualStore subsection of the user profile.

recommendations in regard of foxpro installations since Vista: Install it to C:\Public\ instead of Program Files.

In regard to foxcode.dbf and other files stored in your profile, you can redirect most any such file via Menu: Tools->Options->File Locations tab.

Bye, Olaf.

 

[TheBlainer]

Thank you so much Olaf, I don't know what would I have done without this functionality.

When I clicked on Intellisense Manager (I didn't know that it was that doing the "autocomplete"), a popup appeared and told me that the foxcode.dbf was missing. It also allowed me to restore it by clicking "OK" and "Enable Intellisense" is checked and working ^^

I still have my problem of not opening my choixass.dbf, but this is not big deal. Because I still can use it in my application, so I just have to create a form to be able to see or modify its structure.

TheBlainer

 

[JRB-Bldr]

I have created this table there's few months and there was no problem with it. But today, for no reason it gives me this.
and
My supervisor (who is the network administrator) didn't change anything and this is definitely something wrong on my computer, because we did some tests :

- He logged on his computer with my username (that's working)
- He logged himself on my computer and opened my choixass.dbf that I copied on my C: that I wasn't able to open (also working)

But if I open it with my account on my computer, it doesn't work. My supervisor don't understand how this is possible.

Hmmm...
* Things used to work.
* Nothing has been changed on the network.
* Things work fine for others on their workstations.
* And things work fine under your login on other workstations.
Then what has changed on YOUR computer?

When you attempt to open the data table, is it 'residing' locally on your workstation or on the network?

Good Luck,
JRB-Bldr

 

[TheBlainer]

jrbbldr,

Well, I use to open it on a network drive, but I realized that even if I copied it on my C:, it does the same problem.

Buuuut, I created a simple form that can do MODIFY STRUCTURE AND BROWSE my choixass.dbf like that :

http://www.freeimagehosting.net/cc815

It's working like a charm, so the problem is really not the table, but when I open it with FoxPro.

TheBlainer