6 Replies Latest reply on Oct 1, 2011 3:29 PM by disabled_JackRodgers

    Filemaker Go Crashing and Damaging File

    MatthewMackay

      Title

      Filemaker Go Crashing and Damaging File

      Post

      Afternoon all,

       

      I have been experiencing some issues with my Filemaker Go solution recently and it appears to be getting worse. My solution has been crashing a few times each day. Can't find any consistent reason for the problem. Some times it will be just after taking a photo, sometimes when adding a value to a drop down list and at other time just entering a field.

      Whilst working with my solution today, it crashed just after taking a photo, the file then became damaged and I couldn't open it within Filemaker Go. My solution is used to create property inventories. As I had completed half of the property already, I created a new file on the device and finished off the rest of the house.

      Having travelled back to my office to try and copy over images etc from the newer file in to my recovered file, I found that the last set of photos I had taken before it crashed were gone. The records didn't exist any more. This has affected the final report and therefore my relationship with a client.

      Is there any way to ensure this kind of thing won't happen again or any preventative measures I can take?

       

      Thanks

        • 1. Re: Filemaker Go Crashing and Damaging File
          Jade
           Hi Mathew, What version of FM Go are you using?  It was crashing when taking a photo from a container field but it was fixed in v1.2.1 and v1.2.2.
          • 3. Re: Filemaker Go Crashing and Damaging File
            TSDuck

            Hi Matthew Mackay:

            Thanks for posting.

            From your description of the issue, it’s possible the issue is database corruption.  I have a few questions regarding your solution.

            What is the file size of your database?

            How many records are in your database?

            How many images are in the solution?

            Have you tried creating a compacted copy of your database?

            The next test to try is seeing if a new database file also crashes in FileMaker Go.  Create a new database file in FileMaker Pro.  In this new database, add a few records which have container fields for your images.  Upload the new file to your device, and then try taking photos and see if you can get FileMaker Go to crash.  Let me know if any crashes occur in the new file.

             

            TSDuck

            FileMaker, Inc.

            • 4. Re: Filemaker Go Crashing and Damaging File
              MatthewMackay

              Hi TSDuck,

              The file starts at 5MB, after the full inventory has been completed it can reach up to about 10MB at most. We set the iPad camera to 'small' for capturing the images to limit the size of the database.

               

              There are about 6000 records held within the database.

               

              The number of images depends on the size of the property, it would probably average out at about 70 photos.

               

              I've tried a compacted and non compacted version.

               

              I could try creating a new database but it wouldn't really help with the problem. I'm not saying it's Filemaker Go that's the problem, it probably is something in my solution but as my solution has got quite complex, I need to try and find what's causing these issues in the current database.

               

              Cheers

               

              • 5. Re: Filemaker Go Crashing and Damaging File
                TSDuck

                Matthew Mackay:

                If the issue does not occur in a new database, it could indicate corruption within your database solution.  Since you have tried a compacted copy, the next steps are trying a recovery on your database.  Under the file menu in FileMaker is the option “Recover…” which will run a recovery on the file you select.  Let recovery run and see if it finds any bad blocks within your database.  Afterwards, test if the recovered file experiences crashing in FileMaker Go.  It’s not advised to keep using a recovered database though.  The recovery is meant for recovering the records to add into a new database file. 

                Do you have any backups of your database?  If you do, you should test if any of your backup’s crash in FileMaker Go.  A backup that functions properly can have the most recent records imported into it from the corrupted file.  Let me know if these suggestions help.

                 

                TSDuck

                FileMaker, Inc.

                • 6. Re: Filemaker Go Crashing and Damaging File

                  It takes a bit of doing to create a database in Filemaker that self-destructs but I can from experience tell you that it can be done.

                  Did you specificaly test and debug your database on your GO ios as you created it noting what works and what doesn't work or did you only work in Pro and then throw it at Go without testing it?

                  Created an open URL step in PRO using the Ethernet IP Address on my laptop and it worked great, well it failed nicely, but on GO it brought up a black screen and GO had to be restarted. I am a lifetime member of the Application Busters Guild, "We Can Crash Any File!".

                  I would suggest that when working with Go you use a related file to store the pictures and that you proceed as quietly as possible in that file.

                  Go To Parent Record
                  Set ID into $_ID
                  Go to Photo Table Form layout
                  Create Record
                  Sset linking field to $_ID
                  Commit Record

                  Now all you need to do is touch the container field to take the picture, or something like that. Then save the record again.

                  This works nicely and you notice there is NO complexity, NO custom this or that, NO triggers... NADA

                  Remember, you only have a smidgen of RAM to work in and GO runs slower than a desktop.

                  Heck, if this were really important financially to me I would only use a small, lightweight file to store the pictures and then import them at home. Or even, gasp, use the built in app to take the pictures and save them to the IOS device and then work with them at home.

                  Go works great but you can crash it...