2 Replies Latest reply on Sep 20, 2013 3:47 PM by kellert

    FM Go crashes when using a search on a separation model, remotely hosted DB

    jrobgk1

      Summary

      FM Go crashes when using a search on a separation model, remotely hosted DB

      Product

      FileMaker Go

      Version

      12.0.7

      Operating system version

      iPad 2 on iOS 6

      Description of the issue

      On a remotely hosted (in the cloud using a third party vendor), a separation model version of the db is launched on Go. The scripting limits the records viewed to the user's account privileges. When executing a find, Go crashes.  The find is scripted, based on entry into a global search field and the user's account privileges, which are passed to a variable.

      Expected result

      Find generates the correct list of records

      Actual result

      FM Go crashes

        • 1. Re: FM Go crashes when using a search on a separation model, remotely hosted DB
          philmodjunk

               Is it possible to put up a brand new, very small, simple test file on your server and test the same behavior? If you get the same crash, that strongly suggests that the issue lies with the FileMaker software. If you do not, it's possible that there is an issue with this specific file.

               You might also take a copy of the file down off the host machine and use Recover on it to check for issues with your file. Even if recover reports no problems, you might then upload that recovered copy to your server as a test to see if you get a crash.

               Note 1: crashes can damage a file and file damage can cause a crash so it can be difficult to determine which is the cause and which is the effect.

               Note 2: You may have this working beautifully via FileMaker Pro clients and only be getting crashes with the GO clients. This does not absolutely indicate that the file is OK. File damage in rare situations can manifest in crashing or other observable problems only with specific versions of the software or even versions of the OS--and this would also apply to FM GO vs. FM Pro differences in behavior.

          • 2. Re: FM Go crashes when using a search on a separation model, remotely hosted DB
            kellert

                 Matt Petrowski has a filemakermagazine.com article about this in his Data Separation series (part 8). His solution is to have a generic login with no password on the UI (local) file, and a specific user account with appropriate access on the data file (on the server).