4 Replies Latest reply on Jan 12, 2011 4:33 PM by JaredMilbank

    FMP9 crashes on ODBC import performed in script

    JaredMilbank

      Summary

      FMP9 crashes on ODBC import performed in script

      Product

      FileMaker Pro

      Version

      9v2

      Operating system version

      Windows XP Pro

      Description of the issue

      Importing from an Oracle db into a Filemaker9 db on FMServer 9 as a step in a script can cause FileMaker to crash with the standard Windows termination message (details in error section).

      The same crash can occur when editing the script step that does the import: clicking on the "specify" will precipitate the crash.

      The problem is somewhat intermittent: across a number of databases, there are some when it happens most of the time and some where it does not appear to occur at all.  The longer FMP has been open, the more likey it is to occur: restarting after a crash and doing the import immediately sometimes works.

      It may be that the database size is a factor: importing from a table of 10k or more records into a mostly populated table of the same size seems more likely to crash.

      Steps to reproduce the problem

      Run a script with an import step.

      Expected result

      Records imported successfully from external db to FileMaker.

      Actual result

      FileMaker crashes without importing anything.

      Exact text of any error message(s) that appear

      FileMaker Pro Advanced.exe has encountered a problem and needs to close.  We are sorry for the inconvenience.  If you were in the middle of something, the information you were working on might be lost.  For more information about this error, click here.

      Error signature.
      AppName filemaker pro advanced.exe AppVer: 9.0.2.206  ModName oraldapclnt9.dll ModVer 9.2.06 Offset: 00002cc8.

      THe dialog appears a second time with the following error signature.
      AppName: filemaker pro advanced.exe AppVer: 9.0.2.206 ModName: ntdll.dll ModVer: 5.1.2600.5512 Offset: 00042b9f

      Configuration information

      Import from an Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi via Oracle ODBC driver in OraHome92 version 9.02.00.65

      Workaround

      Try again until it works.