Sign in to follow this  
Followers 0
Rick Whitelaw

mac
Recover Question

8 posts in this topic

Hi,

 

     I have a small issue that's been nagging at me for a while. One file in a multi file solution fails Recover. The file functions perfectly. Some years ago when running Recover I started noticing a pattern FM would attempt to recover Table " " then create a new table "Recover". It also created a field "Recover" in two tables. If I open the Recovered file and delete these three items, then run Recover on the copy the file gets a clean bill of health. Even my oldest backups of this file (when it was tiny) show the same problems so I don't have a clean backup. 

     I've never used a Recovered file. Now I'm trying to decide whether to just leave good enough alone and continue with the original file, or trust the clean bill of health of the "Recovered Recovered" file. Any thoughts would be most welcome.

 

Rick.

Share this post


Link to post
Share on other sites

Hi Rick,

 

Sorry to hear about the file.  My sense would be to rebuild it but I also realise that will take some work - you indicated 'when it was small' so I assume it would be a large undertaking now?  

 

Have you experienced any other crashes with it?  If not then maybe I would keep going with it while I planned a complete rebuild, such as 13 would be perfect time.

 

It would be a tough call, for sure.

Share this post


Link to post
Share on other sites

Hi,

 

No crashes. No problems whatsoever. Consistency check is fine. The supposed corruption has been there for years. I'm sorely tempted to use the double recovered file.

Share this post


Link to post
Share on other sites

Sorry for the late reply

 

Your "problem" is covered here:  http://fileshoppe.com/recover.htm

 

The addition of a "recover' table is a new "cleanup" step, that does not by itself mean the file is damaged

 

greg

Share this post


Link to post
Share on other sites

The only thing I would question, Greg, is that a Recover normally does *NOT produce this recover table occurrence.  So when it DOES appear, it indicates to me that it has found something (at least) questionable.  And when Recover finds something questionable, it can mark those areas as bad even if they aren't (meaning it takes aggressive action to scrub it and the scrub itself can damage).  And this is why files should not be used after a Recover (even if no Recover Library is produced).

 

I would consider the file damaged if I saw Recover Library table appear.  That does not mean I'd trash the file immediately but it would be high on my list to rebuild it as quickly as possible (immediately if I have good backup).  The same holds true if I see a Recover log appear.  It usually indicates the files was improperly closed and that can damage a file.

 

Now in 13 with Web Direct, a recover log is created when you upload the file (which drives me nuts) so that is the only exception where a recover log wouldn't cause me to dump a file and step back.  Folks seem to forget that the pristine nature of the files in a solution are CRITICAL.  It is very difficult to rebuild a file.  It is very simple to hold oneself to extremely high standards of file protection.  I am a LION not a cat when it comes to protecting files.  Once damaged, they can cause problems until the end of time.

 

Added ---  * you can test whether Recover Library is generated by creating a new file with a few fields, close it then run recover on it.  Really good files do not produce this Recovered Library table occurrence - only files with damage.  At least this is my observation.

1 person likes this

Share this post


Link to post
Share on other sites

Again, sorry for the late reply

 

I asked this exact question to FileMaker's Clay Maeckel at DevCon,  and he assured me that "it is not by itself an indication of corruption, since Library data can get "stranded", even in a "healthy" file"

 

He went on to explain that it is very similar to uninstalled Windows Applications,  that leave behind "orphan" DLL's,  that are harmless

 

greg

Share this post


Link to post
Share on other sites

That is good to know, Greg.  But still, if you improperly close a file, it WILL generate the recover table.  And if a file is closed improperly then it DOES indicate that it should be replaced with a good prior copy.

 

So it, by itself, may not indicate corruption but the logic still says that, if you are not sure it is okay, assuming corruption and replacing it is the best strategy.

 

And that is why designing on copies of the original and then moving the functionality into a pristine copy of the master and designing locally as much as possible are still best suggestions.  And seeing the recover library, unless you are SURE it did not close improperly or experience connection drop, should still be treated as trashed.

Share this post


Link to post
Share on other sites

