5 Replies Latest reply on Feb 9, 2010 11:40 AM by TSGal

    Filemaker 9

    jonack70

      Summary

      Filemaker 9 & 10 crash when adding an external source table

      Description of the issue

      When adding certain tables to my relationship graph that are ODBC external SQL Sources, FM crashes. I am using Current Actual Tech. Drivers and Mac OS 10.6.2 Help!!!  I get the following error: Process:         FileMaker Pro [6625]Path:            /Applications/FileMaker Pro 10/FileMaker Pro.app/Contents/MacOS/FileMaker ProIdentifier:      com.filemaker.client.proVersion:         10.0.3 (10.0.3)Code Type:       X86 (Native)Parent Process:  launchd [3933] Date/Time:       2010-01-03 22:49:15.253 -0500OS Version:      Mac OS X 10.6.2 (10C540)Report Version:  6 Interval Since Last Report:          36195 secCrashes Since Last Report:           4Per-App Interval Since Last Report:  5376 secPer-App Crashes Since Last Report:   3Anonymous UUID:                      313BCC61-3C70-4C29-82F9-2FF1D1E5EE39 Exception Type:  EXC_BAD_ACCESS (SIGBUS)Exception Codes: KERN_PROTECTION_FAILURE at 0x0000000000000084Crashed Thread:  0  Dispatch queue: com.apple.main-thread Thread 0 Crashed:  Dispatch queue: com.apple.main-thread0   ...ilemaker.dbengine.framework 0x01047abc FMODBC::ODBCQuery::NextRow() + 3161   ...ilemaker.dbengine.framework 0x0104b6f5 FMODBC::ODBCQuery::FixupMySQLTypes(Draco::unistring const&, Draco::unistring const&) + 3572   ...ilemaker.dbengine.framework 0x0104d25c FMODBC::ODBCQuery::ColumnInfoOnly(Draco::unistring const&, Draco::unistring const&, Draco::unistring const&) + 8923   ...ilemaker.dbengine.framework 0x010bdcc8 Draco::DBOdbcSource::SQLTableInfo::Initialize(FMODBC::ODBCConnection*, Draco::DBTable const&, Draco::DBFieldCatalog const&, bool) + 5204   ...ilemaker.dbengine.framework 0x010c592e Draco::DBOdbcSource::OnSyncTable(Draco::DBTable&, unsigned int) + 4145   ...ilemaker.dbengine.framework 0x010b004d Draco::DBDataSource::SyncTable(Draco::DBTable&, unsigned int) + 776   com.filemaker.client.pro       0x0021b90e FMDefineTableAliasDialog::GetOdbcTableKey(long, Draco::HBSerialKey&) const + 11027   com.filemaker.client.pro       0x0021bf53 FMDefineTableAliasDialog::OnOK() + 7238   com.filemaker.client.pro       0x00036838 CMacCmdTarget::OnCmdMsg(unsigned int, int, void*, MAC_CMDHANDLERINFO*) + 2969   com.filemaker.client.pro       0x000473d7 XDialog::OnCmdMsg(unsigned int, int, void*, MAC_CMDHANDLERINFO*) + 8710  com.filemaker.client.pro       0x000c56a2 CMacWnd::OnWndMsg(unsigned int, unsigned int, long, long*) + 27411  com.filemaker.client.pro       0x000475ad XDialog::OnWndMsg(unsigned int, unsigned int, long, long*) + 6112  com.filemaker.client.pro       0x000c5e74 CMacWnd::SendWndMsg(unsigned int, void*, void*) + 5213  com.filemaker.client.pro       0x00043ede LCPaneBase::SendNotification(unsigned int, unsigned int, void*) + 15814  com.filemaker.client.pro       0x0003b25a LCPushButton::HotSpotResult(short) + 5815  com.filemaker.client.pro       0x0065bc4e LWindow::ClickInContent(EventRecord const&) + 27816  com.filemaker.client.pro       0x0064bd60 LEventDispatcher::EventMouseDown(EventRecord const&) + 20617  com.filemaker.client.pro       0x000509da CMacEventPump::PreTranslateEvent(EventRecord*) + 18618  com.filemaker.client.pro       0x000508db CMacEventPump::PumpEvent(EventRecord&) + 7519  com.filemaker.client.pro       0x00050e69 CMacEventPump::Run() + 24920  com.filemaker.client.pro       0x0004da88 CMacDialog::DoModal() + 21621  com.filemaker.client.pro       0x0025662a CFMDialog::DoModal() + 10622  com.filemaker.client.pro       0x00219992 FMDefineTableAliasDialog::Begin() + 13023  com.filemaker.client.pro       0x00205115 FMDefineRelationsPage::OnAddTable() + 16524  com.filemaker.client.pro       0x00036838 CMacCmdTarget::OnCmdMsg(unsigned int, int, void*, MAC_CMDHANDLERINFO*) + 29625  com.filemaker.client.pro       0x000477f7 XPropertyPage::OnCmdMsg(unsigned int, int, void*, MAC_CMDHANDLERINFO*) + 8726  com.filemaker.client.pro       0x000c56a2 CMacWnd::OnWndMsg(unsigned int, unsigned int, long, long*) + 27427  com.filemaker.client.pro       0x0004771d XPropertyPage::OnWndMsg(unsigned int, unsigned int, long, long*) + 6128  com.filemaker.client.pro       0x000c5e74 CMacWnd::SendWndMsg(unsigned int, void*, void*) + 5229  com.filemaker.client.pro       0x00043d3e LCPaneBase::SendNotification(unsigned int, unsigned int, void*) + 15830  com.filemaker.client.pro       0x0003b1aa LCBevelButton::HotSpotResult(short) + 5831  com.filemaker.client.pro       0x0065bc4e LWindow::ClickInContent(EventRecord const&) + 27832  com.filemaker.client.pro       0x0064bd60 LEventDispatcher::EventMouseDown(EventRecord const&) + 20633  com.filemaker.client.pro       0x000509da CMacEventPump::PreTranslateEvent(EventRecord*) + 18634  com.filemaker.client.pro       0x000508db CMacEventPump::PumpEvent(EventRecord&) + 7535  com.filemaker.client.pro       0x00050e69 CMacEventPump::Run() + 24936  com.filemaker.client.pro       0x0004d52f CMacPropertySheet::DoModal() + 25537  com.filemaker.client.pro       0x0025490d CFMPropertySheet::DoModal() + 6138  com.filemaker.client.pro       0x001ea383 FMDefineDatabaseDialog::Invoke(Draco::DBFileUser const&, Draco::HBSerialKey const&, bool, int) + 32339  com.filemaker.client.pro       0x001e3c5c DoDefine(FMDocWindow*, unsigned int) + 36440  com.filemaker.client.pro       0x001e65df AppHandleCommand(FMDocWindow*, unsigned int, bool) + 199941  com.filemaker.client.pro       0x001aa06f CFMProApp::OnCommandRange(unsigned int) + 11142  com.filemaker.client.pro       0x00036838 CMacCmdTarget::OnCmdMsg(unsigned int, int, void*, MAC_CMDHANDLERINFO*) + 29643  com.filemaker.client.pro       0x00052aed CMacFrameWnd::OnCmdMsg(unsigned int, int, void*, MAC_CMDHANDLERINFO*) + 14144  com.filemaker.client.pro       0x00033f4d CMacDesktopFrameWnd::OnCmdMsg(unsigned int, int, void*, MAC_CMDHANDLERINFO*) + 4545  com.filemaker.client.pro       0x000c5503 CMacWnd::SendCommandMsg(unsigned int, int) + 13146  com.filemaker.client.pro       0x0007f64e CMacMenuBar::DispatchMenu(long, short) + 9447  com.filemaker.client.pro       0x001a86e3 CFMProApp::Dispatch_MenuSelection(long, short) + 14748  com.filemaker.client.pro       0x001aa59d CFMProApp::Dispatch_MouseDown(XNEventRecord*) + 20549  com.filemaker.client.pro       0x001aa822 CFMProApp::DispatchMouseDown(EventRecord const&) + 5050  com.filemaker.client.pro       0x000508eb CMacEventPump::PumpEvent(EventRecord&) + 9151  com.filemaker.client.pro       0x00050e69 CMacEventPump::Run() + 24952  com.filemaker.client.pro       0x000342b0 CMacApp::Main() + 11253  com.filemaker.client.pro       0x001ac395 main + 3754  com.filemaker.client.pro       0x000035c2 _start + 21655  com.filemaker.client.pro       0x000034e9 start + 41  

        • 1. Re: Filemaker 9 & 10 crash when adding an external source table
          jonack70
            

          I just tried to connect to the MYSQL Database using Windows XP and MYSQL Connector 3.1 ODBC Driver and it worked perfect in FM 9 and FM 10!!

           

          SO the issue to me seems to be MAC Snow Leopard Compatibility Issues. ( and perhaps Actual Technologies Drivers. Are the other drivers for the Mac?)

           

          Help!! Are you aware of the Snow Leopard / Filemaker issues?  

          • 2. Re: Filemaker 9 & 10 crash when adding an external source table
            TSGal

            jonackirv:

             

            Thank you for your posts.

             

            Yes, we have been aware of the ODBC driver not working with Snow Leopard.  A Support Technician and I worked a couple of hours in vain to get a test connection.  Our Development and Software Quality Assurance (Testing) departments are definitely aware of this issue.  Until this is changed, our only solution is to revert to Leopard OS.

             

            If anybody is able to get the ODBC driver working with Snow Leopard, please let us know.

             

            TSGal

            FileMaker, Inc. 

            • 3. Re: Filemaker 9 & 10 crash when adding an external source table
              jonack70
                

              I have heard from Actual Technologies and the issue is more with MYSQL. With MYSQL 4.x, certain field types  (enum or set) cause the failure. Note their response:

               

              <!--  StartFragment  -->
               I'm sorry it's taken me some time to get back to you - I had to do a little research on this issue.  
               
               We're aware of an issue with MySQL 4.x that causes a crash if there is an "enum" or "set" type.  The log file you sent is consistent with this issue.  The problem is happening because MySQL 4 is returning the field width for the type information as 40 characters wide, but, for example, the width of
               
               set('yes', 'no', 'flagged to resend', 'not applicable', 'no school found')
               
               is really 74 characters.  FMP is setting its internal buffers to be big enough to hold 40 characters, MySQL is sending us 74 characters, FMP overruns the buffer by 34 characters, and then *crash*.
               
               There does not appear to be anything we can do in the driver to fix this, since the bad information is coming from MySQL 4 itself.  We're also perplexed as to why this doesn't happen with the Windows versions of the MySQL libraries.  This may be one of the reasons why FMP ESS only officially supports MySQL 5 or later.
               
               Does that sound like your scenario?  If so, I think you have the following options:
               
               1.  Stay with MySQL 4.1 and change the type of the field to be varchar(x), where x is larger than the longest set value (in this case, 17 for 'flagged to resend')
               2.  Switch to MySQL 5 if you can (installed by default on Leopard Server)

              <!--  EndFragment  -->

               





              • 4. Re: Filemaker 9 & 10 crash when adding an external source table
                jonack70
                  

                Thus,

                 

                I did get it to work successfully with MYSQL 4.x by changing the field types from enum to varchar.

                 

                BTW, I was impressed with Actual Technologies Support.

                 

                Thanks.

                 

                • 5. Re: Filemaker 9 & 10 crash when adding an external source table
                  TSGal

                  jonackirv:

                   

                  Thanks for the information.  This should help others who encounter the same problem.

                   

                  TSGal

                  FileMaker, Inc.