3 Replies Latest reply on Oct 14, 2013 1:42 AM by JonJ

    Filemaker Pro database not opening

    JamesLuft

      Title

      Filemaker Pro database not opening

      Your post

           There was a server crash today. Since then, the databases that I can see in the FMP Admin manager sees all of the databases but they are all stuck on OPENING. I cannot access any but 1 from the REMOTE option in FMP on the client computer. Any help would be appreciated. It's dire so any phone calls would be great 570-592-8215.

        • 1. Re: Filemaker Pro database not opening
          JonJ

               Hi.

               Sound like one or more of the databases were damaged during the crash.

               Stop the filemaker server (if the java GUI doesn't respond, you can use the command line, http://www.filemaker.com/support/product/docs/12/fms/fms12_help.pdf )

               Open each database directly from a filemaker client using File->Recover. This will scan the database, fix any issues, and save the repaired copy as a new file.

               It might tell you that you can't trust the file going forward, and you'll need to use an uncorrupted back-up copy (from before the crash)--empty it of data and then import the latest data from your recovered copy.

               In any case, the recovery process generates a big log file that you can scan through to see where any problem lie (hint: any line that doesn't have an error code of 0).

               It's a bit of a pain, and can take a couple of hours (depending on the size of your dataabses) but users are usually understanding if they can see you are working towards a solution.

               Good luck,

               J.

                

                

          • 2. Re: Filemaker Pro database not opening
            philmodjunk

                 It could also be that that Server is running a consistency check on each do to the uncontrolled close of the files. With gigabyte sized files, it can take a long time for just one such file to complete a consistency check. You may find that after a long wait, the files go ahead and either open or report damage to the file.

            • 3. Re: Filemaker Pro database not opening
              JonJ

              > It could also be that that Server is running a consistency check on each do to the uncontrolled close of the files.

              This is true—server-side consistency checks seem to take forever and a day compared to their client-side equivalents.