This is an old thread. A couple of comments . . . The Recover process ALWAYS generates a Recover Log. As far as Recover adding a table "Recover" I have no idea what's up with that. However it does not generate this when running Recover on a Compacted Copy. It will also add fields named "Recover". I believe that rebuilding the tables in which these fields are inserted IN THE ORIGINAL FILE may solve this problem. In my case, Recover inserts this field in two tables. Rebuilding these would be much easier than blindly rebuilding the entire file. I haven't done it though. These fields are created to match data apparently (data that doesn't exist).

My two cents,

Rick.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • By bioplasma
      Recently i change my office PC to a Mac Laptop since is much more accessible for me. After getting Filemaker 12 for it, I try running the copy I have of FM starting point and this what happens.
      I will appreciated any help I can get to resolve this 
       
      Thank you
       
       

    • By busch
      I'm using FM Advanced 14.0.1 and this strange button appears at the bottom of my pop-us and then disappears.  It's inconsistent and only occurs on some of my pop-ups, but not all.  Has anyone seen anything like this?
       

    • By Chris Christou
      Announcing Youmehub (BETA), CRM Software for the Mac

      One app to manage all your contacts, opportunities, email campaigns, appointments, tasks, documents, call notes and much more. An ideal CRM solution to help small businesses and sole traders who want to stay organised and be more productive.
      Download the 30 day trial BETA at www.youmehub.com

      People & Organisations
      Capture and manage all your contacts, prospects, customers and partners in one central database.
      Roles & Relationships
      Link people and organisations together and manage their roles and relationships.
      Track Communications
      Track and manage notes and communications and more with your contacts.
      Opportunity Management
      Manage opportunities and track the sales progress with customisable sales pipelines.
      Marketing Mail
      With the integrated mMail module you can create groups, build marketing campaigns and easily send targeted bulk email and letters directly from Youmehub.
      Manage Tasks and Appointments
      Keep tabs on what needs to be done. Tasks and Appointments can be linked to contacts and assigned to specific users.

      Notice to beta testers
      You are invited to download and try this beta software. Please keep in mind that this is beta software, and therefore may contain bugs. Please report any problems or send us your feedback using the contact form on our website.
    • By Productive Computing, Inc.
      San Diego, CA - April 12, 2016 - Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, is proud to announce the release of Vessel Service Solutions (VSS) version 2. This vertical solution was designed for the marine assistance industry and operates as a virtual command center to manage vessel assistance orders. VSS version 2 offers additional features and modules, a completely redesigned UI, and improved processes for users.  
       
      What is VSS?
      VSS was built with a “paperless and efficient” philosophy and allows users to fully digitalize the entire tow order process from beginning to end. As soon as distress calls are received, dispatchers have the ability to send mobile orders straight from the office to in-field captains. The captain receives the order on an iPad and, after assisting the boater, updates and submits the order to dispatch for final processing. VSS also allows invoices and items to be pushed directly to QuickBooks via the FM Books Connector. 
       
      What's New? 
      VSS version 1 provided companies with a customizable framework they could employ to achieve a paperless solution. Version 2 has been crafted with industry input and takes the entire tow order process to the next level by offering the user a truly comprehensive solution. Dispatch can send, receive, and submit orders for payment without printing a single document. Using FileMaker Go, captains can receive, update, and send orders from their iPads. They can even perform data entry while at sea without an internet connection. Version 2 has expanded functionality to allow users to maintain fuel logs, maintenance logs, maintenance schedules, time sheets, and pull various reports.
       
      As with most FileMaker products, this solution allows for customization, including the ability to personalize all terms, disclaimers, notes and signature requirements, company information, tower ID, and company logo in the modules.  
       
      "We're quite excited about the new and improved VSS, because this dynamic solution enables users to efficiently and digitally dispatch, track, and manage tow orders, eliminating the need for time-consuming paperwork, resulting in improved accuracy and turnaround time. We've had a lot of support from industry leaders, and we're pleased to be delivering something we think will continue to greatly help the boat towing industry" - Marc Larochelle, Chief Executive Officer, Productive Computing, Inc. 
       
      For more information please visit www.vesselservicesolutions.com. Have additional questions? Contact sales@productivecomputing.com or 760-510-1200. 
       
      FileMaker Pro Support and Plug-in Integration:
      Do you have database enhancements you would like to have programmed?  Want help getting a plug-in professionally installed into your FileMaker solution?  We can help! The process is easy - complete our online Request For Quote form (RFQ) or call us directly at (760) 510-1200 and one of our certified developers can work with you on improving your solution today.
       
      About Productive Computing, Inc.
      Since 1996, Productive Computing, Inc. has been helping its customers become more efficient and profitable by implementing custom software solutions using FileMaker Pro. Utilizing FileMaker Pro as a rapid application development tool, their certified FileMaker developers can create custom applications that a business can run on their Windows or Macintosh desktop computers, in a web browser, on an iPad or iPhone or shared simultaneously on all of these platforms.
       
      Productive Computing, Inc. also produces several off-the-shelf productivity solutions such as Core4 CRM, Music Director Pro, and Vessel Service Solutions, as well as a suite of FileMaker Pro plug-ins that allow FileMaker Pro to integrate with third party applications including Outlook, QuickBooks, Apple's Address Book and Calendar, PDF forms, digital signatures, and biometric fingerprint scanners.
       
      In addition to building custom and off-the-shelf FileMaker Pro solutions and plug-ins, Productive Computing, Inc. is a full service FileMaker Pro hosting company. FileMaker hosting services allow customers to host their own FileMaker Pro solutions on Productive Computing servers in the cloud instead of purchasing and supporting the necessary server infrastructure themselves. These same servers also provide the infrastructure for customers who would prefer to subscribe to Productive Computing's Core4 CRM and Vessel Service Solutions products under a SaaS (Software as a Service) pricing model.
       
      Productive Computing, Inc. is one of only a few companies in the United States to have earned the highly respected platinum level membership within the FileMaker Business Alliance and recently won the exclusive FileMaker Business Alliance "Partner of the Year" award.
       
       
      Productive Computing, Inc.
      950 Boardwalk, Suite 205
      San Marcos, CA 92078
      www.ProductiveComputing.com
      sales@productivecomputing.com
      (760) 510-1200
       
      Press Contacts:
      Productive Computing, Inc.
      Keith Larochelle
      (760) 510-1200
       
      # # #
      ---------------------------------------------------
    • By SHMUEL
      Hello,
      I have a small problem before importing an Excel file in Filemaker
      As I run a macro on Windows all goes well the work is done corectement to use the file to import into Filemaker
      But on Mac that does not work I tried with several Excel and of course Windows Excel for Mac
      I think this is the path for the error message, this is the way:
      sPath = "C: \ input \"
      Thank you