Jump to content


Photo

Project in use elsewhere - Data tables problem - Visual FoxPro locking project?


  • Please log in to reply
12 replies to this topic

#1 ams

ams
  • Members
  • 8 posts

Posted 06 April 2016 - 06:13 PM

I can’t open my project in TMG 9.05 UK Gold (Windows 7). I'm a member of the TMG-L message group and it's been suggested there that I join the forum and post here.

 

Here is what happened.

 

Yesterday morning Visual FoxPro stopped working and TMG was automatically closed down. This happens every now and then so I wasn’t concerned. Usually I just reopen TMG, run Optimise, VFI, Optimise and everything seems to run as normal. However, this time is different.

 

Now when I try to open my project  I can't. I seem to have two problems and don’t know whether they’re connected: the 1st is that there is a problem with the data tables in my project and the 2nd is that TMG thinks my project is already open, when it most definitely isn’t. Robin Lamacraft has suggested I post here as he thinks this might be a VFP problem, that VPF has locked my project because of an unfinished process perhaps.

 

Basics are that usually TMG Repair mode has been activated. Initially “Last” (my project) was greyed out so I could only open Sample. Now “Last” = Sample. Have tried opening my project from within the Sample Project (both with sample closed or left open). Have also tried Select from the splash screen. TMG goes to the right folder and I click on my PJC file (I only have two files – Sample and mine – but with 80,000+ in mine.) Then I get a message that indexes and name values are being created. Click OK when it appears.

 

Then one of two things happens

 

a)            Message is “project is in use elsewhere. Please select another project”. But I have nothing else at all open. Have done this multiple times, closed absolutely everything down before trying to open my project, and checked Windows Task Manager which shows nothing except one instance of TMG.

OR

B)            I get a message that an error happened when opening the data tables. Click OK. Nothing opens and I just get a blank TMG screen, or sometimes TMG just closes down. I *think* this message comes when I try to Select the project from the Windows splash screen, rather than when I try to open it from within the Sample Project, but am not 100% sure

 

Things I’ve tried so far with no success:

*Rebooted my computer (not just a restart) x 3

*Copied my project file to another folder then tried to open that (Lee’s suggestion as the copy should close everything down)

*Deleted CDX files from my project folder

*Disabled my anti-virus (Kaspersky)

 

I’d be very grateful for any advice or help at all. (Am in the midst of a major project creating a book, a large journal for Second Site DVD and planning a reunion and about to go overseas so this is a big set-back. I do have a back-up but would lose 15 or so hours of intensive work if I have to restore it, and importantly am not 100% sure that I should try to restore when I don't know what's going wrong.)

 

Regards and thanks

 

Ann



#2 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 07 April 2016 - 08:23 AM

Did you clear the temp folder?

C:\Users\your user account name\AppData\Local\Temp

 

Repair shouldn't be invoked unless the project is actually damaged. I'll do an analysis of your project and repair it if possible if you give me a download link. You can make a zip archive of the projects folder. You can contact me using email by clicking on the link below.

Jim Byram

 

You can make the ZIP smaller by copying the projects folder and deleting the .CDX files and the Sample project files. Then make a zip of the folder.

 

I'd suggest using subfolders under the projects folder for each project. That makes each project easier to deal with when an issue like this comes up.

 

You can test your backup by making a subfolder under the projects folder and restoring to that new folder.

 

If you have no site to upload the project to, you can use Help / Message Manager / Outgoing tab to send the ZIP file to the Wholly Genes server. You don't need to select the compress option since the ZIP file is compressed. Once the file is uploaded, tell me the file name and I'll retrieve it.



#3 ams

ams
  • Members
  • 8 posts

Posted 07 April 2016 - 03:16 PM

Jim, thanks very much for this. It’s very much appreciated.

 

I'll prepare my projects folder now. It does have subfolders - just one for my project and two for sample (?) ... I didn't realise that there were two for sample until yesterday, but will delete them from the copy I prepare.

 

I can’t find the AppData/Temp folder you mention.

I have Windows 7 Pro, partitioned into C and D drives. In the C drive under Ann there is CD95F661A5C444F5A6AAECDD91C240B7.TMP but no AppData folder.

In the d drive I have Users/Ann/Documents/The Master Genealogist v9

 

Regards

Ann



#4 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 07 April 2016 - 03:43 PM

The appdata folder is hidden. From Windows Explorer, you need to find the folder options and, on the view tab, enable show hidden files. You can do a Google search on how to 'show hidden files' to get a step-by-step procedure.



#5 ams

ams
  • Members
  • 8 posts

Posted 07 April 2016 - 06:07 PM

Thanks Jim. Have found it. There are 15,000+ files and 1,000+ folders in it! Have deleted them now. (I thought these files would normally be deleted when defragmenting the drive but will check my settings for that now.)

Have also uploaded the Projects folder 

Ann



#6 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 07 April 2016 - 06:33 PM

The Windows system tool Disk Cleanup will clean the temp folder. You really want to run Disk Cleanup on a regular basis. The free utility CCleaner will do so as well. And, as you found, you can do it manually.



#7 ams

ams
  • Members
  • 8 posts

Posted 07 April 2016 - 09:43 PM

Thanks for this Jim. Have been busily cleaning up both drives. And I did try again to open my project  after the temp folder was cleaned out but still get the message "an error happened when opening the the data tables ...". I can't expand the dialogue box to see whether anything comes after the "...".



#8 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 09 April 2016 - 07:25 AM

Six of the data tables in Ann's project had damaged headers. Once those were fixed, the project opened with no issues.



#9 John Cardinal

John Cardinal
  • Senior Members
  • 835 posts
  • Location:North Andover, MA

Posted 09 April 2016 - 02:00 PM

Jim,

 

Were the damaged headers something Visual FoxPro fixes? If not, what did you use to fix them? Thanks.



#10 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 09 April 2016 - 06:19 PM

Answered by PM.



#11 hartnettjr

hartnettjr
  • Members
  • 2 posts

Posted 25 April 2016 - 05:43 AM

Just happened to me. Last night as I was closing down a day of work, and as I always do I re-indexed and optimized. Then when I clicked Validate File Integrity, the first warning dialogue box opened (warning about the time it will take to validate), clicked okay, but the second dialogue box which usually opens asking about checking external exhibits did not open and the Validate process did not begin. So I tried to start Validate again and received the "Project in use elsewhere warning." I would get this warning when trying any file activity, even backing up, so I exited and restarted the program. Now I receive an error message that the "XXXX_P.dbf file is not found." I can open the sample project or restore a backup (though the program now opens in repair mode). There is about ten hours of work since my last backup - not a disaster but of course I don't remember all the items I worked on since then.

The "missing" dbf file is right there in the project folder, but with a date stamp about 24 hours earlier than the other files (when I had backed up and closed down the night before). I tried emptying the Temp folder but no change. The project is in its own folder and all exhibits are external. Thanks for any ideas on this.

Vince Hartnett

 



#12 hartnettjr

hartnettjr
  • Members
  • 2 posts

Posted 25 April 2016 - 08:34 AM

I should have added that I also tried deleting 29 .cdx files from the project folder without success.

Vince Hartnett

www.syngeneia.org



#13 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 25 April 2016 - 09:51 AM

If you send me the project, I'll check it for damage and see if it can be recovered. You should make a ZIP archive of the project folder and send that. If the ZIP file is too large to email, you'll need to put it on a server where I can download it. Deleting the .CDX files before making the ZIP file will reduce the ZIP file size considerably.

 

You can contact me by email by clicking of the link above in post #2.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users