AnsweredAssumed Answered

FMP9 crashes on ODBC import performed in script

Question asked by JaredMilbank on Oct 28, 2010
Latest reply on Jan 12, 2011 by JaredMilbank


FMP9 crashes on ODBC import performed in script


FileMaker Pro



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:  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: ModName: ntdll.dll ModVer: 5.1.2600.5512 Offset: 00042b9f

Configuration information

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


Try again until it works.