FileMaker tips, techniques, and news.

By Brendan McBride  Posted on  January 19th, 2015  in  FileMaker

Reading FileMaker Crash Reports

FileMaker CrashThough FileMaker crashes are rare, when they do happen, it can be a pain for developers and users alike. They can cause many headaches such as corrupted databases, loss of data, loss of recent development changes, etc. For developers, it can be especially difficult because it is hard to debug and find the cause of the crash as the FileMaker application stops responding after a crash. For those of us using the FileMaker platform to create FileMaker databases, there is not much we can do to fix the cause of the problem. However, we can find what is causing the issue and attempt to work around it. In this article, we will show you how to take advantage of the Mac crash report and the Windows DebugDiag tool to efficiently identify workarounds when FileMaker crashes.

Mac Crash Reports

When a crash happens, you are presented with the option to view the report. The report contains information about the user’s environment and the stack trace at the time of the crash. For a detailed explanation of each part of the report, go to the Apple crash report technical note. For FileMaker developers, the important sections to look into are the process information, basic information, exception information, and the backtrace information, with the backtrace information being the most useful.

The process information and basic information sections are the first two sections of the report. The process information section is where you can find what version of FileMaker the user is currently using.

Mac OS X FileMaker Process Information

The basic information section gives you the Mac OS version the user is on at the time of the crash. You will want to make sure that the user is on a compatible version of the Mac OS. This will only be a concern for FileMaker 12 and prior as FileMaker 13 does not allow users to install on an unsupported OS.

Mac OS X FileMaker Basic Information

The exception information section of the report gives you the crashed thread number. You will want to look at the backtrace of the thread with this thread number.

Mac OS X FileMaker Exception

Backtrace Section

The backtrace section is the most important section of the report. It gives you the list of functions called within a thread with the most recently called at the top starting at 0, and the oldest at the bottom. You will want to look at the 2nd and 4th columns of the backtrace. The 2nd column gives you the application that calls the function. The 4th column is the function being called. You will want to look at any com.filemaker lines starting from the top and work your way down to see what functions are being called. You will want to focus on the functions that make sense to you as a developer. This will give you a list of possible things to try to avoid using in your FileMaker database. In the example provided below, the user reported that their FileMaker would crash but they did not know why. When the user sent the crash report, we were able to see that the FileMaker function calls consistently referenced LayoutMenu. We then made sure that all layouts were not visible in the layout menus. This stopped FileMaker from crashing.

Mac OS X FileMaker Backtrace

Windows Crash Reports

When FileMaker crashes on a Windows machine, the user is not automatically presented with the option of viewing the stack trace at the time the program crashed. In order to view the crash report in Windows, you will first need to download and install the DebugDiag tool from the Microsoft website.

Open the DebugDiag Collection program and add a rule, which will be used to create a crash dump file once FileMaker crashes. To create the rule, you will need to set the rule type as a Crash and the target type as a specific process. You will then select FileMaker out of the list of process names. Please note that FileMaker needs to be running in order to select it out of the list of processes.

Crash Dump File

Windows DebugdiagAfter you have set up the rule, anytime that FileMaker crashes, a dump file will be created in the Userdump Path. Windows dump files cannot be viewed with a standard text editor, because it is a binary file. You will need to open the DebugDiag Analysis program and select “Crash/Hang Analyzers” and add the dump file as the data file. Now you can start the analysis, which will give a break down similar to the Mac crash report including the OS, the thread which caused the exception, and the stack trace. In the example provided below, FileMaker would continuously crash when running a script that printed numerous layouts in rapid succession. When we looked at the crash report, we were able to see that the FileMaker function calls referenced portals and related sets. This gave us the ability to narrow our search of a workaround by investigating the portals on these layouts for possible corruption.

Windows FileMaker Crash Report

Conclusion

The crash report provides valuable information, which can be used to help pinpoint exactly what in your FileMaker database is causing the FileMaker application to crash. Using the crash report allows you to narrow down the possible issues until a real solution is found.

Did you know we are an authorized reseller for FileMaker Licensing?
Contact us to discuss upgrading your FileMaker software.

Brendan McBride thumbnail
Brendan McBride

Brendan is a certified FileMaker and web developer and is a very friendly, hard-working, and technically-astute engineer ready to solve any problem you throw at him. Brendan went to Purdue, receiving a Bachelors in Computer Science and minored in Economics.

FileMaker 18 Certified Developer
FileMaker 17 Certified Developer
FileMaker 16 Certified Developer
FileMaker 15 Certified Developer
FileMaker 14 Certified Developer
FileMaker 13 Certified Developer
FileMaker 12 Certified Developer
FileMaker 11 Certified Developer
"We were actually able to add more features than we thought would be possible within our budget. We always experienced a ‘can do’ attitude and DB Services was incredibly patient and easy to work with."
Courtney Hartman
Art Director
"The new FileMaker custom website interface is very user-friendly and easy to follow for our clients. In addition, it is much faster than the old Instant Web Publishing (IWP) interface. Thank you and all the others who have helped us out at DB Services. I am very grateful for the excellent service you provide us. Its nice to know we can call you for help if we have an issue."
Wayne Capek
President
"We needed a solution that would simplify the administration of our responsibilities under our contract with the State of Indiana. We have seen a dramatic increase across the state in the number of potential foster and adoptive parents that have begun the preparation and training process. This increase has resulted in a significant opportunity for children available for adoption. That’s a big win for everyone! And it’s all because we can refer potential parents to the proper state contacts efficiently and quickly."
Chris Morrison
Executive Director
"Thank you for all of your expertise and valuable help. I am so grateful to have found DB Services."
Linda Findlay
Owner
"Thank you for our new database system. We transitioned from a carbon copy paper based system to a digital database. The software has saved us time and money. We used to archive all our jobs in cabinets, now we can look up a job in seconds from anywhere. The software allows us to easily email estimates to our customers in pdf format. In a year there was a return on investment just from eliminating the purchasing of our carbon forms."
Todd Cartmel
Owner
"The new system allows us to create and track jobs for customers along with inventory, something we had been doing with separate word and spreadsheet files. Because it’s now so intuitive, new staff members are able to begin using the database immediately without our usual training session and ‘cheat sheets’ for getting around within the file."
Tom Andrews
President