14 Replies Latest reply on Sep 27, 2016 9:07 AM by TSGal

    FMS 15 Tries to back up Closed databases

    alex_zueiv

      FileMaker Server 15.0.1

      Mac OS X 10.11.5

      iMac 21.5"

       

      Description

       

      When I run a schedule to back up All Databases, FMS 15 logs errors if some databases are closed. The log shows error messages:

       

      Could not back up database "<file_name>" because it is in incorrect state: Closed.

       

      …for every closed database. FMS 14 did not show such errors. I don't see such messages in old records, logged by FMS 14.

       

       

      How to replicate

       

      Close some databases and run the schedule Hourly Backup.

        • 1. Re: FMS 15 Tries to back up Closed databases
          TSGal

          alex_zueiv:

           

          Thank you for your post.

           

          I am unable to replicate the issue with FileMaker Server 15.0.1 under Mac OS X 10.11.5 (and Windows Server 2012).  This is what I did:

           

          1. I uploaded five files to FileMaker Server 15.0.1.

          2. I ran the Hourly Backup schedule.  This worked.

          3. I closed one of the database files.

          4. I ran the Hourly Backup schedule.  Only the four files (and sample file) were mentioned.  No mention of the closed file.

          5. I ran the Daily Backup schedule.  Only the four files were mentioned.

          6. I opened the closed file.

          7. I ran the Daily Backup schedule.  All files were mentioned.

           

          Let me know what I am doing differently than you so I can replicate the error.

           

          TSGal

          FileMaker, Inc.

          • 2. Re: FMS 15 Tries to back up Closed databases
            alex_zueiv

            TSGal,

             

            That is very strange. I've got the same error in FMS 15 for Windows, installed under virtual machine.

             

            I've reinstalled FMS 15 for Mac several times:

             

            Clean installations

            Everything uninstalled, including Java

            The folder /Library/FileMaker Server removed

            Computer restarted

            Two different installers: fms_15.0.1.137.dmg and fms_trial_15.0.1.137.dmg

            With VLA and Trial license keys

            Everything left by default at the Deployment stage

            Only one, new Test file uploaded to the server and then closed

             

            Nothing helps. When I run the Daily schedule I'm sable getting the Error 824:

             

            Could not back up database "Test" because it is in incorrect state: Closed.

             

            When all databases are closed, including the file FMServer_Sample, the message is correct:

             

            Error 2 Schedule "Daily" aborted; no open databases to operate on.

             

            I've attached my log files. Maybe that can help you to figure out what is going on here?

            • 3. Re: FMS 15 Tries to back up Closed databases
              TSGal

              alex_zueiv:

               

              I see the error in your Event.log.  I ran the test again, and interestingly, the error now appears in my Event.log.  I looked in the Event.log for last Friday to make sure I didn't miss anything, and the error does not appear.

               

              I have sent your posts and findings to our Development and Testing departments for review.  When I receive any feedback, I will let you know.

               

              TSGal

              FileMaker, Inc.

              • 4. Re: FMS 15 Tries to back up Closed databases
                TSGal

                alex_zueiv:

                 

                Testing is able to reproduce the issue only when the option "Host password-protected database only" is enabled in the Admin Console under the Database Server -> Security -> Require Password-Protected Databases

                 

                Can you verify?

                 

                TSGal

                FileMaker, Inc.

                • 5. Re: FMS 15 Tries to back up Closed databases
                  TSGal

                  alex_zueiv:

                   

                  Another tester was able to reproduce the issue even when the option was disabled.  Therefore, there is another factor.  Testing is investigating this further.  Before posting again, I will wait until I have a definitive answer.

                   

                  TSGal

                  FileMaker, Inc.

                  • 6. Re: FMS 15 Tries to back up Closed databases
                    TSGal

                    alex_zueiv:

                     

                    Testing would like all of your log files.  I have sent you a private message with instructions how to obtain the files.

                     

                    TSGal

                    FileMaker, Inc.

                    • 7. Re: FMS 15 Tries to back up Closed databases
                      TSGal

                      alex_zueiv:

                       

                      Your log files have been forwarded to me.  Thank you.

                       

                      I have sent the log files to Development and Testing for review.  When I receive any feedback, I will let you know.

                       

                      TSGal

                      FileMaker, Inc.

                      • 8. Re: FMS 15 Tries to back up Closed databases
                        user27239

                        Hi, I'm having the same error with a database that can't open, the database "Workflow" is password protected and works fine under Filemaker Pro 14 server but not under a new Filemaker Pro 15 fresh install on a virtual Windows 2012 R2 server.

                        Server Events

                        Error

                        1017

                        SECURITY: Database "Workflow" cannot be opened because it is insecure. Require Password-Protected Databases is enabled.

                         

                        Thanks,

                        Fernando.

                        • 9. Re: FMS 15 Tries to back up Closed databases
                          TSGal

                          user27239:

                           

                          Your issue is different from the original poster.  This message usually occurs if any of the passwords are empty.  Close the file on the server, copy the file to a local computer, open the file with FileMaker Pro 15, go into Manage Security and verify all passwords.  Once finished, then upload to FileMaker Server 15.

                           

                          TSGal

                          FileMaker, Inc.

                          • 10. Re: FMS 15 Tries to back up Closed databases
                            TSGal

                            alex_zueiv:

                             

                            Testing has looked at your Events.log and have the following comments:'

                             

                            1. Events.log indicate that the OS energy settings are enabled, as this would cause FileMaker Server to sleep.  Recommendation is to disable.

                             

                            2. The automatic opening of database files is disabled.

                             

                            3. The Admin executes a backup schedule before opening the files and receives the error 824.

                             

                            TSGal

                            FileMaker, Inc.

                            • 11. Re: FMS 15 Tries to back up Closed databases
                              gambol13

                              Just want to add a me too to this issue.

                               

                              Description of the problem is the same, and after reading the comments from testing, I shut down all energy settings on the server, confirmed automatic opening of database files is enabled, manually ran the backup schedule and indeed got error 824 on the closed databases.

                               

                              dave

                              • 12. Re: FMS 15 Tries to back up Closed databases
                                user27239

                                Thanks for you prompt answer. All the files have a password, that’s how they are in the FM14 server. I just copy the files to the new FM15 server and all worked except for this one. The files have the Admin (local) password and an External Server account. All other databases are the same.

                                 

                                I haven’t been able to open this database.

                                 

                                 

                                 

                                 

                                 

                                Regards,

                                Fernando

                                • 13. Re: FMS 15 Tries to back up Closed databases
                                  user27239

                                  I was able to open the database, I disable the “Host password-protected databases only” setting, then I opened the database and enable the setting again. The database is back to normal.

                                   

                                   

                                   

                                   

                                   

                                  Regards,

                                  Fernando

                                  • 14. Re: FMS 15 Tries to back up Closed databases
                                    TSGal

                                    All:

                                     

                                    This issue with Error 824 has been addressed in FileMaker Server 15.0.2.

                                     

                                    TSGal

                                    FileMaker, Inc.